MySQL 5.7 新增参数

 

这些数据是通过 ” show global variables ;” 获得,可能不是所有的新增参数。我的 MySQL 版本是5.7.24

 

参数

默认值

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

 

  • innodb_buffer_pool_chunk_size

buffer pool resing 操作时 chunk 的大小 。

  • innodb_default_row_format

默认的innodb表行格式。

  • innodb_fill_factor

指定 B-tree 页用于存放数据占空间比例。

  • innodb_log_checksums

启用或禁用重做日志页的校验和,取代了参数 innodb_log_checksum_algorithm

  • innodb_page_cleaners

Buffer pool 中用于刷新脏页的页清理线程的数量。

  • innodb_temp_data_file_path

指定临时表空间数据文件路径。

  • innodb_undo_log_truncate

在线收缩undo表空间。

  • slave_parallel_type

并行复制的类型。

  • transaction_isolation

用于替换参数 tx_isolation

  • transaction_read_only

用于替换参数 tx_read_only

 

posted @ 2018-12-03 15:28  AYard  阅读(434)  评论(0编辑  收藏