测试一个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