mysql参数备注

port = 3306
socket = /tmp/mysql.sock
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
pid-file = /usr/local/mysql/mysql.pid
user = mysql
server-id = 1

skip-name-resolve
skip-external-locking
back_log = 500
max_connections = 500
max_connect_errors = 300
open_files_limit = 65535
table_open_cache = 128 
max_allowed_packet = 4M
thread_concurrency = 8

key_buffer_size = 400M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
sort_buffer_size = 8M
join_buffer_size = 8M
max_heap_table_size = 16M
tmp_table_size = 8M
query_cache_size = 8M
query_cache_limit = 2M
thread_cache_size = 64

log_bin = mysql-bin
binlog_format = mixed
binlog_cache_size = 2M
expire_logs_days = 10

log_error = /var/log/mysql-error.log
slow_query_log = 1
long_query_time = 1
slow_query_log_file = /var/log/mysql-slow.log

#default-storage-engine = MyISAM
default_storage_engine = InnoDB
innodb_additional_mem_pool_size = 20M
innodb_buffer_pool_size = 1G
innodb_file_per_table = 1

#innodb_data_home_dir = /var/lib/mysql
#innodb_data_file_path = ibdata1:1024M;ibdata2:10M:autoextend
#innodb_log_group_home_dir = /var/lib/mysql
innodb_log_file_size = 500M
innodb_log_buffer_size = 20M
innodb_flush_log_trx_commit = 1