|
环境:
系统:CentOS release 4.6
内核:Version 2.6.9-67.0.20.ELsmp
MySql版本:5.0.58
Apache 版本:2.0.52
PERL版本:5.8.5
PHP版本:5.2.6
使用dedecms,在更新分类页面时,mysql的cpu占用达到95以上,有时甚至超过120%
[root@server ~]# vi /var/log/mysqld.log //日志中有warning
080723 10:01:27 mysqld started
080723 10:01:27 [Warning] option 'max_join_size': unsigned value 184467440737095
51615 adjusted to 4294967295
080723 10:01:27 [Warning] option 'max_join_size': unsigned value 184467440737095
51615 adjusted to 4294967295
080723 10:01:27 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.58' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distr
ibution
请问这个问题怎么解决呢?在线等待解决方法。谢谢! |
|