Improving Your SQL Query Performance

• Try It Now »

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.

See the Enterprise Monitor and Query Analyzer architecture and configuration options for more details.

MySQL Query Analyzer provides you with the following benefits:

• Perform in-depth root cause analysis, including drill downs into source code using MySQL Connector Plug-ins
• 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:

• Easy activation options for better usability
• Click, Grab and Go graphs for quick filtering and analysis of queries that were running during spikes in key system 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

White Papers

• MySQL Enterprise Monitor: What's New
• MySQL Query Analyzer: Overview

Frequently Asked Questions (FAQ)

• MySQL Enterprise Monitor
• MySQL Query Analyzer