mysql
最近网站从discuz 2.0升级到3.1后,网站大约每隔12小时左右,会变慢,变得非常慢,然后mysql报错,1040 notconnection
问题是,后台的日志里没有留下错误信息,而且,大约10分钟内,它会自动重启。
下面是日志:
140411 20:50:09 [warning] statement may not be safe to log in statement format. statement: update pre_common_plugin_luckypostlog set badtimes = badtimes+1 where uid = '43010' limit 1
140411 20:51:29 [warning] statement may not be safe to log in statement format. statement: update pre_common_plugin_luckypostlog set badtimes = badtimes+1 where uid = '43010' limit 1
140411 20:52:02 [warning] statement may not be safe to log in statement format. statement: update pre_common_plugin_luckypostlog set badtimes = badtimes+1 where uid = '43010' limit 1
140411 20:58:06 [warning] statement may not be safe to log in statement format. statement: update pre_common_plugin_luckypostlog set goodtimes = goodtimes+1 where uid = '21013' limit 1
140411 21:00:29 [warning] statement may not be safe to log in statement format. statement: update pre_common_plugin_luckypostlog set badtimes = badtimes+1 where uid = '43953' limit 1
140411 21:02:05 [warning] statement may not be safe to log in statement format. statement: update pre_common_plugin_luckypostlog set goodtimes = goodtimes+1 where uid = '43953' limit 1
140411 21:02:30 [warning] statement may not be safe to log in statement format. statement: update pre_common_plugin_luckypostlog set goodtimes = goodtimes+1 where uid = '43953' limit 1
140411 21:04:49 [warning] statement may not be safe to log in statement format. statement: update pre_common_plugin_luckypostlog set badtimes = badtimes+1 where uid = '43953' limit 1
140411 21:16:12 [warning] statement may not be safe to log in statement format. statement: update pre_common_plugin_luckypostlog set goodtimes = goodtimes+1 where uid = '26253' limit 1
140411 21:36:42 [note] /usr/local/mysql/libexec/mysqld: normal shutdown
140411 21:36:42 [note] event scheduler: purging the queue. 0 events
140411 21:36:42 [note] /usr/local/mysql/libexec/mysqld: shutdown complete
140411 21:36:42 mysqld_safe mysqld from pid file /usr/local/mysql/var/k130811kd.pid ended
140411 21:36:44 mysqld_safe starting mysqld daemon with databases from /usr/local/mysql/var
140411 21:36:44 [warning] '--skip-locking' is deprecated and will be removed in a future release. please use '--skip-external-locking' instead.
140411 21:36:44 [note] event scheduler: loaded 0 events
140411 21:36:44 [note] /usr/local/mysql/libexec/mysqld: ready for connections.
version: '5.1.60-log' socket: '/tmp/mysql.sock' port: 3306 source distribution
请问如何处理是好。。。