…microseconds in SHOW PROCESSLIST Group commit for the binary log makes the server much faster with the binary log enabled Faster queries…MySQL 5.6 offers microsecond timestamp support, as well as a lot of optimizer improvements. Even the standard MySQL…
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
…) time to execute. To give some context, normally these take 75 microseconds. I can see it clearly when I scan the slow query… query cache) are executing in no more than 12 microseconds, worst-case. So the contention that’s blocking these queries for shockingly long times… done about it — and that’s where improvements to the MySQL source code are necessary. But in many cases something can…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… GLOBAL. long_query_time=# Log all queries that have taken more than 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…
Post: Slow Query Log analyzes tools
September 6, 2006 By 83 Comments
… Patching Slow Query Logging – First thing we did is created a Patch which allows you to specify slow query time in microseconds rather than seconds and allows you to log all queries in slow query log by setting long_query_time=0 This patch is adapted version of patch by Georg Richter which was made to run with recent MySQL version…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… choose to log all queries to see those which take less than 1s. Now long_query_time is in microseconds and you can set it for example to 300000 which is 0.3s! # Query_time: 0.503016 Lock_time: 0.000048 Rows_sent: 56 Rows_examined: 1113 LOGGING OF THE REPLICATED STATEMENTS Normally MySQL will not…
Post: How to Identify Bad Queries in MySQL
January 10, 2011 By 16 Comments
…microsecond-precision timestamps for log events. Edit: note that I’m referring to the timestamp when the query executed, not merely the duration the query executed for, which has been available in MySQL…
Post: Figuring out what limits MySQL Replication
March 7, 2007 By Leave a Comment
… query log, happily the server was running MySQL with slow query log with microsecond resolution so I could check exactly which update queries take most time… global long_query_time=0 and restarting slave does not pick up the change. I of course could just restart MySQL but this…
Comment: Query Response time histogram - new feature in Percona Server
January 23, 2011 By 11 Comments
There are now graphs for this in the Cacti templates I maintain: http://code.google.com/p/mysql-cacti-templates/wiki/MySQLTemplates Scroll down to these graphs: # MySQL Query Response Time (Microseconds) # MySQL Query Time Histogram (Count)
Post: Introducing tcprstat, a TCP response time tool
August 31, 2010 By 12 Comments
…, the time elapsed from the last inbound packet until the first outbound packet. For many simple protocols such as HTTP and MySQL, this is the moral equivalent of a query‘s response time. The statistics we chose to…, average, min, max, and standard deviation of the response times, in microseconds. These are repeated for the 95th and 99th percentiles as…
Post: Backport of micro-time patch to mysql 4.1
October 1, 2006 By 9 Comments
… slow-log queries. The patch allows to specify time of slow queries in microseconds and is very helpful in a fight with problematic queries. 4…
