autocommit |
ON |
big_tables |
OFF |
binlog_expire_logs_seconds |
3600 |
binlog_row_metadata |
MINIMAL |
binlog_row_value_options |
PARTIAL_JSON |
binlog_transaction_compression |
OFF |
completion_type |
NO_CHAIN |
connect_timeout |
10 |
connection_memory_chunk_size |
8912 |
connection_memory_limit |
9223372036854775807 |
cte_max_recursion_depth |
1000 |
default_authentication_plugin |
CACHING_SHA2_PASSWORD |
foreign_key_checks |
ON |
global_connection_memory_limit |
9223372036854775807 |
global_connection_memory_tracking |
OFF |
group_replication_consistency |
EVENTUAL |
information_schema_stats_expiry |
86400 |
innodb_buffer_pool_dump_pct |
25 |
innodb_buffer_pool_instances |
Shape dependent, see
Section 13.3, “User Configurable Shape Dependent System Variables”
|
innodb_buffer_pool_size |
Shape dependent, see
Section 13.3, “User Configurable Shape Dependent System Variables”
|
innodb_ddl_buffer_size |
1048576 |
innodb_ddl_threads |
4 |
innodb_ft_enable_stopword |
ON |
innodb_ft_max_token_size |
84 |
innodb_ft_min_token_size |
3 |
innodb_ft_num_word_optimize |
2000 |
innodb_ft_result_cache_limit |
2000000000 |
innodb_ft_server_stopword_table |
NULL |
innodb_lock_wait_timeout |
50 |
innodb_log_writer_threads |
ON |
innodb_max_purge_lag_delay |
300000 |
innodb_max_purge_lag |
0 |
innodb_stats_persistent_sample_pages |
20 |
innodb_stats_transient_sample_pages |
8 |
interactive_timeout |
28800 |
local_infile |
OFF |
mandatory_roles |
Empty string |
max_allowed_packet |
67108864 |
max_binlog_cache_size |
4294967296 |
max_connect_errors |
100 |
max_connections |
Shape dependent, see
Section 13.3, “User Configurable Shape Dependent System Variables”
|
max_execution_time |
0 |
max_heap_table_size |
16777216 |
max_prepared_stmt_count |
Shape dependent, see
Section 13.3, “User Configurable Shape Dependent System Variables”
|
mysql_firewall_mode |
ON |
mysqlx_connect_timeout |
30 |
mysqlx_deflate_default_compression_level |
3 |
mysqlx_deflate_max_client_compression_level |
5 |
mysqlx_interactive_timeout |
28800 |
mysqlx_lz4_default_compression_level |
2 |
mysqlx_lz4_max_client_compression_level |
8 |
mysqlx_max_allowed_packet |
67108864 |
mysqlx_read_timeout |
28800 |
mysqlx_wait_timeout |
28800 |
mysqlx_write_timeout |
60 |
mysqlx_zstd_default_compression_level |
3 |
mysqlx_zstd_max_client_compression_level |
11 |
net_read_timeout |
30 |
net_write_timeout |
60 |
parser_max_mem_size |
18446744073709551615 |
regexp_time_limit |
32 |
sort_buffer_size |
262144 |
sql_mode |
ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION,
NO_ZERO_DATE, NO_ZERO_IN_DATE, ONLY_FULL_GROUP_BY,
STRICT_TRANS_TABLES |
sql_require_primary_key |
OFF |
sql_warnings |
OFF |
telemetry_log_disable |
OFF |
thread_pool_dedicated_listeners |
OFF |
thread_pool_max_transactions_limit |
Shape dependent, see
Section 13.3, “User Configurable Shape Dependent System Variables”
|
thread_pool_query_threads_per_group |
Shape dependent, see
Section 13.3, “User Configurable Shape Dependent System Variables”
|
time_zone |
UTC |
tmp_table_size |
16777216 |
transaction_isolation |
REPEATABLE-READ |
wait_timeout |
28800 |