MySQL Fleet Performance

The MySQL fleet performance dashboard provides an overview of the critical performance metrics for your fleet of HeatWave or External MySQL DB systems in a particular compartment, over a specified time period.

In the MySQL fleet performance dashboard:

  • Select a time period for which you want to display data in the widgets. By default, the widgets in the dashboard display performance data for the last 60 minutes, however, you can select a different time period in the upper-right corner of the dashboard.
  • Review the option displayed in the Compartment field, and select an option in the Region and MySQL DB system type fields. Based on the selected MySQL DB system type, select MySQL DB systems in the MySQL DB Systems field. The critical performance metrics for the selected Database Management-enabled HeatWave or External MySQL DB systems are displayed in the widgets. You can click the names of the DB systems in the legend of each widget to only select the DB systems whose performance metrics you want to view.

Here's the list of widgets displayed in the MySQL fleet performance dashboard and a brief description of each widget.

Widget Description
Current connections

The number of current connections.

Active connections

The number of connections actively executing statements.

Average statement latency (seconds)

The average statement latency for all executed statements.

Statement count

The number of executed statements.

Rows modified

The number of times rows were modified in the tables.

Sort rows

The number of sorted rows.

Row reads index utilization (%)

The percentage of total row reads performed using an index.

InnoDB buffer pool pages utilization (%)

The percentage of total InnoDB buffer pool pages currently in use.