MySQL HeatWave DB System Metric Charts
Here's a table that provides the descriptions of the MySQL HeatWave DB system metric charts displayed on the MySQL database details page, in alphabetical order.
The metric charts displayed in the Summary and Metrics sections provide a visual representation of some of the key MySQL HeatWave DB system metrics emitted to the following namespaces:
oci_mysql_database
: For information, see MySQL HeatWave Service Metrics.oracle_oci_database
: For information, see Database Management Metrics for MySQL HeatWave.
The metric data is displayed in the charts for the time period selected in the Time period drop-down list in the upper-right corner of the Summary and Metrics sections.
Metric Chart | Description |
---|---|
Average statement latency (seconds) | Displays the average latency (in seconds) for the SQL
statements executed against the DB system.
Note:
The Average statement latency (seconds) chart
displays a combination of two MySQL HeatWave service metrics
( |
Channel failures (per minute) | Displays the channel failure events observed per minute. |
Channel lag (seconds) | Displays the channel lag (in seconds) with respect to the source. If the channel is configured with replication delay, the channel lag includes the replication delay. |
Connections | Displays the following metrics:
|
CPU (%) and CPU (OCPU) | Displays the CPU utilization for the DB system.
Select the Usage option in the drop-down list in the upper-right corner of the chart to view the following metrics:
|
Disk (%) and Disk (GB) | Displays the total space utilization of the DB system.
Select the Usage option in the drop-down list in the upper-right corner of the chart to view:
|
Disk operations (IOPS) | Displays the following metrics per second:
|
Disk throughput (MBPS) | Displays the following metrics per second:
|
InnoDB buffer pool usage (pages) | Displays the following metrics:
|
Memory (%) and Memory (GB) | Displays the total memory utilization of the DB system.
Select the Usage option in the drop-down list in the upper-right corner of the chart to view:
|
Merge passes (per second) | Displays the number of merge passes done by the sort algorithm per second. |
Monitoring status timeline | Displays the monitoring status of the DB system. |
Network throughput (MBPS) | Displays the following metrics per second:
|
New connections (per second) | Displays the total number of successful and unsuccessful connection attempts to the DB system per second. |
Row reads (per second) | Displays the following metrics per second:
|
Row writes (per second) | Displays the following metrics per second:
|
Rows sorted (per second) | Displays the number of sorted rows per second. |
Selects by types (per second) | Displays the following metrics per second:
|
Sorts using range (per second) | Displays the following metrics per second:
|
Statement count | Displays the total number of statements executed against the DB system. |
Temporary tables created (per second) | Displays the following metrics per second:
|
Terminated connections (per second) | Displays the following metrics per second:
|
Total statement latency (seconds) | Displays the total statement latency (in seconds) for all executed statements. |