MySQL Enterprise Monitor 2.3 Manual  /  ...  /  Using Graphs to Identify Queries

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:

  • Drag and select an area on a graph as displayed within the Monitor over view tab, or the Graphs tab of the MySQL Enterprise Monitor User Interface. When using either of these two tabs, you can drag and select any region on a displayed graph, and the display changes to the Query Analyzer tab, displaying the corresponding zoomed graph, and the associated queries being executed during the selected period.

  • Select a graph to be displayed within the Query Analyzer tab. Open the Graph section, and use the pop-up list to select the graph to be displayed. You can see an example of this in Figure 3.12, “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.

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.

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