18.7 Service-Specific System Variables
HeatWave on AWS defines the following global system variables. It is not possible to edit them.
Note:
generated_random_password_length
,
query_alloc_block_size
, and
query_prealloc_size
are also session variables. See Session Variables.
Table 18-14 Service-Specific Global System Variables
Name | Default Value |
---|---|
generated_random_password_length
|
20
|
mysqlx_document_id_unique_prefix
|
0
|
mysqlx_enable_hello_notice
|
ON
|
mysqlx_idle_worker_thread_timeout
|
60
|
mysqlx_min_worker_threads
|
2
|
query_alloc_block_size
|
8192
|
query_prealloc_size
|
8192
|
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%';
Parent topic: Configuration