15.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 15-6 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.

Parent topic: Configuration