PDA

View Full Version : My server is crashing!!!! Help

Gez
07-09-2003, 12:50 PM
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
07-09-2003, 12:55 PM
It's a problem with your host that usually happens when MySQL is going or has gone down.
Gez
07-09-2003, 01:12 PM
How can i fix Mysql???
filburt1
07-09-2003, 01:36 PM
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
07-10-2003, 05:32 AM
The server is my own
Gavin B.
07-10-2003, 06:09 AM
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
07-14-2003, 09:30 AM
mysql is dying on my forum server, what tweaks can i do to mysql to fix it??
Erwin
07-14-2003, 09:34 AM
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
07-14-2003, 11:56 AM
Thankyou Erwin
Gez
07-16-2003, 12:00 PM
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)
Gez
07-16-2003, 12:46 PM
The problem is with MYSQL running out of sockets to connect to , how do i increase the sockets?? Im sure this would cure my problem??