HeatWave on AWS  /  Configuration  /  Service-Specific System Variables

18.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:

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%';