Guess what?! Microsecond slow query timing finally available in MySQL!

Vadim asked me yesterday to update Microslow patch for 5.1.21, because the previous one I wrote for 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 built-in feature now in the 5.1 line. So far I noticed one addition to my code which is logging the microtime statistics into TABLE type log storage.


Share this post

Comments (5)

  • peter Reply


    How was it done for table format – previously there was TIME column for query execution time which did not support fractions of seconds in MySQL – was data type extended or the column changed to different type ?

    Also was only pure timing support added to the MySQL 5.1.20 or were other features you’ve implemented, such as logging slow queries from replication thread as well and having rows examined and rows updated in the slow query log added as well.

    In any case it is great news Monty finally pulled the trigger on this one as it was long overdue. He also told me he planned to see if more efficient platform specific timing could be used on some platforms – did you see if there are any changes in this respect ?

    August 31, 2007 at 3:07 am
  • Alexander Mikhailian Reply

    Gongratulations from the developers tired to recompile their MySQL everytime they needed a new version, just to include you (in)famous patch.

    August 31, 2007 at 5:52 am
  • Alexey Kovyrin Reply

    Congratulations, Maciek! Now we need to wait for final 5.1 release and then we’ll be able to use it w/o all these boring patching procedures. Looks like 5.1 is going to give us really great set of new features which will make mysql even better.

    August 31, 2007 at 9:30 am
  • Jay Pipes Reply

    And on a more general note, why on Earth were you not notified by our development team that your patch had been included in 5.1? This is troubling for us in the community team, as we want our contributors to feel the love from MySQL and not be ignored. I’ll check into this…

    Thanks, Maciek, for your patch!


    September 3, 2007 at 11:28 am
  • peter Reply


    We new it is in the queue for 5.1 but were surprised it was included that quickly.
    I guess as MySQL 5.1 is getting close to “GA” release it just become “now or never” question 🙂

    September 5, 2007 at 2:33 am

Leave a Reply