Chapter 3 Performance Pages

Table of Contents

3.1 Connections
3.2 Statements
3.3 InnoDB Buffer Pool
3.4 InnoDB File I/O
3.5 Tables / Rows
3.6 Query Cache

The Performance pages are available from the Performance sub-menu of the MySQL Database menu. These pages display specific aspects of your MySQL performance.

The following Performance pages are available:

Each of the performance pages graphs the performance of a specific metric, or set of metrics, over a 24-hour window. They also display configuration information.

Each graph region also contains links to week and month overviews of the collected data. Click the appropriate link to display the week or month graph.

Each metric is graphed with a separate line. Each point on the line represents the data collected according to the defined Collection Schedule. If the Collection Schedule is defined as 5 minutes, each point on the graph is separated by 5 minutes.

To see data on each individual collection point, hover the cursor over the line. A tooltip is displayed listing the data type, the time the data was collected, and the value of the metric collected.