my.cnf
port = 3306
socket = /tmp/mysql.sock
default-character-set=gbk
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer_size = 1024000000
max_allowed_packet = 1M
table_open_cache = 300
sort_buffer_size = 8M
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
default-character-set=gbk
interactive_timeout=30
wait_timeout=30
query_cache_size=100M
query_cache_limit = 1M
max_connections=300
log-bin=mysql-bin
binlog_format=mixed
server-id = 1
innodb_buffer_pool_size = 1024M
innodb_log_file_size = 1024M
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
port = 3306
socket = /tmp/mysql.sock
default-character-set=gbk
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer_size = 1024000000
max_allowed_packet = 1M
table_open_cache = 300
sort_buffer_size = 8M
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
default-character-set=gbk
interactive_timeout=30
wait_timeout=30
query_cache_size=100M
query_cache_limit = 1M
max_connections=300
log-bin=mysql-bin
binlog_format=mixed
server-id = 1
innodb_buffer_pool_size = 1024M
innodb_log_file_size = 1024M
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout