2.5 The Graphs Tab

2.5.1 Displaying Graphs
2.5.2 Setting an Interval
2.5.3 Setting a Time Span
2.5.4 Exporting Graph Images and Data

MySQL Enterprise subscription, MySQL Enterprise Monitor, MySQL Replication Monitor, and MySQL Query Analyzer are only available to commercial customers. To learn more, see: http://www.mysql.com/products/.

Navigate to the Graphs tab by choosing the Graphs tab.

By default, four graphs are displayed on the Monitor page. These graphs present information about the currently selected server or server group, showing the hit ratios, CPU utilization, connections, and database activity. Color coding helps distinguish different aspects of each graph.

From the Monitor tab, you can make permanent or temporary changes to the way a graph is displayed. For example, you can view the last hour's activity, or a specific period of time.

The Monitor tab is the only place where you make persistent changes to the way the graphs display. You can set the size of the thumbnails and the full-sized graphs and you can also set their refresh interval. For more information, see Section 2.2.1, “The Server Graphs and Critical Events”.

As with the Monitor tab, the data shown in the graphs is determined by the server or group of servers selected in the server tree. Each graph is only displayed if there is appropriate data for the selected servers; for example, only slave servers have a Replication Slave Delay graph, and the Cluster graphs only apply to MySQL Cluster servers.

The Graphs tab shows all the available graphs in a single column, and provides the capability of adjusting the scale of the graphs, allowing a more or less detailed view as the situation requires. Click on the Graph Gallery to view multiple graphs per column.

To ensure that you have the latest versions of the graphs, click on the Check For Updates link on the top left of this page.

All graphs support the ability to drag and select a specific area of the graph. When you select an area of the graph, the display changes to the Query Analyzer tab and displays the queries that were being executed during the selected time period. You can also zoom into the graph by selecting specific time periods. For more information on using the graphs to monitor the execution of specific queries, see Section 3.2.2, “Using Graphs to Identify Queries”.