The world's most popular open source database
Contact Sales
USA/Canada - Toll Free: +1-866-221-0634
USA - From abroad: +1-208-338-8100
USA/Canada - Subscription Renewals: +1-866-221-0634
Latin America: +1 512 535 7751
Brazil: +55 11 5189-1097
South Africa: +27 113194408
UK: +44 207 553 8447
Ireland: +353 1 8031050
Germany: +49 89 143 01280
France: +33 1 57 60 83 57
Benelux: +31 30 662 7960
Italy: +39 02 249 59 120
Israel: +353 1 8031123
Spain & Portugal: +34 916312182
Sweden: +46 84773853
Other EMEA countries: +353 1 8031050
Asia Pacific: Toll Free
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. With the new MySQL Connector Plug-ins, you can optimize performance for your Java and .Net applications more efficiently by communicating directly with the Query Analyzer.
Queries are presented in an aggregated view across all MySQL servers so you can filter for specific query problems and analyze your most expensive code. 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:
- New! Perform in-depth cause analysis using MySQL Connector Plug-ins
- New! Filter for specific query problems like full table scans and bad index using advanced global search options
- Visualize query activity to gain further performance insight beyond query statistics
- Filter queries during periods of performance degradation for easier and quicker trouble-shooting
- 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:
- New! Searchable graphs and intelligent installation options for better usability
- Clickable query activity graphs for analyzing queries during usage spikes in key systems resources
- SQL warning and error counts for each query
- 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 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, Database Manager
thePlatform, a subsidiary of Comcast Interactive Media
White Papers
On Demand Webinars
- Scaling MySQL.com with Query Analyzer & Memcached
- Improve Application Performance with the MySQL Enterprise Monitor and the MySQL Query Analyzer
- MySQL Query Analyzer: Finding and Fixing Problem Queries
