3.2.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:

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.

Figure 3.12 MySQL Enterprise Monitor User Interface: Correlated Graphs

MySQL Enterprise Monitor User Interface: Correlated Graphs

To zoom in an out of the displayed graph, use the links next to the Zoom label. You can select to show just an hour of the graph material, or larger ranges up to two days. At all times, the area on the graph highlighted in blue is the actual date/time range selected within the list of analyzed queries.

To export the graph, either a .png file of the graph image or a .csv file of the underlying data, use the two icons to the right of the graph label. See Section 2.5.4, “Exporting Graph Images and Data” for details about the export feature.