mysql5.7配置文档_mysql 5.7配置文件

[client]

port=3306

socket=/data/mysql/mysql.sock

#default_character_set=utf8

[mysqld]

########basicsettings########

port=3306

user=mysql

bind_address=0.0.0.0

autocommit=0

character_set_server=utf8mb4

skip_name_resolve=1

max_connections=800

max_connect_errors=1000

basedir=/usr/local/mysql

datadir=/data/mysql/

transaction_isolation=READ-COMMITTED

join_buffer_size=134217728

tmp_table_size=67108864

tmpdir=/tmp

max_allowed_packet=16777216

socket=/data/mysql/mysql.sock

pid-file=/data/mysql/mysql.pid

interactive_timeout=1800

wait_timeout=1800

read_buffer_size=16777216

read_rnd_buffer_size=33554432

sort_buffer_size=33554432

########logsettings########

log_error=error.log

slow_query_log=1

slow_query_log_file=slow.log

log_queries_not_using_indexes=1

log_slow_admin_statements=1

log_slow_slave_statements=1

log_throttle_queries_not_using_indexes=10

expire_logs_days=90

long_query_time=2

min_examined_row_limit=100

########replicationsettings########

master_info_repository=TABLE

relay_log_info_repository=TABLE

server-id=1    ####另一台设置为2

auto_increment_offset=1  ####另一台设置为2

auto_increment_increment=2

log_bin=mysql-bin

sync_binlog=1

gtid_mode=on

enforce_gtid_consistency=1

log_slave_updates=1

binlog_format=row

relay_log=relay.log

relay_log_recovery=1

binlog_gtid_simple_recovery=1

slave_skip_errors=ddl_exist_errors

########innodbsettings########

innodb_page_size=8192

innodb_buffer_pool_size=6G

innodb_buffer_pool_instances=8

innodb_buffer_pool_load_at_startup=1

innodb_buffer_pool_dump_at_shutdown=1

innodb_lru_scan_depth=2000

innodb_lock_wait_timeout=5

innodb_io_capacity=4000

innodb_io_capacity_max=8000

innodb_flush_method=O_DIRECT

innodb_file_format=Barracuda

innodb_file_format_max=Barracuda

innodb_undo_logs=128

innodb_undo_tablespaces=3

innodb_flush_neighbors=1

innodb_log_file_size=1G

innodb_log_buffer_size=16777216

innodb_purge_threads=4

innodb_large_prefix=1

innodb_thread_concurrency=64

innodb_print_all_deadlocks=1

innodb_strict_mode=1

innodb_sort_buffer_size=67108864

########semisyncreplicationsettings########

plugin_dir=/usr/local/mysql/lib/plugin

plugin_load="rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so"

loose_rpl_semi_sync_master_enabled=1

loose_rpl_semi_sync_slave_enabled=1

loose_rpl_semi_sync_master_timeout=5000

[mysqld-5.7]

innodb_buffer_pool_dump_pct=40

innodb_page_cleaners=4

innodb_undo_log_truncate=1

innodb_max_undo_log_size=2G

innodb_purge_rseg_truncate_frequency=128

binlog_gtid_simple_recovery=1

log_timestamps=system