MySQL HeatWave on AWS  /  Configuration  /  System Initialization Variables

14.4 System Initialization Variables

System initialization variables are global system variables that must be set during DB system initialization. They apply for the life span of the DB system and, once applied, you cannot change them.

Configure the following variables with the MySQL HeatWave Console. See Creating a MySQL Configuration and Copying a MySQL Configuration.

Note:

Any change to the configuration of a DB system cannot change the system initialization variables.

Table 14-5 Initialization Variables

Name Value
lower_case_table_names
  • CASE_SENSITIVE: (Default) Table and schema name comparisons are case-sensitive and are stored as you specify them. Selecting CASE_SENSITIVE sets the system variable, lower_case_table_names,to 0.
  • CASE_INSENSITIVE_LOWERCASE: Table and schema name comparisons are not case-sensitive and stored in lowercase. SelectingCASE_INSENSITIVE_LOWERCASE sets the system variable, lower_case_table_names,to 1.