mysql5.7 新增参数_MySQL 5.7 新增参数

参数

默认值

binlog_group_commit_sync_delay

0

binlog_group_commit_sync_no_delay_count

0

binlog_transaction_dependency_history_size

25000

binlog_transaction_dependency_tracking

COMMIT_ORDER

check_proxy_users

OFF

default_authentication_plugin

mysql_native_password

default_password_lifetime

0

disabled_storage_engines

gtid_executed_compression_period

1000

have_statement_timeout

YES

innodb_adaptive_hash_index_parts

8

innodb_buffer_pool_chunk_size

134217728

innodb_buffer_pool_dump_pct

25

innodb_deadlock_detect

ON

innodb_default_row_format

dynamic

innodb_fill_factor

100

innodb_flush_sync

ON

innodb_log_checksums

ON

innodb_log_write_ahead_size

8192

innodb_page_cleaners

4

innodb_purge_rseg_truncate_frequency

128

innodb_temp_data_file_path

ibtmp1:12M:autoextend

innodb_undo_log_truncate

OFF

internal_tmp_disk_storage_engine

InnoDB

keyring_operations

ON

log_builtin_as_identified_by_password

OFF

log_error_verbosity

3

log_statements_unsafe_for_binlog

ON

log_syslog

OFF

log_syslog_facility

daemon

log_syslog_include_pid

ON

log_syslog_tag

log_timestamps

UTC

max_execution_time

0

max_points_in_geometry

65536

mysql_native_password_proxy_users

OFF

ngram_token_size

2

offline_mode

OFF

parser_max_mem_size

18446744073709551615

performance_schema_events_transactions_history_long_size

10000

performance_schema_events_transactions_history_size

10

performance_schema_max_index_stat

-1

performance_schema_max_memory_classes

320

performance_schema_max_metadata_locks

-1

performance_schema_max_prepared_statements_instances

-1

performance_schema_max_program_instances

-1

performance_schema_max_sql_text_length

1024

performance_schema_max_statement_stack

10

performance_schema_max_table_lock_stat

-1

range_optimizer_max_mem_size

8388608

rbr_exec_mode

STRICT

require_secure_transport

OFF

session_track_gtids

OFF

session_track_schema

ON

session_track_state_change

OFF

session_track_system_variables

time_zone,autocommit,character_set_client,character_set_results,character_set_connection

session_track_transaction_info

OFF

sha256_password_proxy_users

OFF

show_compatibility_56

OFF

show_create_table_verbosity

OFF

slave_parallel_type

DATABASE

slave_preserve_commit_order

OFF

super_read_only

OFF

tls_version

TLSv1,TLSv1.1

transaction_isolation

REPEATABLE-READ

transaction_read_only

OFF

transaction_write_set_extraction

OFF