KLOXO安装后的mysql优化
12111
- hz5552010-12-03论坛元老1428
很多都是自己安装KLOXO面板。可是安装完一看内存,MYSQL竟然占用了130多M的内存。找了一晚,终于把MYSQL的占用内存降了下来,就是把/etc/下的my.cnf优化了
代码如下:port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 16K
max_allowed_packet = 1M
table_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 64K
skip-bdb
skip-innodbquick
max_allowed_packet = 16Mno-auto-rehash
#safe-updateskey_buffer = 8M
sort_buffer_size = 8Mkey_buffer = 8M
sort_buffer_size = 8Minteractive-timeout
把里面的代码替换为这个就行,然后重起MYSQL就OK。我是菜鸟,特来做个记号的!大家别见笑!
