{"version":"1.0","provider_name":"Jui-Nan Lin's Blog","provider_url":"https:\/\/jnlin.org","author_name":"jnlin","author_url":"https:\/\/jnlin.org\/author\/jnlin\/","title":"\u4f7f\u7528 pt-stalk \u627e\u51fa MySQL \u6548\u80fd\u554f\u984c","html":"

pt-stalk<\/a> \u662f Percona Toolkit for MySQL<\/a> \u88e1\u9762\u7684\u5176\u4e2d\u4e00\u9805\u5de5\u5177\u3002\u5b83\u6703\u9023\u5230 MySQL Server\uff0c\u76e3\u63a7\u6307\u5b9a\u7684\u6578\u503c\uff0c\u7576\u8d85\u904e\u6307\u5b9a\u7684 Threshold \u6642\uff0c\u6536\u96c6\u7576\u6642\u8cc7\u6599\u5eab\u57f7\u884c\u7684\u8cc7\u8a0a\uff08\u5305\u542b\u6b63\u5728\u9032\u884c\u7684 transaction\u3001vmstat\u3001lsof\uff0c\u751a\u81f3 gdb stack trace\uff09\uff0c\u65b9\u4fbf\u5206\u6790\u89e3\u6c7a\u554f\u984c\u3002<\/p>\r\n

pt-stalk \u9700\u8981\u4ee5 root \u6b0a\u9650\u57f7\u884c\u3002\u57f7\u884c\u7684\u65b9\u6cd5\u5982\u4e0b\uff1a
\r\n
\r\npt-stalk --daemonize --variable Threads_connected --threshold 400 -- --defaults-file=\/etc\/mysql\/my.cnf
\r\n<\/code>
\r\n\u7576\u540c\u6642\u6709 400 \u4ee5\u4e0a\u7684 Threads \u6642\uff0c\u4fbf\u6703\u6536\u96c6\u8cc7\u6599\uff0c\u5b58\u5230 \/var\/lib\/pt-stalk<\/code> \u5167\u3002\u6536\u96c6\u7684\u8cc7\u6599\u7bc4\u4f8b\uff1a<\/p>\r\n

2014_01_13_00_25_09-df              2014_01_13_00_25_09-lock-waits      2014_01_13_00_25_09-netstat         2014_01_13_00_25_09-ps\r\n2014_01_13_00_25_09-disk-space      2014_01_13_00_25_09-log_error       2014_01_13_00_25_09-netstat_s       2014_01_13_00_25_09-slabinfo\r\n2014_01_13_00_25_09-diskstats       2014_01_13_00_25_09-lsof            2014_01_13_00_25_09-opentables1     2014_01_13_00_25_09-sysctl\r\n2014_01_13_00_25_09-hostname        2014_01_13_00_25_09-meminfo         2014_01_13_00_25_09-opentables2     2014_01_13_00_25_09-top\r\n2014_01_13_00_25_09-innodbstatus1   2014_01_13_00_25_09-mpstat          2014_01_13_00_25_09-output          2014_01_13_00_25_09-transactions\r\n2014_01_13_00_25_09-innodbstatus2   2014_01_13_00_25_09-mpstat-overall  2014_01_13_00_25_09-pmap            2014_01_13_00_25_09-trigger\r\n2014_01_13_00_25_09-interrupts      2014_01_13_00_25_09-mutex-status1   2014_01_13_00_25_09-processlist     2014_01_13_00_25_09-variables\r\n2014_01_13_00_25_09-iostat          2014_01_13_00_25_09-mutex-status2   2014_01_13_00_25_09-procstat        2014_01_13_00_25_09-vmstat\r\n2014_01_13_00_25_09-iostat-overall  2014_01_13_00_25_09-mysqladmin      2014_01_13_00_25_09-procvmstat      2014_01_13_00_25_09-vmstat-overall\r\n<\/pre>\r\n
\u7136\u5f8c\u770b InnoDB status\uff0c\u53ef\u4ee5\u770b\u5230\u5f88\u591a transaction \u6b63\u5728\u7b49 query cache lock\uff1a
\r\n
\r\n MySQL thread id 688253701, OS thread handle 0x7f6a591c9700, query id
\r\n 19004545452 10.1.1.94 pixblog Waiting for query cache lock
\r\n SELECT * FROM `blogarticle` WHERE (`blogarticle_blogid` = 3835626) AND
\r\n (`blogarticle_date` < 1388605724) AND (`blogarticle_status` IN (2,3,5,7))
\r\n ORDER BY `blogarticle_date` desc, `blogarticle_id` desc LIMIT 1
\r\n ---TRANSACTION 144B7B32FC, not started
\r\n MySQL thread id 688253702, OS thread handle 0x7f6a787bc700, query id
\r\n 19004544621 10.1.1.191 pixblog Waiting for query cache lock
\r\n SELECT * FROM `blog` WHERE `blog_id` = 3126963
\r\n ---TRANSACTION 144B7B32FD, not started
\r\n MySQL thread id 688253706, OS thread handle 0x7f6a887e2700, query id
\r\n 19004544620 10.1.1.166 pixblog Waiting for query cache lock
\r\n SELECT * FROM `bloglayout` WHERE `bloglayout_id` = 3063007
\r\n ---TRANSACTION 144B7B33C7, not started starting index read
\r\n mysql tables in use 1, locked 0
\r\n<\/code><\/p>\r\n
\u767c\u751f\u554f\u984c\u7684\u7576\u6642\u78ba\u5be6\u6709\u4e00\u500b\u8dd1\u7d71\u8a08\u5831\u8868\u7684 Slow Query \u6b63\u5728\u57f7\u884c\uff0c\u65bc\u662f\u8981\u6c42\u8a72 Query \u4e0d\u4f7f\u7528 Query Cache1<\/a><\/sup> \u4f86\u89e3\u6c7a\u554f\u984c\u3002
\r\n<\/p>\r\n","type":"rich"}