At last the long hot days came to nearly over.
\nI’m takeken, How are you doing?<\/p>\n
A survey on a mysql slow queries was using the Mysqldumpslow, and I would like to use the Qt-digest on a whim.<\/p>\n
How to install.<\/p>\n
This is simple enough.<\/p>\n
\r\nsudo rpm -ivh https:\/\/www.percona.com\/downloads\/percona-toolkit\/2.2.14\/RPM\/percona-toolkit-2.2.14-1.noarch.rpm\r\n<\/pre>\nthat’s all.<\/p>\n
well.<\/p>\n
How to use.<\/p>\n
\r\nsudo pt-query-digest \/to\/path\/slow.log > digest.txt\r\n<\/pre>\nOK?<\/p>\n
And, let’s “crontab -e”<\/p>\n
OK?<\/p>\n
Let’s An email comes on the next morning.<\/p>\n
In mysqldumpslow case.<\/p>\n
\r\nCount: 1 Time=0.02s (0s) Lock=0.00s (0s) Rows=0.0 (0), wpdata[wpdata]@localhost\r\n SELECT v.postid AS id FROM wp_popularpostsdata v WHERE NOT EXISTS (SELECT p.ID FROM wp_posts p WHERE v.postid = p.ID)\r\n\r\nCount: 6 Time=0.01s (0s) Lock=0.00s (0s) Rows=1.0 (6), wpdata[wpdata]@localhost\r\n SELECT COUNT(*) FROM wp_comments WHERE user_id = N AND comment_approved = N\r\n<\/pre>\nLook at result, Very simple.<\/p>\n
In qt-query-digest case.<\/p>\n
\r\n# 4.4s user time, 100ms system time, 25.77M rss, 113.67M vsz\r\n# Current date: Thu Aug 27 04:00:06 2015\r\n# Hostname: vincentina\r\n# Files: \/var\/lib\/mysql\/slow.log\r\n# Overall: 6.79k total, 17 unique, 0.08 QPS, 0.00x concurrency ___________\r\n# Time range: 2015-08-26 04:00:43 to 2015-08-27 04:00:00\r\n# Attribute total min max avg 95% stddev median\r\n# ============ ======= ======= ======= ======= ======= ======= =======\r\n# Exec time 11s 142us 215ms 2ms 5ms 4ms 626us\r\n# Lock time 1s 22us 13ms 160us 247us 282us 131us\r\n# Rows sent 79.57k 0 601 12.00 6.98 74.00 0.99\r\n# Rows examine 2.39M 0 4.20k 369.89 755.64 343.78 381.65\r\n# Query size 2.34M 31 1.14k 361.14 833.10 261.10 313.99\r\n<\/pre>\nWow!, full of letter. Since the smartphone screen is small , it is the meaning is difficult to understand.
\nqt-query-digest have rich content, but I knew so that email on smartphone is difficult read.<\/p>\nsomething like that.<\/p>\n