Oracle Cloud Infrastructure Documentation

HeatWave and External MySQL DB System Metric Charts

Here are the descriptions of the HeatWave and External MySQL DB system metric charts displayed on the MySQL database details page.

The metric charts are listed in the Basic Monitoring Metrics and Full Monitoring Metrics sections, based on the monitoring option selected when enabling Database Management for a HeatWave DB system. For information on the monitoring options, see Enable Database Management for HeatWave.

Note

For External MySQL DB systems, the metric charts listed in both the Basic Monitoring Metrics and Full Monitoring Metrics sections are available.

Basic Monitoring Metric Charts

The metric charts listed in the following table are available for the HeatWave DB systems for which Database Management was enabled with the Basic monitoring option, and for External MySQL DB systems.

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 metrics, 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.

Note: This metric chart is only available for HeatWave DB systems.

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.

Note: This metric chart is only available for HeatWave DB systems.

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 were 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.

Full Monitoring Metric Charts

The metric charts listed in the following table are available for the HeatWave DB systems for which Database Management was enabled with the Full monitoring option, and for External MySQL DB systems.

Metric Chart Description
Binary log file I/O latency (microseconds) Displays the I/O latency in microseconds for binary log files.
Binary log file I/O read (bytes per second) Displays the average number of bytes read from the binary log per second.
Binary log file I/O written (bytes per second) Displays the average number of bytes written to the binary log per second.
Binary log space usage (bytes) Displays the space usage in bytes for binary log files.
Conflicts detected Displays the number of transactions that have not passed the conflict detection check.
Database activity (statements per second) Displays the breakdown of various DML statements per second.
Database transactions (transactions per second) Displays the breakdown of various database transactions per second.
Prepared statements API (statements per minute) Displays the breakdown of various prepared statements using MySQL C API, per minute.
Prepared statements API invalidations (statements per minute) Displays the number of prepared statements being reprepared per minute.
Prepared statements SQL (statements per minute) Displays the breakdown of prepared statements per minute.
Queued transactions Displays the number of transactions in the queue pending conflict detection checks.
Relay log file I/O latency (microseconds) Displays the total wait time, in microseconds, of timed occurrences of the relay log I/O event.
Relay log file I/O read (bytes per second) Displays the number of bytes read per second for the relay log I/O event.
Relay log file I/O written (bytes per second) Displays the number of bytes written per second for the relay log I/O event.
Relay log space usage (bytes) Displays the total relay log space usage, in bytes, for all channels.
Rows validating Displays the number of transaction rows that can be used for certification, but have not been garbage collected.
Transactions checked Displays the number of transactions that were checked for conflicts.