15.3 MySQL Configuration Details

Follow these steps to view details of your MySQL configurations:

1. In the MySQL HeatWave Console, select the Configurations tab.
2. In the list of configurations, find the configuration for which you want to view its details, and do one of the following:
   • Click the row of the configuration to highlight it. The configuration details appear below the list of configurations. See Table 15-1 for an explanation of the details given.
   • Click the name of the configuration to open the Table 15-1 for the selected DB System.

The following actions can be taken for the configuration on either the MySQL HeatWave Console Configurations tab or on the MySQL Configuration Details page:

• Click Edit Configuration to open the Edit MySQL Configuration dialog box, in which you can edit the Basic information for the configuration including the Display name and Description. Note that no other properties of the configuration can be altered.
• Click Copy Configuration to create a new configuration based on the current configuration. After the Copy MySQL Configuration dialog opens, follow the instructions given in Copying a MySQL Configuration.
• Click Delete to delete the configuration if it is no longer needed by any DB Systems.

The following tables describe the information provided on the MySQL Configuration Details page.

Table 15-1 MySQL Configuration Details Page

Name	Description
Summary	Configuration summary details. See Table 15-2.
Variables	Variable information. See Table 15-3.
DB Systems	Information on DB Systems that use the configuration. See Table 15-4 .
Events	Event details. See Table 15-5.

Table 15-2 MySQL Configuration Summary Details

Field	Description
State	The state of the configuration: ACTIVE: The configuration was successfully created and is ready to be used. DELETED: The configuration has been deleted and is no longer available.
Resource ID	The resource ID assigned by MySQL HeatWave to the configuration.
Type	The type of configuration: Default: It is a default configuration for a MySQL shape. Custom It is a custom configuration created based on a Default configuration or another custom configuration.
Source MySQL Configuration	The source configuration based on which the current configuration was created, if this is a custom configuration.
Supports HeatWave	Whether the configuration supports HeatWave.
Shape	The MySQL shape for which the configuration was created. For information about shapes, see Supported Shapes.
Description	The description that was provided when the configuration was created.
Last updated	The date and time the configuration was last updated. If the configuration has never been updated, it shows the date of time of its creation.
Created	The date and time the configuration was created.

Table 15-3 MySQL Configuration Variables Details

Field	Description
Initialization variables	All the System Initialization Variables in the configuration.
User variables	Select a filter to show the variables and their values associated with the configuration: All: Show all configuration variables (default) Dynamic: Show all configuration variables that are dynamic and can be set at runtime. Shape or feature specific: Show all configuration variables that have MySQL shape or feature-specific values. Default: Show all configuration variables that have not been set by users. User-defined: Show all configuration variables that have been set by users. User-defined variables are those that have ever been set in either the Create MySQL Configuration or the Copy MySQL Configuration dialog when the configuration was created. The actual value of the variable does not matter: for example, you could have selected a variable in the configuration dialog and then left its displayed value (which was the value from your base configuration) unchanged, but the variable would still be taken as "user-defined" and displayed by this filter. You can also refine the list by typing into the search bar part of the names of the variables you are interested in.

Table 15-4 MySQL Configuration DB Systems Details

Field	Description
Name	Name of a DB System that uses the configuration. Click the name to see the MySQL DB System Details.
State	The state of the DB System that uses the configuration. See Table 3-5 for descriptions of the DB System states.
HeatWave Cluster	The HeatWave Cluster for the DB System that uses the configuration. Click the name to view the HeatWave Cluster Details.
HeatWave State	The state of the HeatWave Cluster of the DB System that uses the configuration. See Table 4-3 for descriptions of the HeatWave Cluster states.
Created	The date and time the DB System that uses the configuration was created.

Table 15-5 MySQL Configuration Event Details

Field	Description
Type	The event and its status.
Severity	The severity level of the event, which can be one of INFO: General information is provided. No special concerns WARNING: Warning on an event that might impact the DB System's operation if no actions are taken. CRITICAL: A critical event. An urgent action is required to avoid adverse impact on your DB System.
Message	The message body of the event report.
Created	The date and time the event report was created.

See Events for details on event reports.

Parent topic: Configuration