HeatWave on AWS  /  Configuration  /  Service-Specific System Variables

19.7 Service-Specific System Variables

HeatWave on AWS defines the following global system variables. It is not possible to edit them.

The SHOW VARIABLES statement with the GLOBAL modifier displays global system variable values:

Press CTRL+C to copy
mysql> SHOW GLOBAL VARIABLES;

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

Press CTRL+C to copy
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:

Press CTRL+C to copy
mysql> SHOW GLOBAL VARIABLES LIKE '%size%';