This topic describes the integration with the Monitoring service. The following topics are described:
Overview of MySQL Database Service Metrics
You can monitor the health, capacity, and performance of your Oracle Cloud Infrastructure MySQL Database Service resources by using metrics, alarms, and notifications. For more information, see Monitoring Overview and Notifications Overview.
The MySQL Database Service metrics enable you to measure useful quantitative data about your MySQL Databases, such as current connection information, statement activity and latency, host CPU, memory and disk IO utilization, and so on. You can use metrics data to diagnose and troubleshoot problems with MySQL Databases. For a complete list of available metrics for MySQL Database Service, see Available Metrics
IAM policies: To monitor resources, you must be given the required type of access in a policy written by an administrator, whether you're using the Console or the REST API with an SDK, CLI, or other tool. The policy must give you access to the monitoring services as well as the resources being monitored. If you try to perform an action and get a message that you don’t have permission or are unauthorized, confirm with your administrator the type of access you've been granted and which compartment you should work in. For more information on user authorizations for monitoring, see the Authentication and Authorization section for the related service: Monitoring or Notifications.
Available Metrics: oci_mysql_database
The metrics described in the following table are automatically available for all MySQL Database DB Systems you create. It is not necessary to enable monitoring on the resource to see these metrics.
- resourceId: the OCID of the DB System.
- resourceName: the name of the DB System.
Table 10-1 MySQL Database Service Metrics
|Metric||Metric Display Name||Unit||Description|
|CurrentConnections||Current Connections||count||The total number of connections to the MySQL Database.|
|ActiveConnections||Active Connections||count||The number of active connections to the MySQL Database.|
|Statements||Statement Count||count||The number of statements executed against the MySQL Database.|
|StatementLatency||Statement Latency||ms||Statement latency for all executed statements.|
|CPUUtilization||CPU Utilization||percent||CPU Utilization for the MySQL Database host or HeatWave nodes.|
|MemoryUtilization||Memory Utilization||percent||Memory Utilization for the MySQL Database host or HeatWave nodes.|
|DbVolumeReadOperations||Disk Read Operations||count||The total number of read operations for the DB volume(s).|
|DbVolumeWriteOperations||Disk Write Operations||count||The total number of write operations for the DB volume(s).|
Viewing metrics for a single DB System
- Open the navigation menu. Under MySQL, click DB Systems.
- Choose the Compartment that contains the DB System you want to view, then click the display name of the DB System to view its details.
- Under Resources, click Metrics.The Metrics page displays a default set of charts for the current DB System.
Viewing metrics for multiple DB Systems
- Open the navigation menu. Under Solutions and Platform, go to Monitoring, and click Service Metrics.
- For Compartment, select the compartment that contains the DB Systems you want to view.
- Under Metric Namespace, select oci_mysql_database.The Service Metrics page dynamically updates the page to show charts for each metric that is emitted by the selected metric namespace.
- Specify the required Metrics and Dimensions.