… query execution times into the slow log. Originally MySQL database offered a second time resolution and also a 2 second minimum for the query to get…long_query_time microseconds to execute to file. This option is standard MySQL, however after you apply the patch, it will no longer take time in …
Post: Slow Query Log analyzes tools
September 6, 2006 By 83 Comments
…query time in microseconds rather than seconds and allows you to log all queries in slow query log by setting long_query_time…queries which take most time to execute combined. There is a tool mysqldumpslow in MySQL…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…10 most expensive queries, in total execution time. By the way, the slow query logs in the stock MySQL server are…patches for microsecond logging and additional information in the slow query log output. The stock MySQL server’… much total gain I can get from it. Queries are not just “bad” or “good” …
Post: How to Identify Bad Queries in MySQL
January 10, 2011 By 16 Comments
…in Percona Server we have microsecond-precision timestamps for log events. Edit: note that I’m referring to the timestamp when the query executed…
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
… data. These are going to get more attention as people run into…query cache) are executing in no more than 12 microseconds, worst-case. So the contention that’s blocking these queries for shockingly long times…where improvements to the MySQL source code are necessary. But in many cases something can…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…get file names and lines (which are different in different versions), you get…time thread waits before it enters the queue. This is done by adjusting innodb_thread_sleep_delay variable. Value is specified in microseconds. mysql… from query executions are executed by threads running queries. On…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
…for its predecessor – to get more information about query execution logged into slow log, …query_time is in microseconds and you can set it for example to 300000 which is 0.3s! # Query_time: 0.503016 Lock_time… REPLICATED STATEMENTS Normally MySQL will not write into slow log any queries executed by …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… in gzip is increased usage of CPU time. …query where clause when it was not resolved by index HT: That is already implemented in…execution is not serializable. PZ: Cool. This is one of little known new features in MySQL…in less than 100 microseconds. And if you do not have, then the only way to get…
Post: Figuring out what limits MySQL Replication
March 7, 2007 By Leave a Comment
… server was running MySQL with slow query log with microsecond resolution so I could check exactly which update queries take most time to execute. Unfortunately it… clear everything but in my case it did exactly what was needed. Now running mysqlsla to get most common queries: ./mysqlsla-1.4…
Post: New patches, new builds
September 5, 2008 By 24 Comments
…time of query execution with microseconds granularity. mysql> SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST; +—-+——+———–+——+———+——+———–+———————————————-+———+ | ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO | TIME…
