Kloxo管理面板优化详解
六月 23, 2010 by admin · Leave a Comment
先SSH登录到服务器,
进入/etc 目录,编辑my.cnf
在[mysqld]下面加入以下三行:
skip-locking
skip-bdb
skip-innodb
保存之后在重启MYSQL
命令: /sbin/service mysqld restart
1.登上
用putty登陆你的VPS,执行:
service named stop;
chkconfig named off;
service qmail stop;
chkconfig qmail off;
chkconfig courier-imap off;
其实vps也可以禁用iptables的:
service iptables stop;
chkconfig iptables off;
二,优化mysql:
[mysqld]
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-innodb
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer = 8M
sort_buffer_size = 8M
[myisamchk]
key_buffer = 8M
sort_buffer_size = 8M
[mysqlhotcopy]
interactive-timeout
上面的这个数据库的优化 我没有尝试,我使用了上面第一个真接加入3行代码的方法