笔记：mysql的my.cnf测试

测试一个mysql的my.cnf

[client]
port = 3306
socket = /data/mysql/mysql-3306.sock
[mysql]
socket=/data/mysql/mysql-3306.sock

[mysqld]
datadir=/data/mysql/data
log_error=/data/mysql/error.log
socket=/data/mysql/mysql-3306.sock

max_allowed_packet=1024M
skip_name_resolve=on

slow_query_log=on
long_query_time=0.5

lower_case_table_names=1
event_scheduler=0
default-time-zone='+8:00'

wait_timeout=172800
interactive_timeout=172800

explicit_defaults_for_timestamp=ON


##Innodb
innodb_buffer_pool_size=20G
innodb_adaptive_hash_index=off
innodb_log_file_size=2G
innodb_log_buffer_size=128M
innodb_log_files_in_group=3

innodb_undo_tablespaces=3
innodb_undo_log_truncate=on
innodb_rollback_on_timeout=on

innodb_flush_neighbors = 0
innodb_autoinc_lock_mode=2
innodb_flush_log_at_trx_commit = 1
#innodb_io_capacity=2000


innodb_status_output_locks = on

#transaction_isolation=READ-COMMITTED

##Repl
#log-bin=mysql-bin
#server_id=1
#binlog_format=row
#binlog_row_image=full

#gtid-mode=on
#enforce-gtid-consistency=true

#rpl_semi_sync_master_enabled=1
#rpl_semi_sync_master_timeout=10000
#rpl_semi_sync_slave_enabled=1

#slave_parallel_type=LOGICAL_CLOCK
#slave_parallel_workers=8

#binlog_transaction_dependency_tracking=WRITESET
#transaction_write_set_extraction=XXHASH64
#log_slow_slave_statements
#binlog-rows-query-log-events=on

#read_only=1
#super_read_only=1
#log_slave_updates=1
#skip-slave-start