PDF (US Ltr)
- 1.2Mb
PDF (A4)
- 1.2Mb
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
Section 13.6, “Session Variables”.
Table 13.9 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%';