11.2 Global System Variables

Global system variables are either static or managed by the DB System and cannot be modified. MySQL has numerous global system variables. The SHOW VARIABLES statement with the GLOBAL modifier displays global system variable values:

mysql> SHOW GLOBAL VARIABLES;

To obtain the value for a specific variable, use a LIKE clause as shown:

mysql> SHOW GLOBAL VARIABLES LIKE 'max_join_size';

To get a list of variables whose name match a pattern, use the % wildcard character in a LIKE clause:

mysql> SHOW GLOBAL VARIABLES LIKE '%size%';

Note

The lower_case_table_names system variable setting for MySQL HeatWave on AWS is 0, which means that table names are stored as specified and comparisons are case-sensitive. Applications that query tables in MySQL must therefore use the table name case as defined in MySQL.