Monitor and Tune MySQL Queries

MySQL Query Explorer – Free Tool

  • Monitor top resource consuming queries
  • Explore explain plan and execution statistics to tune performance
  • Manually run any query and examine directly from the tool
  • Export results to popular formats for analysis and reporting

Monitor Top Resource Consuming Queries

The Query Monitor highlights top resource consuming queries in execution and provides summary statistics to give a quick overview of status and places to investigate further. Set the sampling interval between 30 seconds and 10 minutes or manually refresh to get a real-time view. Select queries for further investigation or Kill a problem query with one click.

Explore Explain Plan and Execution Statistics

Select a query from the monitor view, or manually run, to view the Explain Plan and Execution Statistics details. Focus in to examine problem areas, edit the query directly from the tool, and then run it again to tune performance.

Manually Run and Examine Any Query

Utilize the tool independent of the monitor. Simply enter any query in the details view or open from a file and run manually to examine the plan and statistics. Save query statements for future use or later review.

Export Results to Popular Formats

Results are presented in a summary grid for easy investigation or can be exported for further analysis or reporting. Explain Plan details can be exported to JSON or plain text and Execution Statistics can be exported to Excel or CSV.

MySQLQueryExplorer

IDERA Community

Check out the latest blog posts for product tips & tricks from other users.

Join the Discussion