23.3.2 Using Graphs to Identify Queries

The MySQL Enterprise Monitor User Interface supports correlated graphs so that you can compare the graphed execution parameters, such as the server load, thread statistics, or RAM usage, against the queries that were being executed by the server or servers being monitored at that time.

You can use the correlated graphs in two different ways:

  • Drag and select an area on a graph as displayed within the Overview dashboard, or from the Graphs & Reports page of the MySQL Enterprise Monitor User Interface. You can drag and select any region on a displayed graph, click the QUAN icon, and it loads the selected range into the Query Analyzer page, displaying the corresponding zoomed graph, and the associated queries being executed during the selected period.

  • Do the same, but select the graph from within the Query Analyzer page.

Figure 23.6 MySQL Enterprise Monitor User Interface: Correlated Graphs

MySQL Enterprise Monitor User Interface: Correlated Graphs

When using the correlated graphs, selecting an area within the graph sets the start and end time within the query filtering selection. You can combine with other filtering options, such as the Query Type, to zero in on the queries to examine.

To use the graphs in this manner, select a starting point and click, while holding down the button, drag a selection area to set the time-range for the query display. The time range that you select is displayed above the graph as you select the area.

To export the graph, see Chapter 16, Reports and Graphs.

Download this Manual
PDF (US Ltr) - 5.7Mb
PDF (A4) - 5.7Mb
EPUB - 3.8Mb
HTML Download (TGZ) - 3.6Mb
HTML Download (Zip) - 3.7Mb
User Comments
Sign Up Login You must be logged in to post a comment.