Oracle Cloud Infrastructure Documentation

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:

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 (oci_mysql_database namespace), namely StatementLatency and Statements and currently alarms cannot be created for this combination of 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:
  • Active: The number of connections actively executing statements against the DB system.
  • Current: The number of current connections to the DB system.
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:

  • Used: The number of OCPUs used.
  • Allocated: The number of OCPUs allocated.
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:

  • Used: The amount of space used in the DB system.
  • Allocated: The amount of space allocated to the DB system.
Disk operations (IOPS) Displays the following metrics per second:
  • Read: The total number of read operations in the DB system.
  • Write: The total number of write operations in the DB system.
Disk throughput (MBPS) Displays the following metrics per second:
  • Read: The total bytes read from the DB system.
  • Write: The total bytes written to the DB system.
InnoDB buffer pool usage (pages) Displays the following metrics:
  • Dirty: The current number of dirty pages in the InnoDB buffer pool.
  • Free: The number of free pages in the InnoDB buffer pool.
  • Total: The total number of pages in the InnoDB buffer pool.
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:

  • Used: The amount of memory used in the DB system.
  • Allocated: The amount of memory allocated to the DB system.
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:
  • Received: The network receive bytes for the DB system.
  • Transmitted: The network transmit bytes for the DB system.
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:
  • First index entry: The number of times the first entry in an index was read.
  • Index lookup: The number of requests to read a row based on a key.
  • Index ordered: The number of requests to read the previous row in key order.
  • Index scan: The number of requests to read the next row in key order.
  • Last index entry: The number of requests to read the last key in an index.
  • Sort: The number of requests to read a row based on a fixed position.
  • Table scan: The number of requests to read the next row in the data file.
Row writes (per second) Displays the following metrics per second:
  • Deleted: The number of times rows have been deleted from tables.
  • Inserted: The number of requests to insert a row in a table.
  • Updated: The number of requests to update a row in a table.
Rows sorted (per second) Displays the number of sorted rows per second.
Selects by types (per second) Displays the following metrics per second:
  • Full join: The number of joins that perform table scans because they do not use indexes.
  • Full range join: The number of joins that used a range search on a reference table.
  • Range: The number of joins that used ranges on the first table.
  • Range check: The number of joins without keys that check for key usage after each row.
  • Scan: The number of joins that did a full scan of the first table.
Sorts using range (per second) Displays the following metrics per second:
  • Row sort: The number of sorts done using ranges.
  • Table scan sort: The number of sorts done by scanning the table.
Statement count Displays the total number of statements executed against the DB system.
Temporary tables created (per second) Displays the following metrics per second:
  • Total: The number of internal temporary tables created by the DB system while executing statements.
  • On disk: The number of internal on-disk temporary tables created by the DB system while executing statements.
Terminated connections (per second) Displays the following metrics per second:
  • Connections: The number of failed attempts to connect to the DB system.
  • Clients: The number of connections that were terminated because the client disconnected without closing the connection properly.
Total statement latency (seconds) Displays the total statement latency (in seconds) for all executed statements.