- 论坛徽章:
- 0
|
服务器用的是centos 5,负载了个几个网站和一个DISCUZ!论坛,基本每天PV15W,IP 2W左右.
经常性出现 MYSQL too many connections ,出现问题前论坛打开页面异常缓慢,然后就出现too many connections,过1分钟左右会立即自动恢复,恢复后论坛刷新速度明显超快.
原因不明.
具体如图,顺便发上我MY.CNF设置
图片是SSH终端连上去的top图
- [mysqld]
- datadir=/var/lib/mysql
- socket=/var/lib/mysql/mysql.sock
- user=mysql
- # Default to using old password format for compatibility with mysql 3.x
- # clients (those using the mysqlclient10 compatibility package).
- old_passwords=1
- [mysqld_safe]
- err-log=/var/log/mysqld.log
- pid-file=/var/run/mysqld/mysqld.pid
复制代码
[ 本帖最后由 hackroad 于 2008-11-30 23:09 编辑 ] |
|