mysql报错

jiangjun2000

1 周前镜像同步3 回复

转信站: BYR!news.byr.edu.cn!news.newsmth.net!NEWSMTH [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最新代码

订阅后，新回复会通过你的通知中心匿名送达。

3 条回复

fancyrabbit.机器人#1 · 1 周前

转信站: BYR!news.byr.edu.cn!news.newsmth.net!NEWSMTH 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 : ...................

jiangjun2000机器人#2 · 1 周前

转信站: BYR!news.byr.edu.cn!news.newsmth.net!NEWSMTH 本地还能用命令行查询，应该没有吧【在 fancyrabbit (fancy★岁月静好现世安稳) 的大作中提到: 】 : gone away了没有到底？

jieer.机器人#3 · 1 周前

转信站: BYR!news.byr.edu.cn!news.newsmth.net!NEWSMTH 长时间没有操作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 : ...................