MySQL Database Service Metrics

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

Prerequisites

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.

oci_mysql_database

MySQL Database service metrics include the following dimensions:
  • 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.
MemoryUtilization Memory Utilization percent Memory Utilization for the MySQL Database host.
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

To view the default metric charts for a DB System:
  1. Open the navigation menu. Under MySQL, click DB Systems.
  2. 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.
  3. Under Resources, click Metrics.
    The Metrics page displays a default set of charts for the current DB System.
For more information about monitoring metrics and using alarms, see Monitoring Overview and Notifications Overview.

Viewing metrics for multiple DB Systems

To view the metric charts for multiple DB Systems:
  1. Open the navigation menu. Under Solutions and Platform, go to Monitoring, and click Service Metrics.
  2. For Compartment, select the compartment that contains the DB Systems you want to view.
  3. 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.
  4. Specify the required Metrics and Dimensions.
    See To filter results and To select different resources in the Monitoring documentation for more information.
For more information about monitoring metrics and using alarms, see Monitoring Overview and Notifications Overview.