MySQL : getting the most intensive/called/slow requests
Posted on 2011-10-06
With MySQL (the community edition I guess, the one packaged in Debian and many other distros I think), what (free) tool do I have to check the performance?
I'd like to be able to get the most disk intensive requests, the ones reading too many lines, the requests called too many times (let say, a lot of times), that kind of top-tens. My goal is to highlight some bad requests and algorithms we've probably written in our application.
This way, we'll change some programs, create indexes where we need and so on...
I found some commercial tools (I don't remember the company name right now), but I don't think they're free.
In comparison with Oracle, I know I have all the information inside the database, and I can extract it. I don't think it's the same with MySQL