mysql my.cnf模板_MySQL的My.cnf模板（转）

[client]

default-character-set =utf8mb4

port=PORT

socket= /srv/myPORT/run/mysql.sock

[mysqld]

user=mysql

port=PORT

extra-port =1PORT

character_set_server=utf8mb4

server_id=SERVER_ID

socket= /srv/myPORT/run/mysql.sock

basedir= /opt/percona-server

datadir= /srv/myPORT/data

log-error = /srv/myPORT/log/alert.log

pid-file = /srv/myPORT/run/mysql.pid

log_slave_updates= 1log-bin = /srv/myPORT/log/mysql-bin

binlog_format=row

binlog_cache_size=2M

max_binlog_cache_size=4G

max_binlog_size=1G

expire_logs_days= 7relay-log = /srv/myPORT/log/relay-bin

relay-log-info-file = /srv/myPORT/log/relay-log.inforelay-log-index = /srv/myPORT/log/relay-log.index

master-info-file = /srv/myPORT/log/master.inforelay-log-recovery = true

sync-relay-log-info = 1explicit_defaults_for_timestamp

key_buffer_size=2M

sort_buffer_size=2M

read_buffer_size=2M

read_rnd_buffer_size=16M

join_buffer_size=2M

thread_cache_size= 1024query_cache_size=1M

query_cache_limit=1M

query_cache_min_res_unit=2k

table_open_cache= 2048open_files_limit= 65535back_log= 3000max_connections= 4000max_user_connections= 2500max_connect_errors= 100max_allowed_packet=512M

thread_stack=192k

default-storage-engine =INNODB

transaction_isolation= READ-COMMITTED

tmp_table_size=16M

max_heap_table_size=64M

bulk_insert_buffer_size=64M

long_query_time= 0.5slow_query_log=on

slow_query_log_file= /srv/myPORT/log/slow.log

skip-name-resolve

innodb_buffer_pool_size=10G

innodb_data_file_path=ibdata1:2G:autoextend

innodb_file_io_threads= 24innodb_purge_threads= 12innodb_read_io_threads= 24innodb_write_io_threads= 24innodb_thread_concurrency= 24innodb_buffer_pool_instances= 8innodb_flush_log_at_trx_commit= 1innodb_log_buffer_size=16M

innodb_log_file_size=2G

innodb_log_files_in_group= 2innodb_max_dirty_pages_pct= 75innodb_lock_wait_timeout= 50innodb_file_per_table= 1thread_handling= pool-of-threads

thread_pool_idle_timeout= 180thread_pool_max_threads= 5000thread_pool_size= 24thread_pool_oversubscribe= 10thread_pool_stall_limit= 500[mysqldump]

quick

max_allow_packet=64M

[mysql]

no-auto-rehash

[mysqlhotcopy]

interactive-timeout