Comments on: MySQL Slow Query Log: Tools and Tips https://www.percona.com/blog/mysql-slow-query-log-tools-and-tips/ Fri, 12 May 2023 18:12:38 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: a https://www.percona.com/blog/mysql-slow-query-log-tools-and-tips/#comment-10969468 Thu, 26 Jul 2018 08:11:38 +0000 https://www.percona.com/blog/?p=20408#comment-10969468 There is an automated tool for that – https://www.eversql.com/visualize-slow-log-report/

]]> By: Rick James https://www.percona.com/blog/mysql-slow-query-log-tools-and-tips/#comment-10966509 Sun, 22 May 2016 23:17:42 +0000 https://www.percona.com/blog/?p=20408#comment-10966509 Yasir, I have turned the slowlog on (and left it on) on hundreds of production machines. I consider the overhead (CPU and I/O) to be minimal and worth the cost. The overhead for running pt-query-digest is small, but you don’t run it “all the time”. If you you are concerned, do that processing on another machine.

]]> By: Yasir Kalim https://www.percona.com/blog/mysql-slow-query-log-tools-and-tips/#comment-10732489 Mon, 13 Apr 2015 06:30:16 +0000 https://www.percona.com/blog/?p=20408#comment-10732489 I wanted to ask the load over head, (interns of CPU usage.) consumed by percona toolkit.

]]> By: Muhammad Irfan https://www.percona.com/blog/mysql-slow-query-log-tools-and-tips/#comment-5460311 Mon, 17 Mar 2014 20:59:09 +0000 https://www.percona.com/blog/?p=20408#comment-5460311 aftab,

“pt-query-digest –explain” converts non-SELECT queries to equivalent SELECT statements in MySQL 5.6 too to get EXPLAIN output. Currently, it’s not supported to run EXPLAIN against UPDATE/DELETE queries by pt-query-digest tool. I opened a feature request for it here https://blueprints.launchpad.net/percona-toolkit/+spec/pt-query-digest .

]]> By: aftab https://www.percona.com/blog/mysql-slow-query-log-tools-and-tips/#comment-5451566 Mon, 17 Mar 2014 10:24:10 +0000 https://www.percona.com/blog/?p=20408#comment-5451566 Thanks for sharing!
Does “pt-query-digest –explain” try to run EXPLAIN for non-SELECT queries too? OR does it still convert them to equivalent SELECT and get EXPLAIN output, As of 5.6 EXPLAIN can be performed on DELETE, INSERT, REPLACE, and UPDATE as well as SELECT statements

]]> By: Moyed Ansari https://www.percona.com/blog/mysql-slow-query-log-tools-and-tips/#comment-5438204 Sun, 16 Mar 2014 07:45:27 +0000 https://www.percona.com/blog/?p=20408#comment-5438204 Fascinating article! Thank you! I stumbled across this while researching this aspect of optimization. Keep up the greatness

]]>