Announcement

Announcement Module
Collapse
No announcement yet.

Figuring out the slowest queries in db.

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Figuring out the slowest queries in db.

    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.
Working...
X