Skip navigation links
Articles
MySQL Query Profiling Tools -- part 0, Ma'atkit Query Profiler
Add to My Link Library +0 Vote Up -0Vote Down
Today I've been checking out a new client environment. My mission is to figure out (cold) some of the characteristics of the queries being run, and particularly if they're "good" or "bad". In my arsenal of "tools I really want to check out" has been Ma'atkit's Query Profiler.They're very different tools. Ma'atkit's query profiler profiles a batch of queries, without granularity (at least not the way I ran it) to see what query is doing what. So I ran this against a production machine:(I ran the query profiler for a while and then hit "enter" (apparently after about 17 minutes))> ./mk-query-profiler --external --host localhost --user <user> --password <password> Press <enter> when the external program is finished +----------------------------------------------------------+ | 1 (1028.2091 sec) | +----------------------------------------------------------+__ Overall stats _______________________ Value _____________ Total elapsed time 1028.209 Questions 882


Report this link: