List:Bugs« Previous MessageNext Message »
From:Emre Hasegeli Date:September 30 2011 2:29pm
Subject:Crash After Setting "wait_timeout" Parameter
View as plain text  
Our master database server crashed first time after two years. We are 
using Debian GNU/Linux 6.0 with Linux 2.6.32-5-amd64. We have updated 
the MySQL server to 5.5.11 two months ago from MySQL binaries. All of 
the tables use InnoDB storage engine. The server responds in average 2k 
query per second.

"wait_timeout" parameter had set to 120 from 300 on the morning of the 
day the crash happened. The server crashed at the evening and restart 
itself successfully. We could not find anything significant about the 
crash. There were nothing unusual, no load, not many connections, not 
any log query. Is there any chance that the "wait_timeout" parameter 
caused the crash?

The error log of the server for the crash is attached.

Emre Hasegeli
Veri Tabanı Yöneticisi
Tart İnternet Teknolojileri AŞ

Attachment: [text/html]
Attachment: [text/html]
Attachment: [text/x-log] error.log
Crash After Setting "wait_timeout" ParameterEmre Hasegeli3 Oct