Metrics for External MySQL DB Systems
You can use metrics, alarms, and notifications to monitor the key statistics of the MySQL instances in the Database Management-enabled External MySQL DB systems.
The metrics for 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.
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 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 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 |
BeginStatements |
Begin Statements | count |
The number of transaction BEGIN statements being executed by the DB system. Statistic: Rate Interval: 1 minute |
1 minute |
BinaryLogFileIOLatency |
Binary Log File I/O Latency | microseconds |
The I/O latency for binary log files. Statistic: Rate Interval: 1 minute |
1 minute |
BinaryLogReads |
Binary Log File I/O Bytes Read | bytes |
The average number of bytes read from the binary log. Statistic: Rate Interval: 1 minute |
1 minute |
BinaryLogSpaceUsage |
Binary Log Space Usage | bytes |
The space usage for binary log files. Statistic: Max Interval: 1 minute |
1 minute |
BinaryLogWrites |
Binary Log File I/O Bytes Written | bytes |
The average number of bytes written to the binary log. Statistic: Rate Interval: 1 minute |
1 minute |
CallStatements |
Call Statements | count |
The number of procedure calls. Statistic: Rate Interval: 1 minute |
1 minute |
CloseViaApiStatements |
Close Via Api Statements | count |
The number of CLOSE statements in the DB system using MySQL C API. Statistic: Rate Interval: 1 minute |
1 minute |
CommitStatements |
Commit Statements | count |
The number of transaction COMMIT statements being executed in the DB system. Statistic: Rate Interval: 1 minute |
1 minute |
ConflictsDetected |
Group Replication Conflicts Detected | count |
The number of transactions that have not passed the conflict detection check. Statistic: Rate 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 |
DeallocateStatements |
Deallocate Statements | count |
The number of deallocated prepared statements. Statistic: Rate Interval: 1 minute |
1 minute |
DeleteStatements |
Delete Statements | count |
The number of DELETE statements being executed by the DB system. Statistic: Rate Interval: 1 minute |
1 minute |
ExecuteStatements |
Execute Statements | count |
The number of EXECUTE statements run by the DB system. Statistic: Rate Interval: 1 minute |
1 minute |
ExecuteViaApiStatements |
Execute Via Api Statements | count |
The number of EXECUTE statements in the DB system using MySQL C API. Statistic: Rate Interval: 1 minute |
1 minute |
FetchViaApiStatements |
Fetch Via Api Statements | count |
The number of FETCH statements in the DB system using MySQL C API. 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 |
InsertStatements |
Insert Statements | count |
The number of INSERT statements being executed by the DB system. Statistic: Rate 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 |
PrepareStatements |
Prepare Statements | count |
The number of PREPARE statements being executed by the DB system. Statistic: Rate Interval: 1 minute |
1 minute |
PrepareViaApiStatements |
Prepare Via Api Statements | count |
The number of PREPARE statements that were prepared using MySQL C API. Statistic: Rate Interval: 1 minute |
1 minute |
RelayLogIOBytesRead |
Relay LogFile I/O Bytes Read | bytes |
The number of bytes read for the relay log I/O event. Statistic: Rate Interval: 1 minute |
1 minute |
RelayLogIOBytesWritten |
Relay LogFile I/O Bytes Written | bytes |
The number of bytes written for the relay log I/O event. Statistic: Rate Interval: 1 minute |
1 minute |
RelayLogIOLatency |
Relay LogFile I/O Latency | microseconds |
The total wait time of timed occurrences of the relay log I/O event. Statistic: Rate Interval: 1 minute |
1 minute |
RelayLogIOSpaceUsage |
Relay Log Space Usage | bytes |
The total relay log space usage for all replication channels. Statistic: Rate Interval: 1 minute |
1 minute |
ReleaseSavepoint |
Release Savepoint Statements | count |
The number of transaction RELEASE SAVEPOINT statements being executed by the DB system. Statistic: Rate Interval: 1 minute |
1 minute |
ReplaceStatements |
Replace Statements | count |
The number of REPLACE statements being executed by the DB system. Statistic: Rate Interval: 1 minute |
1 minute |
RepreparedStatements |
Reprepared Statements | count |
The number of statements being reprepared by the DB system. Statistic: Rate Interval: 1 minute |
1 minute |
RollbackStatements |
Rollback Statements | count |
The number of transaction ROLLBACK statements being executed by the DB system. Statistic: Rate Interval: 1 minute |
1 minute |
RollbackToSavepoint |
Rollback To Savepoint Statements | count |
The number of transaction ROLLBACK TO SAVEPOINT statements being executed by the DB system. 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 |
SavepointStatements |
Savepoint Statements | count |
The number of transaction SAVEPOINT statements being executed by the DB system. 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 |
SelectStatements |
Select Statements | count |
The number of SELECT statements being executed by the DB system. 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 |
TransactionsChecked |
Transactions Checked | count |
The number of transactions that have been checked for conflicts. Statistic: Rate Interval: 1 minute |
1 minute |
TransactionsInQueue |
Transactions In Queue | count |
The number of transactions in the queue pending conflict detection checks. Statistic: Mean Interval: 1 minute |
1 minute |
TransactionsRowsValidating |
Transactions Rows Validating | count |
The number of transaction rows that can be used for certification, but have not been garbage collected. Statistic: Mean Interval: 1 minute |
1 minute |
UpdateStatements |
Update Statements | count |
The number of UPDATE statements being executed by the DB system. Statistic: Rate Interval: 1 minute |
1 minute |