Wow! I just stumbled across mysqldumpslow (while RTFM’ing) and what a tool!

It goes through the slow query log you give as an argument and tallies up the number of times each query appears and a lot of other summary data. Not knowing about this before, it makes it easy to prioritize which slow queries to work on first.

Comments are closed.