My server is crashing!!!! Help

[Gez]

I keep getting this error when the forum starts to get busy...

Database error in vBulletin 2.3.0:

Invalid SQL: UPDATE session SET lastactivity=1057757687,location='/index.php?' WHERE sessionhash='77d3d772fedc2ac18f7bb7cad60918ad'
mysql error: MySQL server has gone away

mysql error number: 2006

How can i fix this problem??

[filburt1]

It's a problem with your host that usually happens when MySQL is going or has gone down.

[Gez]

How can i fix Mysql???

[filburt1]

Is it your server or shared? If it's the latter then ask your host to fix it.

Otherwise, please search and you should find a sufficient answer.

[Gez]

The server is my own

[Gavin B.]

Just restart mysql, you may have to reboot the server if that doesn't fix it. Nothing to worry about too much though, nothing is "broken" as such (I don't imagine).

edit: It only happens when you get a heavy load? Check out vbulletin.com for some huge guides on fine tuning your server to run at its best. How many sites are on the server? and is it relativly new?

[Gez]

mysql is dying on my forum server, what tweaks can i do to mysql to fix it??

[Erwin]

Edit your my.conf and httpd.conf files to tweak your server for mysql and php optimization. Head over to vB.com's Server Configuration forum for more advice - search around there for some tips.

[Gez]

Thankyou Erwin

[Gez]

Got a new error

Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /usr/local/www/data-dist/www.dtmproductions.net/pnadodb/drivers/adodb-mysql.inc.php on line 170

Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /usr/local/www/data-dist/www.dtmproductions.net/pnadodb/drivers/adodb-mysql.inc.php on line 170
mysql://root:@localhost/dtmpro failed to connectCan't connect to local MySQL server through socket '/tmp/mysql.sock' (2)