- 主题:mysql报错
[2009-12-18 19:39:52 20282 3.system] (unknown user) mysql bmlog error:MySQL server has gone away
[2009-12-18 19:47:12 20282 3.system] (unknown user) mysql postlog error:MySQL server has gone away
[2009-12-18 19:47:12 20282 3.system] (unknown user) mysql bmlog error:MySQL server has gone away
[2009-12-18 19:49:29 20282 3.system] (unknown user) mysql bmlog error:MySQL server has gone away
[2009-12-18 19:49:29 20282 3.system] (unknown user) mysql bmlog error:MySQL server has gone away
[2009-12-18 19:49:36 20282 3.system] (unknown user) mysql postlog error:MySQL server has gone away
[2009-12-18 19:49:36 20282 3.system] (unknown user) mysql bmlog error:MySQL server has gone away
[2009-12-18 19:51:28 20282 3.system] (unknown user) mysql postlog error:MySQL server has gone away
[2009-12-18 19:51:28 20282 3.system] (unknown user) mysql bmlog error:MySQL server has gone away
[2009-12-18 19:52:11 20282 3.system] (unknown user) mysql postlog error:MySQL server has gone away
[2009-12-18 19:52:11 20282 3.system] (unknown user) mysql bmlog error:MySQL server has gone away
[2009-12-18 19:52:11 20282 3.system] (unknown user) mysql log closed
请问这可能是什么原因？
不止一次出现这个错误
系统是fc6，msyql版本是mysql-server-5.0.27-1.fc6
kbs最新代码
--
FROM 123.113.36.*
gone away了没有到底？
【 在 jiangjun2000 (%d) 的大作中提到: 】
: [2009-12-18 19:39:52 20282 3.system] (unknown user) mysql bmlog error:MySQL server has gone away
: [2009-12-18 19:47:12 20282 3.system] (unknown user) mysql postlog error:MySQL server has gone away
: [2009-12-18 19:47:12 20282 3.system] (unknown user) mysql bmlog error:MySQL server has gone away
: ...................
--
FROM 123.116.112.*
本地还能用命令行查询，应该没有吧
【 在 fancyrabbit (fancy★岁月静好现世安稳) 的大作中提到: 】
: gone away了没有到底？
--
FROM 123.113.36.*
长时间没有操作mysql
可以改mysql.cnf里边的wait_timeout，改的时间长一些
或者在每次mysql_query之前用mysql_ping检查链接是否可用
mysql_ping可以自动重连，mysql 5.0.13之后的版本有不同
需要一个MYSQL_RECONNECT的标示
可以参考这里
http://www.xiaojb.com/archives/it/mydns_mysql_gone_away.shtml
【 在 jiangjun2000 (%d) 的大作中提到: 】
: [2009-12-18 19:39:52 20282 3.system] (unknown user) mysql bmlog error:MySQL server has gone away
: [2009-12-18 19:47:12 20282 3.system] (unknown user) mysql postlog error:MySQL server has gone away
: [2009-12-18 19:47:12 20282 3.system] (unknown user) mysql bmlog error:MySQL server has gone away
: ...................
--
修改:jieer FROM 118.113.208.183
FROM 118.113.208.183