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

PREVIOUS POST
NEXT POST

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.

Maciek

PREVIOUS POST
NEXT POST

Comments

  1. says

    Maciek,

    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 ?

  2. Alexander Mikhailian says

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

  3. says

    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.

  4. says

    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!

    -jay

  5. says

    Jay,

    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 :)

Leave a Reply

Your email address will not be published. Required fields are marked *