Recommended Servers for MySQLThe world's most popular open source database
Contact Sales
USA - Toll Free: +1-866-221-0634
USA - From abroad: +1-208-327-6494
USA - Subscription Renewals: +1-866-830-4410
Latin America: +1 512 535 7751
UK: +44 845 399 1124
Ireland: +353 1 6919191
Germany: +49 89 420 95 98 95
France: +33 1 70 61 48 95
Sweden: +46 730 207 871
Benelux: +358 50 5710 528
Italy: +39 06-99268193
Israel: +358 50 5710 528
Spain & Portugal: + 34 933905461
Other EMEA countries: +353 1 6919191
Asia Pacific: +81 3 5843 1140
MySQL Query Analyzer
MySQL Query Analyzer Tab
View Screenshot
MySQL Query Analyzer Detail
View Screenshot
MySQL Query Analyzer EXPLAIN
View Screenshot
Improving Your SQL Query Performance
The MySQL Query Analyzer helps you improve application performance by monitoring query performance and accurately pinpointing SQL code that is causing a slow down. Queries are presented in an aggregated view across all MySQL servers so you can analyze your most expensive code by total executions, total run time, total data size and by using drill downs into sampled executions and EXPLAIN results. With the MySQL Query Analyzer, you can improve the SQL code during active development, and continuously monitor and tune the queries in production.
MySQL Query Analyzer provides you with the following benefits:
- Continuously monitor queries running against all your MySQL Servers
- Quickly identify problem queries that impact the throughput of your applications
- View query details in drill down panels to analyze the root cause for performance degradation
- Fine-tune the problematic SQL code to regain peak performance
The MySQL Query Analyzer saves you 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 EXPLAIN results
"The new MySQL Query Analyzer gives us a better level of visibility into our database performance that we have never had before. Not only does it save us both time and resources, it allows us to be far better prepared when these applications go live, understanding exactly the demands that will be placed on the system."
Phil Hildebrand, senior DBA
thePlatform, a subsidiary of Comcast Interactive Media
The MySQL Query Analyzer is installed with the Service Agent. It is enabled during agent installation and can be toggled between collection and pass-thru modes from the Query Analysis page of the Enterprise Monitor. The architecture of the MySQL Query Analyzer is shown below.
The MySQL Query Analyzer provides you an in-depth view of the SQL code by summarizing all queries and aggregating execution statistics in a single panel, making it easier than ever to achieve peak performance on MySQL.