MySQL Query Analyzer review
I had the chance to review the new Query Analyzer program from Sun over the last few days. I am very interested in how it performs as I have previously not had a chance to see the program in action (or the Enterprise Monitor program either for that matter). So, before getting into what the Query Analyzer can (and cannot) do let’s look at what Sun says it does.
From the November 19th, 2008 press release:
The MySQL Query Analyzer saves time and effort in finding and fixing problem queries by providing:
- Aggregated view into query execution counts, run time, result sets across all MySQL servers with no dependence on MySQL logs or
SHOW PROCESSLIST - Sortable views by all monitored statistics
- Searchable and sortable queries by query type, content, server, database, date/time, interval range, and “when first seen”
- Historical and real-time analysis of all queries across all servers
- Drill downs into sampled query execution statistics, fully qualified with variable substitutions, and
EXPLAINresults
Can you do all this with other tools or by hand?
Absolutely. Some of the those very tools I have discussed before. Most I have used at least once or twice. The question is really can Query Analyzer do this better? Read the rest of this entry . . .
