MySQL配置

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

[mysqldump]
max_allowed_packet=1G

[mysql]
no-auto-rehash
default_character_set=utf8
prompt=[\u@\h][\d]>\_

[mysqldump]
quick
max_allowed_packet=1G

[mysqld]
port=3306
basedir=/lingtian/opt/mysql
datadir=/lingtian/data/mysql/data
socket=/lingtian/data/mysql/data/mysql.sock
pid_file=/lingtian/data/mysql/data/mysql.pid
log_bin=/lingtian/data/mysql/binlog/mysql-bin-14-103
log_bin_index=/lingtian/data/mysql/binlog/mysql-bin-14-103.index
tmpdir=/lingtian/data/mysql/tmp
log_error=/lingtian/data/mysql/data/error.log
slow_query_log_file=/lingtian/data/mysql/slowlog/slow.log
relay_log=/lingtian/data/mysql/data/mysql-relay
plugin_dir=/lingtian/opt/mysql/lib/plugin
secure_file_priv=/lingtian/data/mysql/tmp

#global
server-id=14103
report_host=10.201.14.103
report-port=3306
character_set_server=utf8mb4
autocommit=1
user=mysql
skip-name-resolve
skip-external-locking
lower_case_table_names=1
#sql_mode=STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER
sql_mode=
interactive_timeout=300
wait_timeout=300
max_connections=1500
max_connect_errors=10000000
transaction_isolation=READ-COMMITTED
explicit_defaults_for_timestamp=1
read_buffer_size=1M
read_rnd_buffer_size=16M
sort_buffer_size=16M
join_buffer_size=16M
tmp_table_size=64M
max_heap_table_size=64M
table_open_cache=2048
max_allowed_packet=1G
query_cache_type=0
query_cache_size=0
slow_query_log=1
long_query_time=1
log_queries_not_using_indexes=0
log_slow_admin_statements=1
log_slow_slave_statements=1
log_throttle_queries_not_using_indexes=10
character-set-client-handshake=0
expire_logs_days=10  
back_log=50
log_timestamps=SYSTEM
show_compatibility_56=on
log_error_verbosity=2


#innodb
innodb_flush_log_at_trx_commit=1
innodb_numa_interleave=on
innodb_data_file_path=ibdata1:512M;ibdata2:512M:autoextend
innodb_buffer_pool_size=8G
innodb_buffer_pool_instances=4
innodb_buffer_pool_load_at_startup=1
innodb_buffer_pool_dump_at_shutdown=1
innodb_lru_scan_depth=2048
innodb_lock_wait_timeout=10
lock_wait_timeout=60
innodb_io_capacity=1500
innodb_io_capacity_max=65536
innodb_flush_method=O_DIRECT
innodb_undo_logs=128
innodb_undo_tablespaces=4
innodb_flush_neighbors=0
innodb_log_file_size=1G
innodb_log_files_in_group=4
innodb_log_buffer_size=16M
innodb_purge_threads=4
innodb_large_prefix=1
innodb_thread_concurrency=8
innodb_print_all_deadlocks=1
innodb_strict_mode=1
innodb_write_io_threads=8
innodb_read_io_threads=8 
innodb_file_per_table=1
innodb_max_dirty_pages_pct=70
innodb_open_files=65535
innodb_rollback_on_timeout=off
innodb_stats_on_metadata=off
innodb_undo_log_truncate=1
innodb_max_undo_log_size = 2G

#replication
slave_pending_jobs_size_max=67108864
binlog_cache_size=4M
master_info_repository=TABLE
relay_log_info_repository=TABLE
sync_binlog=1
gtid_mode=on
enforce_gtid_consistency=on
log_slave_updates
binlog_format=ROW
binlog_rows_query_log_events=1
relay_log_recovery=1
binlog_gtid_simple_recovery=on
slave-parallel-type=LOGICAL_CLOCK
slave-parallel-workers=8
slave_preserve_commit_order=1
read_only=1 
slave_net_timeout = 8

rpl_semi_sync_slave_enabled=1
rpl_semi_sync_master_timeout =31536000000
rpl_semi_sync_master_wait_for_slave_count=1

performance-schema-instrument='memory/%=ON'