…, so we are a little slow to blog about this and …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: Slow Query Log analyzes tools
September 6, 2006 By 83 Comments
… 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… log all queries slow query log may be growing too rapidly to follow, so we implemented slow query log filter (based on parse_mysql_slow_log by…
Post: Guess what?! Microsecond slow query timing finally available in MySQL!
August 29, 2007 By 5 Comments
… 5.1.20 failed to apply correctly on the new MySQL release. Imagine the expression on my face after I unpacked the sources and found out that MySQL incorporated the patch to their release. So it’s a…
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
… I have microsecond logging in the slow query log, and extended statistics in the same log. I logged a couple gigabytes of queries at… some context, normally these take 75 microseconds. I can see it clearly when I scan the slow query log: there are just places… done about it — and that’s where improvements to the MySQL source code are necessary. But in many cases something can…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… top 10 most expensive queries, in total execution time. By the way, the slow query logs in the stock MySQL server are extremely limited… has the Percona patches for microsecond logging and additional information in the slow query log output. The stock MySQL server’s limitation of one…
Post: Percona Server 5.5.10 (Release Candidate)
April 4, 2011 By 4 Comments
…log_slow_timestamp_every was renamed to slow_query_log_timestamp_always. (Oleg Tsarev) Old system variable slow_query_log_microseconds_timestamp was renamed to slow_query_…7 could crash the server. (Yasufumi Kinoshita) MySQL bugs 56433 and 51325 – These MySQL bugs have been fixed in Percona Server. (…
Post: How to Identify Bad Queries in MySQL
January 10, 2011 By 16 Comments
… nonexistent query can’t be bad. Queries, or groups of queries, are bad because they are slow…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
… MySQL Replication speed. My first idea was to check it based on slow query log, happily the server was running MySQL with slow query log with microsecond resolution so I could check exactly which update queries take…
Post: Backport of micro-time patch to mysql 4.1
October 1, 2006 By 9 Comments
… to 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…
Post: New MySQL Community Release Policies published
August 9, 2007 By 9 Comments
… main issue for me is Change policy for MySQL Community version. We are patching MySQL with minor extension so this concerns us… our patches for microsecond resolution of slow queries over half a year ago. These patches had a good support from MySQL Professional Services Team… tree but as goal was reached process slowed down a lot. Submitting patches to MySQL 5.2 now and hoping to see…
