mysql identify_MySQL 5.1 英文手册 :: 15.10.3 Using Graphs to Identify Queries

15.10.3. Using Graphs to Identify Queries

The MySQL Enterprise Dashboard 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:

By dragging and selecting an area on a graph as displayed

within the Monitor over view tab, or the

Graphs tab of the MySQL Enterprise Dashboard. When

using either of these two tabs, you can drag and select any

region on a displayed graph, and the display will change to

the Query Analyzer tab, displaying the

corresponding zoomed graph, and the associated queries being

executed during the selected period.

You can select a graph to be displayed within the

Query Analyzer tab. Open the

Graph section, and use the popup list to

select the graph to be displayed. You can see an example of

this in Figure 15.51, “MySQL Enterprise Dashboard: Correlated Graphs”.

When using the correlated graphs, selecting an area within the

graph will set 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

that you want 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 have

selected will be displayed above the graph as you select the area.

Figure 15.51. MySQL Enterprise Dashboard: Correlated Graphs

You can also explicitly zoom in an out of the displayed graph by

using 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.

For more information on filtering your queries, see

Section 15.10.4, “Filtering Query Analyzer Data”.