Metrics in the oracle_oci_database Namespace for HeatWave and External MySQL
You can use metrics, alarms, and notifications to monitor the key statistics of the MySQL instances in the Database Management-enabled HeatWave and External MySQL DB systems.
Valid alarm intervals for the metrics are 5 minutes or greater due to the frequency at which these metrics are emitted. For information on how to create alarms, see Managing Alarms.
Retention period is set for 90 days. For information on retention periods, see Storage Limits.
Dimensions
The metrics for HeatWave and External MySQL DB systems include the following dimensions.
| Dimension | Description |
|---|---|
resourceId |
The OCID of the DB system. |
resourceName |
The name of the DB system. |
Metrics
The metrics for HeatWave and External MySQL DB systems help measure useful quantitative data, such as connections to the DB system and InnoDB buffer usage, which in turn enable you to diagnose and troubleshoot issues.
Metrics for HeatWave DB Systems
The Database Management metrics for HeatWave DB
systems and attached HeatWave clusters, if any, are emitted in the
oracle_oci_database namespace for the mysql_database
resource group.
| Metric Name | Metric Display Name | Unit | Description and Metric Chart Defaults | Collection Frequency |
|---|---|---|---|---|
Connections |
Connections | count |
The total number of successful and unsuccessful connection attempts to the DB system. Statistic: Rate Interval: 1 minute |
1 minute |
HeatWaveAutoMLOperations |
HeatWave AutoML Operations | count |
The number of AutoML operations that have been executed. This number resets on HeatWave restart. Statistic: Rate Interval: 1 minute |
1 minute |
HeatWaveChangePropagationLag |
HeatWave Change Propagation Lag | count |
The number of transactions that are not propagated to HeatWave yet. Statistic: Rate Interval: 1 minute |
1 minute |
HeatWaveDataDictionaryBytes |
HeatWave Data Dictionary Bytes | bytes |
The size of the HeatWave data dictionary, which consumes heap space on the DB system nodes. Statistic: Rate Interval: 1 minute |
1 minute |
HeatWaveDatasetBytes |
HeatWave Dataset Bytes | bytes |
The amount of data loaded in the HeatWave cluster. Statistic: Rate Interval: 1 minute |
1 minute |
HeatWaveLakehouseLoadedBytes |
HeatWave Lakehouse Loaded Bytes | bytes |
The total size of all Lakehouse tables loaded into HeatWave. Statistic: Rate Interval: 1 minute |
1 minute |
HeatWaveLoadedTablesAvailable |
HeatWave Loaded Tables Available | count |
The number of tables loaded into HeatWave that are available for use. Statistic: Rate Interval: 1 minute |
1 minute |
HeatWaveLoadedTablesUnusable |
HeatWave Loaded Tables Unusable | count |
The number of tables loaded into HeatWave that are currently not available for use. Statistic: Rate Interval: 1 minute |
1 minute |
InnoDBBufferPoolPagesDirty |
InnoDB Buffer Pool Pages Dirty | count |
The current number of dirty pages in the InnoDB buffer pool. Statistic: Mean Interval: 1 minute |
1 minute |
InnoDBBufferPoolPagesFree |
InnoDB Buffer Pool Pages Free | count |
The number of free pages in the InnoDB buffer pool. Statistic: Mean Interval: 1 minute |
1 minute |
InnoDBBufferPoolPagesTotal |
InnoDB Buffer Pool Pages Total | count |
The total number of pages in the InnoDB buffer pool. Statistic: Mean Interval: 1 minute |
1 minute |
MonitoringStatus |
Monitoring Status | NA |
The monitoring status of the DB system. Statistic: Mean Interval: 5 minutes |
5 minutes |
RowsDeleted |
Rows Deleted | count |
The number of times rows have been deleted from tables. Statistic: Rate Interval: 1 minute |
1 minute |
RowsInserted |
Rows Inserted | count |
The number of requests to insert a row in a table. Statistic: Rate Interval: 1 minute |
1 minute |
RowsReadByFirstIndexEntry |
Rows Read By First Index Entry | count |
The number of times the first entry in an index was read. Statistic: Rate Interval: 1 minute |
1 minute |
RowsReadByIndexLookup |
Rows Read By Index Lookup | count |
The number of requests to read a row based on a key. Statistic: Rate Interval: 1 minute |
1 minute |
RowsReadByIndexOrdered |
Rows Read By Index Ordered | count |
The number of requests to read the previous row in key order. Statistic: Rate Interval: 1 minute |
1 minute |
RowsReadByIndexScan |
Rows Read By Index Scan | count |
The number of requests to read the next row in key order. Statistic: Rate Interval: 1 minute |
1 minute |
RowsReadByLastIndexEntry |
Rows Read By Last Index Entry | count |
The number of requests to read the last key in an index. Statistic: Rate Interval: 1 minute |
1 minute |
RowsReadBySort |
Rows Read By Sort | count |
The number of requests to read a row based on a fixed position. Statistic: Rate Interval: 1 minute |
1 minute |
RowsReadByTableScan |
Rows Read By Table Scan | count |
The number of requests to read the next row in the data file. Statistic: Rate Interval: 1 minute |
1 minute |
RowsUpdated |
Rows Updated | count |
The number of requests to update a row in a table. Statistic: Rate Interval: 1 minute |
1 minute |
SelectFullJoin |
Select Full Join | count |
The number of joins that perform table scans because they do not use indexes. Statistic: Rate Interval: 1 minute |
1 minute |
SelectFullRangeJoin |
Select Full Range Join | count |
The number of joins that used a range search on a reference table. Statistic: Rate Interval: 1 minute |
1 minute |
SelectRange |
Select Range | count |
The number of joins that used ranges on the first table. Statistic: Rate Interval: 1 minute |
1 minute |
SelectRangeCheck |
Select Range Check | count |
The number of joins without keys that check for key usage after each row. Statistic: Rate Interval: 1 minute |
1 minute |
SelectScan |
Select Scan | count |
The number of joins that did a full scan of the first table. Statistic: Rate Interval: 1 minute |
1 minute |
SortMergePasses |
Sort Merge Passes | count |
The number of merge passes done by the sort algorithm. Statistic: Rate Interval: 1 minute |
1 minute |
SortRange |
Sort Range | count |
The number of sorts done using ranges. Statistic: Rate Interval: 1 minute |
1 minute |
SortRows |
Sort Rows | count |
The number of sorted rows. Statistic: Rate Interval: 1 minute |
1 minute |
SortScan |
Sort Scan | count |
The number of sorts done by scanning the table. Statistic: Rate Interval: 1 minute |
1 minute |
TemporaryTablesCreated |
Temporary Tables Created | count |
The number of internal temporary tables created by the DB system while executing statements. Statistic: Rate Interval: 1 minute |
1 minute |
TemporaryTablesCreatedOnDisk |
Temporary Tables Created On Disk | count |
The number of internal on-disk temporary tables created by the DB system while executing statements. Statistic: Rate Interval: 1 minute |
1 minute |
TerminatedClients |
Terminated Clients | count |
The number of connections that were terminated because the client disconnected without closing the connection properly. Statistic: Rate Interval: 1 minute |
1 minute |
TerminatedConnections |
Terminated Connections | count |
The number of failed attempts to connect to the DB system. Statistic: Rate Interval: 1 minute |
1 minute |
Metrics for External MySQL DB Systems
The Database Management metrics for External
MySQL DB systems are emitted in the oracle_oci_database namespace for the
mysql_external_database resource group.
| Metric Name | Metric Display Name | Unit | Description and Metric Chart Defaults | Collection Frequency |
|---|---|---|---|---|
ActiveConnections |
Active Connections | count |
The number of connections actively executing statements against the DB system. Statistic: Max Interval: 1 minute |
1 minute |
Connections |
New Connections | count |
The total number of successful and unsuccessful connection attempts to the DB system. Statistic: Rate Interval: 1 minute |
1 minute |
CPUsAllocated |
CPU Allocated | count |
The number of CPUs allocated during the selected interval. Statistic: Max Interval: 1 minute |
1 minute |
CPUsUsed |
CPU Used | count |
The number of CPUs used during the selected interval. Statistic: Max Interval: 1 minute |
1 minute |
CPUUtilization |
CPU Utilization | percent |
The CPU utilization for the DB system host. Statistic: Mean Interval: 1 minute |
1 minute |
CurrentConnections |
Current Connections |
count |
The number of current connections to the DB system. Statistic: Max Interval: 1 minute |
1 minute |
DbVolumeReadBytes |
Disk Read Bytes | bytes |
The total bytes read from the DB system volumes. Statistic: Rate Interval: 1 minute |
1 minute |
DbVolumeReadOperations |
Disk Read Operations | count |
The total number of read operations for the DB volumes. Statistic: Rate Interval: 1 minute |
1 minute |
DbVolumeUtilization |
Disk Space Utilization | percent |
The total space utilization of the DB system volumes. Statistic: Max Interval: 1 minute |
1 minute |
DbVolumeWriteBytes |
Disk Write Bytes | bytes |
The total bytes written to the DB system volumes. Statistic: Rate Interval: 1 minute |
1 minute |
DbVolumeWriteOperations |
Disk Write Operations | count |
The total number of write operations for the DB volumes. Statistic: Rate Interval: 1 minute |
1 minute |
InnoDBBufferPoolPagesDirty |
InnoDB Buffer Pool Pages Dirty | count |
The current number of dirty pages in the InnoDB buffer pool. Statistic: Mean Interval: 1 minute |
1 minute |
InnoDBBufferPoolPagesFree |
InnoDB Buffer Pool Pages Free | count |
The number of free pages in the InnoDB buffer pool. Statistic: Mean Interval: 1 minute |
1 minute |
InnoDBBufferPoolPagesTotal |
InnoDB Buffer Pool Pages Total | count |
The total number of pages in the InnoDB buffer pool. Statistic: Mean Interval: 1 minute |
1 minute |
MemoryAllocated |
Memory Allocated | GB |
The total amount of memory allocated during the selected interval. Statistic: Max Interval: 1 minute |
1 minute |
MemoryUsed |
Memory Used | GB |
The maximum amount of memory used during the selected interval. Statistic: Max Interval: 1 minute |
1 minute |
MemoryUtilization |
Memory Utilization | percent |
The memory utilization for the DB system host. Statistic: Mean Interval: 1 minute |
1 minute |
MonitoringStatus |
Monitoring Status | NA |
The monitoring status of the DB system. Statistic: Mean Interval: 5 minutes |
5 minutes |
NetworkReceiveBytes |
Network Receive Bytes | bytes |
The network receive bytes for the DB system host. Statistic: Rate Interval: 1 minute |
1 minute |
NetworkTransmitBytes |
Network Transmit Bytes | bytes |
The network transmit bytes for the DB system host. Statistic: Rate Interval: 1 minute |
1 minute |
RowsDeleted |
Rows Deleted | count |
The number of times rows have been deleted from tables. Statistic: Rate Interval: 1 minute |
1 minute |
RowsInserted |
Rows Inserted | count |
The number of requests to insert a row in a table. Statistic: Rate Interval: 1 minute |
1 minute |
RowsReadByFirstIndexEntry |
Rows Read By First Index Entry | count |
The number of times the first entry in an index was read. Statistic: Rate Interval: 1 minute |
1 minute |
RowsReadByIndexLookup |
Rows Read By Index Lookup | count |
The number of requests to read a row based on a key. Statistic: Rate Interval: 1 minute |
1 minute |
RowsReadByIndexOrdered |
Rows Read By Index Ordered | count |
The number of requests to read the previous row in key order. Statistic: Rate Interval: 1 minute |
1 minute |
RowsReadByIndexScan |
Rows Read By Index Scan | count |
The number of requests to read the next row in key order. Statistic: Rate Interval: 1 minute |
1 minute |
RowsReadByLastIndexEntry |
Rows Read By Last Index Entry | count |
The number of requests to read the last key in an index. Statistic: Rate Interval: 1 minute |
1 minute |
RowsReadBySort |
Rows Read By Sort | count |
The number of requests to read a row based on a fixed position. Statistic: Rate Interval: 1 minute |
1 minute |
RowsReadByTableScan |
Rows Read By Table Scan | count |
The number of requests to read the next row in the data file. Statistic: Rate Interval: 1 minute |
1 minute |
RowsUpdated |
Rows Updated | count |
The number of requests to update a row in a table. Statistic: Rate Interval: 1 minute |
1 minute |
SelectFullJoin |
Select Full Join | count |
The number of joins that perform table scans because they do not use indexes. Statistic: Rate Interval: 1 minute |
1 minute |
SelectFullRangeJoin |
Select Full Range Join | count |
The number of joins that used a range search on a reference table. Statistic: Rate Interval: 1 minute |
1 minute |
SelectRange |
Select Range | count |
The number of joins that used ranges on the first table. Statistic: Rate Interval: 1 minute |
1 minute |
SelectRangeCheck |
Select Range Check | count |
The number of joins without keys that check for key usage after each row. Statistic: Rate Interval: 1 minute |
1 minute |
SelectScan |
Select Scan | count |
The number of joins that did a full scan of the first table. Statistic: Rate Interval: 1 minute |
1 minute |
SortMergePasses |
Sort Merge Passes | count |
The number of merge passes done by the sort algorithm. Statistic: Rate Interval: 1 minute |
1 minute |
SortRange |
Sort Range | count |
The number of sorts done using ranges. Statistic: Rate Interval: 1 minute |
1 minute |
SortRows |
Sort Rows | count |
The number of sorted rows. Statistic: Rate Interval: 1 minute |
1 minute |
SortScan |
Sort Scan | count |
The number of sorts done by scanning the table. Statistic: Rate Interval: 1 minute |
1 minute |
StatementLatency |
Statement Latency | ms | The statement latency for all executed statements.
Statistic: Rate Interval: 1 minute |
1 minute |
Statements |
Statement Count | count |
The number of statements executed against the DB system. Statistic: Rate Interval: 1 minute |
1 minute |
StorageAllocated |
Storage Space Allocated | GB |
The maximum amount of space allocated to the DB system during the interval. Statistic: Max Interval: 1 minute |
1 minute |
StorageUsed |
Storage Space Used | GB |
The maximum amount of space used during the interval. Statistic: Max Interval: 1 minute |
1 minute |
TemporaryTablesCreated |
Temporary Tables Created | count |
The number of internal temporary tables created by the DB system while executing statements. Statistic: Rate Interval: 1 minute |
1 minute |
TemporaryTablesCreatedOnDisk |
Temporary Tables Created On Disk | count |
The number of internal on-disk temporary tables created by the DB system while executing statements. Statistic: Rate Interval: 1 minute |
1 minute |
TerminatedClients |
Terminated Clients | count |
The number of connections that were terminated because the client disconnected without closing the connection properly. Statistic: Rate Interval: 1 minute |
1 minute |
TerminatedConnections |
Terminated Connections | count |
The number of failed attempts to connect to the DB system. Statistic: Rate Interval: 1 minute |
1 minute |