张国强唱二传:帮忙优化一下my.cnf

来源：百度文库编辑：中科新闻网时间：2024/04/29 13:04:49

P4 2.5G+1G DDR400
FreeBSD系统
运行
Apache2+PHP5+MySQL5+Postfix2
帮忙优化一下my.cnf
现有如下
[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log-bin=mysql-bin
server-id = 1

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[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

client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 160M
max_allowed_packet = 10M
table_cache = 640
sort_buffer_size = 5120K
net_buffer_length = 80K
read_buffer_size = 2560K
read_rnd_buffer_size = 5120K
myisam_sort_buffer_size = 80M
log-bin=mysql-bin
server-id = 1

[mysqldump]
quick
max_allowed_packet = 160M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 200M
sort_buffer_size = 200M
read_buffer = 20M
write_buffer = 20M

[myisamchk]
key_buffer = 200M
sort_buffer_size = 200M
read_buffer = 20M
write_buffer = 20M

[mysqlhotcopy]
interactive-timeout

帮忙优化一下my.cnf 什么是my.cnf 帮忙翻译一下《My love》这首歌谢谢~~ 帮忙写一下作文..my dream...{.interpreter.] By My Side 帮忙翻译一下歌词 my sql查询优化特点 windows优化注册认证码？帮忙一下，大侠们． windows优化注册认证码？帮忙一下，大侠们．帮忙翻译一下(How to make my dream come true) easy to love just to my love帮忙翻译一下