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. In addition, if the DB system 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 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 and
whether HeatWave is enabled. 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 and its attached HeatWave cluster, if any.
Note that the alarms are only displayed in Database Management if the OCID of the DB system is specified using the
resourceIddimension 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 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 MySQL HeatWave DB System Metric Charts.
- 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:
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.
Note that 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 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
icon adjacent to the name of the configuration variable to view
the default and current value.
- Alarm definitions: Create Oracle-recommended alarms and perform other alarm-related tasks in Database Management. For information, see Set Up Alarm Definitions for HeatWave DB Systems.