MySQL :: MySQL HeatWave on AWS :: 13.2 User Configurable System Variables

MySQL HeatWave on AWS / Configuration / User Configurable System Variables

13.2 User Configurable System Variables

Configure the following global system variables with the MySQL HeatWave Console. See Section 3.3, “Creating a MySQL Configuration”.

Table 13.2 User Configurable System Variables

Name	Default Value
`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`

PREV HOME UP NEXT