I’ve finally finished implementing the slow log parsing into MyProfi utility which is a more advanced brother of Slow Query Analyzer tool mentioned in this blog.
Now it’s possible to extract the most time taking query patterns and order them by total, average or maximum time taken by query execution as well as by locking time.
Unfortunately I wasn’t able to test it with patched version of mysql, which produces microsecond result into slow query log files instead of minimum limit of 1 second in regular slow query log.
If someone is able to test it with patched version of mysql, it would be very appreciated.