2015年12月21日 my.cnf 配置

 

 

[client]
port =36000
#socket =/tmp/mysql.socket
default-character-set=utf8

[mysqld]
#datadir=/var/lib/mysql
port =36000
#socket =/tmp/mysql.socket
#pid-file =/home/mysql/data/mysql.pid
#datadir =/home/mysql/data
skip-external-locking
skip-name-resolve
character_set_server=utf8
character_set_client=utf8
collation-server=utf8_general_ci

#linux下mysql安装完后是默认：表名区分大小写，列名不区分大小写； 0：区分大小写，1：不区分大小写
lower_case_table_names=1

event_scheduler =1
default-time-zone='+8:00'

# safety
max_allowed_packet =16M
max_connect_errors =10000

# cache and limit
back_log =128
thread_concurrency =8
max_connections =1024
thread_cache_size =32
table_open_cache =1024
tmp_table_size =64M
max_heap_table_size =64M
sort_buffer_size =2M
read_rnd_buffer_size =8M
query_cache_size =0M
query_cache_limit =0M

# Myisam
key_buffer_size =128M
read_buffer_size =2M
myisam_sort_buffer_size =32M
bulk_insert_buffer_size =128M

# loging
log-error =mysql-error.log
slow_query_log =1
long_query_time =1
log-output =table

# Binary log
log-bin =mysql-bin
sync_binlog =0
expire_logs_days =7
binlog_format =mixed
binlog_cache_size =2M
log-slave-updates =1

# Replication
#server-id =2

#relay-log =slave-relay-bin
#master-connect-retry =60
#slave_net_timeout =60
#slave-skip-errors =all
#replicate-ignore-db =mysql
#replicate-wild-ignore-table =mysql.%
#report-host =192.168.250.7

# Innodb
#innodb_data_file_path =ibdata1:1G:autoextend
innodb_buffer_pool_size =25G
innodb_log_file_size =100M
innodb_log_files_in_group =2
innodb_log_buffer_size =8M
innodb_flush_log_at_trx_commit =2
innodb_file_per_table =1

[mysqldump]
quick
max_allowed_packet =64M

[mysql]
prompt =(\\u@\\h:\\d \\r:\\m)>
no-auto-rehash

[myisamchk]
key_buffer_size=256M
sort_buffer_size=128M
read_buffer=2M
write_buffer=2M

[mysqlhotcopy]
interactive-timeout