MySQL HeatWave on AWS  /  Configuration  /  Service Specific System Variables

15.7 Service Specific System Variables

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

generated_random_password_length , query_alloc_block_size , and query_prealloc_size are also session variables. See Session 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%';