Monitor a Single MySQL HeatWave DB System

You can monitor and manage a single MySQL HeatWave DB system using Database Management.

The information about a single DB system in your fleet is displayed on the corresponding MySQL database details page. To go to the MySQL database details page, click the name of the DB system on the MySQL HeatWave fleet summary page.

On the MySQL database details page, you can:

  • Click Performance Hub to go to Performance Hub and monitor and analyze SQL performance. For information, see Use Performance Hub to Analyze SQL Performance.
  • View MySQL database information, which includes details such as the compartment, name, OCID, and version of the DB system. In the MySQL database information section, you can:
    • Click the DB system name link to go to the DB system details page in the MySQL HeatWave service. Note that you must have the required MySQL HeatWave service permissions to go to the DB system details page. For information, see Additional Permissions Required to Use Database Management.
    • Monitor the total number of open alarms and the number of alarms by severity for the DB system. Note that the alarms are only displayed in Database Management if the OCID of the DB system is specified using the resourceId dimension when creating the alarm. You can click the number of alarms to access the Alarms panel and review the list of open alarms. For information, see Monitor Alarms for MySQL HeatWave DB Systems.
  • Monitor DB system status and metrics in the Summary section for the time period selected in the Time period drop-down list. Last 60 min is the default time period.
    • Monitoring status timeline: Monitor the status of the DB system during the selected period of time. The monitoring status indicates whether Database Management can collect monitoring metrics for the DB system. The color of the blocks denotes the status and the number of blocks denotes the time slots within the selected time period over which status is checked. For example, if the default time period, Last 60 min, is selected, then each block represents a period of two minutes. Here's information on what the color of the blocks in the Monitoring status timeline denotes:
      • Green: DB system is available and monitored during the selected time period.
      • Amber: DB system is partially monitored during the selected time period. This status is displayed if the DB system was available and monitored for some part of the time and monitoring had stopped for the remaining duration.
      • Grey: DB system is not monitored as it's down or has metric collection issues caused by network, connection, or missing data.
    • Metric charts such as Average statement latency (seconds) and CPU %: Monitor visual representations of DB system metrics or metric charts in the Summary section to obtain a quick insight into the performance and core resource utilization of your DB system. These charts enable you to analyze data better by monitoring different parameters such as active connections, disk operations and throughput. You can hover the mouse on the charts to view additional details such as the metric name (Series), date and time, and value; and filter the data in the charts by clicking the options displayed in the legend. For descriptions of the metric charts, see MySQL HeatWave DB System Metric Charts.

The Summary section is displayed by default on the MySQL database details page, however, you can click one of the other options on the left pane under Resources to perform the following tasks:

  • Metrics: Monitor a wide range of key DB system metrics across areas to proactively investigate and identify the root cause of performance issues. The charts in this section include those displayed in the Summary section and other metric charts such as InnoDB buffer pool usage (pages). In addition to the charts displayed in this section by default, you can select other metric charts from the Select charts drop-down list adjacent to the Time period field, for an in-depth examination using different indicators. For descriptions of the metric charts, see MySQL HeatWave DB System Metric Charts.
  • Configuration variables: Monitor the configuration variables of the DB system. Configuration variables are the user, system, initialization, or service-specific variables that define the operation of the DB system. For information on configuration variables, see Configuration variables.

    In the Configuration variables section, you can:

    • Use the filters on the left pane to filter the configuration variables.
    • Click the MDS configuration link to go to the Configuration details page in the MySQL HeatWave service and view the MySQL configuration used by the DB system. For information on the Configuration details page, see Viewing Configuration Details.
    • Deselect the Hide unmodified variables check box to view the variables that were not modified. This check box is selected by default.
    • View the following configuration variable information:
      • Name: Name of the configuration variable.
      • Value: Value of the configuration variable.
      • Modified: Check mark to indicate if the configuration variable was modified.
      • Dynamic: Check mark to indicate if the configuration variable is a dynamic variable, which means changing the variable does not require restarting the DB system.
      • Configurable: Check mark to indicate if the configuration variable is configurable.
      • Source: Source from which the configuration variable was most recently set. For information on the various types of sources, see Performance Schema variables_info Table.
      • Time set: Date and time the configuration variable was most recently set.

      Click the Arrow icon adjacent to the name of the configuration variable to view the default and current value.