[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