mysql参数记录

default-storage-engine = InnoDB

skip-name-resolve
skip-external-locking

max_connections = 400
max_connect_errors = 10000

open_files_limit = 65535

table_open_cache = 300


max_allowed_packet = 4M

query_cache_limit = 2M
query_cache_size = 8M

slow_query_log = 1
long_query_time = 5
log-queries-not-using-indexes
slow_query_log_file = /var/log/mysql/mysql-slow.log

log-bin = 1
binlog_format = STATEMENT

innodb_open_files = 300
innodb_buffer_pool_size = 800M
innodb_additional_mem_pool_size = 4M  #比较大数据设置16Ｍ

innodb_purge_threads = 1 #默认

innodb_write_io_threads = 4 #默认

innodb_read_io_threads = 4 #默认

innodb_thread_concurrency = 1
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 2M
innodb_log_file_size = 32M
innodb_log_files_in_group = 3

后期加入注释