Mysql 参数

 [client]
port    = 7999
socket  = /tmp/mysql.sock
[mysqld]
port    = 7999
socket  = /tmp/mysql.sock
datadir = /data/mysql/data
log-error = /data/mysql/log/45.err
slave_skip_errors = all
skip_external_locking
skip-name-resolve
back_log = 400
key_buffer_size = 3072M 
max_allowed_packet = 500M
table_open_cache = 2048
table_definition_cache = 1024     
tmp_table_size = 200M
max_heap_table_size = 128M
thread_cache_size = 80
read_buffer_size = 4M
sort_buffer_size = 4M
read_rnd_buffer_size = 4M
join_buffer_size = 4M   
myisam_sort_buffer_size = 64M
innodb_buffer_pool_size=40000M
innodb_flush_log_at_trx_commit=1
innodb_additional_mem_pool_size=100M
innodb_file_per_table=1
innodb_log_files_in_group=3
innodb_log_file_size=1024M
innodb_flush_method            = O_DIRECT
binlog_cache_size = 2M
wait_timeout = 1200 
interactive_timeout = 1200
max_connections = 10000
max_connect_errors = 10
connect_timeout = 10            
thread_concurrency = 8
query_cache_size = 0
query_cache_limit = 2M
query_cache_type = 0
sync_binlog = 1
log_queries_not_using_indexes 
long_query_time = 3
slow_query_log = 1
slow_query_log_file = /data/mysql/log/slow_query.log
expire_logs_days = 10
open_files_limit = 30000
server-id = 1
log-bin = /data/mysql/log/mysql-bin
binlog-ignore-db = mysql
binlog-format = ROW

 
 
[mysqldump]
quick
max_allowed_packet = 500M
 
[mysql]
no-auto-rehash
default-character-set = utf8
 
[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
 
[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
 
[mysqlhotcopy]
interactive-timeout