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 |
|---|---|---|---|
Connections |
Connections | count |
The total number of successful and unsuccessful connection attempts to the DB system. Statistic: Rate |
HeatWaveAutoMLOperations |
HeatWave AutoML Operations | count |
The number of AutoML operations that have been executed. This number resets on HeatWave restart. Statistic: Rate |
HeatWaveChangePropagationLag |
HeatWave Change Propagation Lag | count |
The number of transactions that are not propagated to HeatWave yet. Statistic: Rate |
HeatWaveDataDictionaryBytes |
HeatWave Data Dictionary Bytes | bytes |
The size of the HeatWave data dictionary, which consumes heap space on the DB system nodes. Statistic: Rate |
HeatWaveDatasetBytes |
HeatWave Dataset Bytes | bytes |
The amount of data loaded in the HeatWave cluster. Statistic: Rate |
HeatWaveLakehouseLoadedBytes |
HeatWave Lakehouse Loaded Bytes | bytes |
The total size of all Lakehouse tables loaded into HeatWave. Statistic: Rate |
HeatWaveLoadedTablesAvailable |
HeatWave Loaded Tables Available | count |
The number of tables loaded into HeatWave that are available for use. Statistic: Rate |
HeatWaveLoadedTablesUnusable |
HeatWave Loaded Tables Unusable | count |
The number of tables loaded into HeatWave that are currently not available for use. Statistic: Rate |
InnoDBBufferPoolPagesDirty |
InnoDB Buffer Pool Pages Dirty | count |
The current number of dirty pages in the InnoDB buffer pool. Statistic: Mean |
InnoDBBufferPoolPagesFree |
InnoDB Buffer Pool Pages Free | count |
The number of free pages in the InnoDB buffer pool. Statistic: Mean |
InnoDBBufferPoolPagesTotal |
InnoDB Buffer Pool Pages Total | count |
The total number of pages in the InnoDB buffer pool. Statistic: Mean |
MonitoringStatus |
Monitoring Status | NA |
The monitoring status of the DB system. Statistic: Mean |
RowsDeleted |
Rows Deleted | count |
The number of times rows have been deleted from tables. Statistic: Rate |
RowsInserted |
Rows Inserted | count |
The number of requests to insert a row in a table. Statistic: Rate |
RowsReadByFirstIndexEntry |
Rows Read By First Index Entry | count |
The number of times the first entry in an index was read. Statistic: Rate |
RowsReadByIndexLookup |
Rows Read By Index Lookup | count |
The number of requests to read a row based on a key. Statistic: Rate |
RowsReadByIndexOrdered |
Rows Read By Index Ordered | count |
The number of requests to read the previous row in key order. Statistic: Rate |
RowsReadByIndexScan |
Rows Read By Index Scan | count |
The number of requests to read the next row in key order. Statistic: Rate |
RowsReadByLastIndexEntry |
Rows Read By Last Index Entry | count |
The number of requests to read the last key in an index. Statistic: Rate |
RowsReadBySort |
Rows Read By Sort | count |
The number of requests to read a row based on a fixed position. Statistic: Rate |
RowsReadByTableScan |
Rows Read By Table Scan | count |
The number of requests to read the next row in the data file. Statistic: Rate |
RowsUpdated |
Rows Updated | count |
The number of requests to update a row in a table. Statistic: Rate |
SelectFullJoin |
Select Full Join | count |
The number of joins that perform table scans because they do not use indexes. Statistic: Rate |
SelectFullRangeJoin |
Select Full Range Join | count |
The number of joins that used a range search on a reference table. Statistic: Rate |
SelectRange |
Select Range | count |
The number of joins that used ranges on the first table. Statistic: Rate |
SelectRangeCheck |
Select Range Check | count |
The number of joins without keys that check for key usage after each row. Statistic: Rate |
SelectScan |
Select Scan | count |
The number of joins that did a full scan of the first table. Statistic: Rate |
SortMergePasses |
Sort Merge Passes | count |
The number of merge passes done by the sort algorithm. Statistic: Rate |
SortRange |
Sort Range | count |
The number of sorts done using ranges. Statistic: Rate |
SortRows |
Sort Rows | count |
The number of sorted rows. Statistic: Rate |
SortScan |
Sort Scan | count |
The number of sorts done by scanning the table. Statistic: Rate |
TemporaryTablesCreated |
Temporary Tables Created | count |
The number of internal temporary tables created by the DB system while executing statements. Statistic: Rate |
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 |
TerminatedClients |
Terminated Clients | count |
The number of connections that were terminated because the client disconnected without closing the connection properly. Statistic: Rate |
TerminatedConnections |
Terminated Connections | count |
The number of failed attempts to connect to the DB system. Statistic: Rate |
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 |
|---|---|---|---|
ActiveConnections |
Active Connections | count |
The number of connections actively executing statements against the DB system. Statistic: Max |
Connections |
New Connections | count |
The total number of successful and unsuccessful connection attempts to the DB system. Statistic: Rate |
CPUsAllocated |
CPU Allocated | count |
The number of CPUs allocated during the selected interval. Statistic: Max |
CPUsUsed |
CPU Used | count |
The number of CPUs used during the selected interval. Statistic: Max |
CPUUtilization |
CPU Utilization | percent |
The CPU utilization for the DB system host. Statistic: Mean |
CurrentConnections |
Current Connections |
count |
The number of current connections to the DB system. Statistic: Max |
DbVolumeReadBytes |
Disk Read Bytes | bytes |
The total bytes read from the DB system volumes. Statistic: Rate |
DbVolumeReadOperations |
Disk Read Operations | count |
The total number of read operations for the DB volumes. Statistic: Rate |
DbVolumeUtilization |
Disk Space Utilization | percent |
The total space utilization of the DB system volumes. Statistic: Max |
DbVolumeWriteBytes |
Disk Write Bytes | bytes |
The total bytes written to the DB system volumes. Statistic: Rate |
DbVolumeWriteOperations |
Disk Write Operations | count |
The total number of write operations for the DB volumes. Statistic: Rate |
InnoDBBufferPoolPagesDirty |
InnoDB Buffer Pool Pages Dirty | count |
The current number of dirty pages in the InnoDB buffer pool. Statistic: Mean |
InnoDBBufferPoolPagesFree |
InnoDB Buffer Pool Pages Free | count |
The number of free pages in the InnoDB buffer pool. Statistic: Mean |
InnoDBBufferPoolPagesTotal |
InnoDB Buffer Pool Pages Total | count |
The total number of pages in the InnoDB buffer pool. Statistic: Mean |
MemoryAllocated |
Memory Allocated | GB |
The total amount of memory allocated during the selected interval. Statistic: Max |
MemoryUsed |
Memory Used | GB |
The maximum amount of memory used during the selected interval. Statistic: Max |
MemoryUtilization |
Memory Utilization | percent |
The memory utilization for the DB system host. Statistic: Mean |
MonitoringStatus |
Monitoring Status | NA |
The monitoring status of the DB system. Statistic: Mean |
NetworkReceiveBytes |
Network Receive Bytes | bytes |
The network receive bytes for the DB system host. Statistic: Rate |
NetworkTransmitBytes |
Network Transmit Bytes | bytes |
The network transmit bytes for the DB system host. Statistic: Rate |
RowsDeleted |
Rows Deleted | count |
The number of times rows have been deleted from tables. Statistic: Rate |
RowsInserted |
Rows Inserted | count |
The number of requests to insert a row in a table. Statistic: Rate |
RowsReadByFirstIndexEntry |
Rows Read By First Index Entry | count |
The number of times the first entry in an index was read. Statistic: Rate |
RowsReadByIndexLookup |
Rows Read By Index Lookup | count |
The number of requests to read a row based on a key. Statistic: Rate |
RowsReadByIndexOrdered |
Rows Read By Index Ordered | count |
The number of requests to read the previous row in key order. Statistic: Rate |
RowsReadByIndexScan |
Rows Read By Index Scan | count |
The number of requests to read the next row in key order. Statistic: Rate |
RowsReadByLastIndexEntry |
Rows Read By Last Index Entry | count |
The number of requests to read the last key in an index. Statistic: Rate |
RowsReadBySort |
Rows Read By Sort | count |
The number of requests to read a row based on a fixed position. Statistic: Rate |
RowsReadByTableScan |
Rows Read By Table Scan | count |
The number of requests to read the next row in the data file. Statistic: Rate |
RowsUpdated |
Rows Updated | count |
The number of requests to update a row in a table. Statistic: Rate |
SelectFullJoin |
Select Full Join | count |
The number of joins that perform table scans because they do not use indexes. Statistic: Rate |
SelectFullRangeJoin |
Select Full Range Join | count |
The number of joins that used a range search on a reference table. Statistic: Rate |
SelectRange |
Select Range | count |
The number of joins that used ranges on the first table. Statistic: Rate |
SelectRangeCheck |
Select Range Check | count |
The number of joins without keys that check for key usage after each row. Statistic: Rate |
SelectScan |
Select Scan | count |
The number of joins that did a full scan of the first table. Statistic: Rate |
SortMergePasses |
Sort Merge Passes | count |
The number of merge passes done by the sort algorithm. Statistic: Rate |
SortRange |
Sort Range | count |
The number of sorts done using ranges. Statistic: Rate |
SortRows |
Sort Rows | count |
The number of sorted rows. Statistic: Rate |
SortScan |
Sort Scan | count |
The number of sorts done by scanning the table. Statistic: Rate |
StatementLatency |
Statement Latency | ms | The statement latency for all executed statements.
Statistic: Rate |
Statements |
Statement Count | count |
The number of statements executed against the DB system. Statistic: Rate |
StorageAllocated |
Storage Space Allocated | GB |
The maximum amount of space allocated to the DB system during the interval. Statistic: Max |
StorageUsed |
Storage Space Used | GB |
The maximum amount of space used during the interval. Statistic: Max |
TemporaryTablesCreated |
Temporary Tables Created | count |
The number of internal temporary tables created by the DB system while executing statements. Statistic: Rate |
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 |
TerminatedClients |
Terminated Clients | count |
The number of connections that were terminated because the client disconnected without closing the connection properly. Statistic: Rate |
TerminatedConnections |
Terminated Connections | count |
The number of failed attempts to connect to the DB system. Statistic: Rate |