2.2.1 The Server Graphs and Critical Events

The center of the Monitor page gives a visual representation of the state of your servers.

Figure 2.1 MySQL Enterprise Monitor User Interface: The Graphs Screen

MySQL Enterprise Monitor User Interface: The Graphs panel

The graphs present information about the currently selected server or server group. The default graphs show the hit ratios, CPU utilization, connections, and database activity for a specific interval.

Graphs also let you drill down from overall usage information to the queries that were being executed on the server at the time. Click and drag on a graph to zoom in on the graph content and view the queries that were being executed during the specified period, to understand server performance and responsiveness. This information is only available when you configure query analysis, and enable query analysis for the servers you are monitoring. For more information, see Section 2.6, “The Query Analyzer Tab”.

To set the interval, click the configure graphs link immediately below the graphs. In the resulting dialog box, choose the default interval for the x-axis of the graphs. Defining a shorter or longer interval gives you a shorter or longer term view of server activity. You can also adjust the thumbnail and full-size graph dimensions from this dialog box. Save any changes, and the chosen values become the defaults whenever you log in.

You can also choose the default graphs shown on the Monitor page. Click the edit favorites link and choose the graphs you want from the drop-down list box. To choose contiguous graphs, hold down the Shift key and click the desired graphs. To select graphs that are not in a sequence, click the desired graphs while holding down the Ctrl key. The Monitor page can display a maximum of six graphs. Save your changes, and these become be the default graphs whenever you log in.

Color coding helps distinguish different aspects of each graph. With Database Activity for example, you can readily distinguish SELECT statements from INSERT statements.

Clicking a graph opens a detailed view with Graph Display and Configure tabs. Choose the Configure tab to temporarily change the way that a graph displays. Changes made from this tab only apply to the standalone graph while it is open. Persistent changes are made as described above.

Dismiss the enlarged graph by clicking the hide button.

Alerts from the event system are displayed immediately below the charts. For more information on the events display, see Section 2.4, “The Events Tab”.

To export a 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.