{"id":23,"date":"2012-02-19T15:30:44","date_gmt":"2012-02-19T14:30:44","guid":{"rendered":"http:\/\/blog.jeremm.fr\/?p=23"},"modified":"2014-09-24T22:16:32","modified_gmt":"2014-09-24T20:16:32","slug":"percona-toolkit-query-digest","status":"publish","type":"post","link":"https:\/\/blog.jeremm.fr\/?p=23","title":{"rendered":"Percona toolkit query-digest"},"content":{"rendered":"<h4>Installation :<\/h4>\n<p>Debian :<\/p>\n<pre lang=\"bash\">gpg --keyserver  hkp:\/\/keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A\r\ngpg -a --export CD2EFD2A | apt-key add -\r\necho \"deb http:\/\/repo.percona.com\/apt lenny main\" >> \/etc\/apt\/sources.list.d\/percona.list\r\necho \"deb-src http:\/\/repo.percona.com\/apt lenny main\" >> \/etc\/apt\/sources.list.d\/percona.list\r\napt-get update\r\napt-get install percona-toolkit<\/pre>\n<h4>Quelques commandes pour analyser les requ\u00eats MySQL :<\/h4>\n<p>Avec un tcpdump :<\/p>\n<pre lang=\"bash\">tcpdump -i eth0 port 3306 -s 65535 -c 10000 -x -n -q -tttt | pt-query-digest --type tcpdump --report-format=profile --limit=10<\/pre>\n<p>Avec les logs slow-query :<\/p>\n<pre lang=\"bash\">pt-query-digest --limit=10 \/var\/log\/mysql\/mysql-slow.log<\/pre>\n<p>Avec les binlogs :<\/p>\n<pre lang=\"bash\">mysqlbinlog \/var\/log\/mysql\/mysql-bin.XXXXXX | pt-query-digest --type binlog --limit=10 <\/pre>\n<p>La documentation de Percona :<br \/>\n<a href=\"http:\/\/www.percona.com\/doc\/percona-toolkit\/2.0\/pt-query-digest.html\" target=\"_blank\">http:\/\/www.percona.com\/doc\/percona-toolkit\/2.0\/pt-query-digest.html<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Installation : Debian : gpg &#8211;keyserver hkp:\/\/keys.gnupg.net &#8211;recv-keys 1C4CBDCDCD2EFD2A gpg -a &#8211;export CD2EFD2A | apt-key add &#8211; echo \u00ab\u00a0deb http:\/\/repo.percona.com\/apt lenny main\u00a0\u00bb >> \/etc\/apt\/sources.list.d\/percona.list echo \u00ab\u00a0deb-src http:\/\/repo.percona.com\/apt lenny main\u00a0\u00bb >> \/etc\/apt\/sources.list.d\/percona.list apt-get update apt-get install percona-toolkit Quelques commandes pour analyser les requ\u00eats MySQL : Avec un tcpdump : tcpdump -i eth0 port 3306 -s 65535 <a href='https:\/\/blog.jeremm.fr\/?p=23' class='excerpt-more'>[&#8230;]<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[26,27],"_links":{"self":[{"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=\/wp\/v2\/posts\/23"}],"collection":[{"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=23"}],"version-history":[{"count":22,"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=\/wp\/v2\/posts\/23\/revisions"}],"predecessor-version":[{"id":944,"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=\/wp\/v2\/posts\/23\/revisions\/944"}],"wp:attachment":[{"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=23"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=23"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=23"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}