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

The information about a single DB system in your fleet is displayed on the corresponding MySQL database details page. If monitoring a HeatWave DB system that has an attached HeatWave cluster, you can also view information about the HeatWave cluster and its metrics on the MySQL database details page. For information, see Monitor a HeatWave Cluster.

To go to the MySQL database details page, click the name of the DB system on the HeatWave & External MySQL 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.
• Click Update display name to update the display name of an External MySQL DB system. Note that this option is only displayed for an External MySQL DB system.
• View MySQL database information, which includes details such as the compartment, deployment, OCID, and version of the DB system. For a HeatWave DB system, additional information such as whether HeatWave is enabled is also displayed. In the MySQL database information section, you can:
  • Click the DB system name link for a HeatWave DB system to go to the DB system details page in the HeatWave service. Note that the DB system name link is only displayed for a HeatWave DB system and you must have the required HeatWave service permissions to go to the DB system details page. For information, see Additional Permissions Required to Use Database Management for HeatWave.
  • Monitor the total number of open alarms and the number of alarms by severity for the DB system and its attached HeatWave cluster, if any. Note that an alarm is 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 HeatWave and External MySQL.
• 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.
    • Red: DB system is down during the selected time period. This status is only displayed for the External MySQL DB system.
    • 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 the visual representation 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; filter the data in the charts by clicking the options displayed in the legend. For descriptions of the metric charts, see HeatWave and External MySQL 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 you can select other metric charts from the Select charts drop-down list adjacent to the Time period field. These charts provide an in-depth examination using different indicators. For descriptions of the metric charts, see HeatWave and External MySQL DB System Metric Charts.
• Configuration variables: Monitor the configuration variables that are currently used by running instances. 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 HeatWave service and view the MySQL configuration used by the HeatWave DB system. Note that the MDS configuration link is only displayed for a HeatWave DB system and you must have the required MySQL HeatWave service permissions to go to the Configuration details page. For information, see Additional Permissions Required to Use Database Management for HeatWave.

    For information on the Configuration details page in the HeatWave service, 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.

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

    • 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.
• Alarm definitions: Create Oracle-recommended alarms and perform other alarm-related tasks in Database Management. For information, see Set Up Alarm Definitions for HeatWave and External MySQL.
• Connectors: View or add connectors to connect to the External MySQL DB system. To add a connector, click Add connector and specify the required information in the Add connector panel. For information on the fields displayed in the Add connector panel, see Register an External MySQL DB System.

  Note that the Connectors option under Resources is only displayed for an External MySQL DB system and you must have the required External MySQL DB system permissions to perform connector-related tasks. For information, see Permissions Required to Register External MySQL DB Systems and Enable Database Management.

  In the Connectors section for an External MySQL DB system, you can also:

  • Click the display name of the connector to go to the Connector details page and view connector information and monitor associated work requests.
  • Click the Actions icon () for a connector and perform the following tasks:
    • Associate: Click to associate with the connector and start monitoring the DB system.
      Note
      
      If you want to associate a newly added connector to enable Database Management instead of the currently associated connector, click Associate for the new connector. By associating the newly added connector, you will also be dissociating the currently associated connector and it does not have to be dissociated manually.
    • Dissociate: Click to dissociate the connector and stop monitoring the DB system. Note that dissociating the connector will also disable Database Management.
    • Copy OCID: Click to copy the OCID of the connector.
    • Delete: Click to delete the connector. Note that deleting the connector resource will also disable Database Management.