PDA

View Full Version : MySQL server has gone away


Dabbler
Wed 20th Dec '06, 4:08pm
Getting this frequently now:

MySQL Error : MySQL server has gone away
Error Number : 2006

Setup Basics:
vB: 3.6.0
PHP: 5.2.0 (from php.net)
MySQL: 5.0.26 nt-community

OS: WinServer 2003
Web: IIS 6.0 (isapi)
W3WP: 4 processes

CPU: dual 3.2 GHz Intel Xeons
RAM: 4GB
HD: 73G SCSIx2 (RAID 1)

Posts: ~2.1 million
Threads: ~110K

Data Usage 2.46 GB
Index Usage 929.31 MB

Steve Machol
Wed 20th Dec '06, 4:16pm
This is a server issue. You'll need to contact your host about this. Here are the reasons for the MySQL server going away:

http://www.vbulletin.com/forum/showthread.php?s=&postid=310265#post310265

Also from the MySQL site:

http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

eva2000
Fri 22nd Dec '06, 5:48am
what does my.cnf look like ? try raising wait_timeout value in 30 to 60 second increments from the existing value and restart mysql each time you make my.cnf changes...

Dabbler
Fri 22nd Dec '06, 4:17pm
what does my.cnf look like ? try raising wait_timeout value in 30 to 60 second increments from the existing value and restart mysql each time you make my.cnf changes...See:
http://www.vbulletin.com/forum/showthread.php?t=213284

I noticed that you have been recommending wait_timeout set to 10 seconds.
I'll bump it, but why so small initially? Why not just set it to 90 and forget it?

(obviously I'm no MySQL admin. :D)