{"id":1971,"date":"2015-02-28T03:02:12","date_gmt":"2015-02-28T03:02:12","guid":{"rendered":"https:\/\/qbytes.cloud\/?p=1971"},"modified":"2015-02-28T03:02:12","modified_gmt":"2015-02-28T03:02:12","slug":"analyze-slow-query-log","status":"publish","type":"post","link":"https:\/\/www.qbytes.cloud\/index.php\/2015\/02\/28\/analyze-slow-query-log\/","title":{"rendered":"Analyze Slow Query log"},"content":{"rendered":"<p>There is a nice tool like Percona&#8217;s &#8216;pt-query-digest&#8217; tool at <a href=\"http:\/\/www.percona.com\/doc\/percona-toolkit\/2.2\/pt-query-digest.html\" target=\"_blank\" rel=\"noopener\">http:\/\/www.percona.com\/doc\/percona-toolkit\/2.2\/pt-query-digest.html<\/a>, which will automatically parse the slow_query_log and analyze it for the slowest queries.<\/p>\n<p>you run the command <\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n\npt-query-digest slowquerylog.txt\n\n<\/pre>\n<p>Wich should output a summary and a list of the longest-to-execute queries.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There is a nice tool like Percona&#8217;s &#8216;pt-query-digest&#8217; tool at http:\/\/www.percona.com\/doc\/percona-toolkit\/2.2\/pt-query-digest.html, which will automatically parse the slow_query_log and analyze it for the slowest queries. you run the command pt-query-digest slowquerylog.txt Wich should output a summary and a list of the longest-to-execute queries.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[70],"tags":[],"class_list":["post-1971","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/posts\/1971","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/comments?post=1971"}],"version-history":[{"count":0,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/posts\/1971\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/media?parent=1971"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/categories?post=1971"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/tags?post=1971"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}