11th Mar 2010
I keep getting this error ever since the upgrade
mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/globald5/public_html/forum/includes/class_core.php on line 311
MySQL Error :
Error Number :
Request Date : Friday, May 30th 2008 @ 10:07:06 AM
Error Date : Friday, May 30th 2008 @ 10:07:06 AM
Script : http://www.globaldesiz.com/forum/
Referrer :
IP Address : 216.80.120.105
Username :
Classname : vB_Database
MySQL Version :
Dear Customer,
Thanks for contacting us.
We apologize for the trouble you've been having,
The MySQL server has gone away message is usually caused by the MySQL connection being closed by the server, as opposed to the script. There are a couple of reasons why this might happen, but let me explain what is happening first. When a MySQL connection lies idle on the server for more than 60 seconds, our servers disconnect it. This is to prevent excess server load, and to release the connection socket back into the pool to prevent connection failures.
There are a couple of reasons that this might happen. The more common is that your script opened a MySQL connection, and then began doing other things, like uploading a file via FTP. Some of these actions can take a while, and so the script goes idle until it receives an awake call telling it that the action completed. While this is good for continuity with the script, the MySQL connection is closed causing problems. Basically, this is a problem with script design, and the developer of the script would need to resolve this.
The other common reason for this happening is Persistent MySQL Connections. This would be a setting in your script. Essentially what this is designed to do is speed up the connection of a MySQL database to a script by not allowing the connection to close. The problem with this is that, even according to MySQL, it does not significantly speed the connection process, and on our servers, the connection is closed long before it is needed the second time. The resolution of this issue would be to disable persistent connections for the MySQL database. Contact the script developer for assistance in doing this.
http://www.vbulletin.com/docs/html/cantconnect
Depending on the size of the database and the action taken, 60 seconds is not long enough to finish all queries. This should be at least 120 seconds. The default is 8 hours.
You can turn off Persistant Connections in your config.php file.
#If you have any other info about this subject , Please add it free.# |
Posted by webmaster under toyotataa.com |
