Results 1 to 7 of 7
Thread: MySQL server has gone away
-
05-03-2012, 04:32 AM #1Junior Guru
- Join Date
- Jul 2004
- Posts
- 204
MySQL server has gone away
I am having my LAN Webserver, where I am using some PHP/Mysql based script.
Every day morning when I start my script I am greeting the following error notification:
arning: mysql_pconnect() [<a href='function.mysql-pconnect'>function.mysql-pconnect</a>]: MySQL server has gone away in E:\Server\vt\adodb\drivers\adodb-mysql.inc.php on line 373
I assume we need to set some parameters lime time out etc., Please help me.
-
05-03-2012, 05:33 AM #2Junior Guru
- Join Date
- Dec 2005
- Posts
- 207
Have you checked the current MySQL status at the time of this error? You may have an issue causing it to restart itself frequently and depending on the number of databases etc it may take a few minutes to do so.
-
05-03-2012, 07:15 AM #3Disabled
- Join Date
- Apr 2012
- Posts
- 140
check mysql logs for this and try to increase timeout.
-
05-03-2012, 07:49 AM #4Junior Guru
- Join Date
- Jul 2004
- Posts
- 204
-
05-03-2012, 08:14 AM #5Web Hosting Evangelist
- Join Date
- Jul 2005
- Posts
- 489
Adjust the wait_timeout variable in /etc/my.cnf and restart mysql.
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html is a good read
-
05-04-2012, 05:19 AM #6Disabled
- Join Date
- Nov 2010
- Posts
- 2,564
-
05-04-2012, 05:32 AM #7Junior Guru
- Join Date
- Jul 2004
- Posts
- 204
I will check it tomorrow, since I am out these days.
Please note that my server is not Linux, I am using a WAMP environment.
Similar Threads
-
Cloud mysql, round robin mysql, or just a big sql server?
By eyepaste in forum Hosting Security and TechnologyReplies: 2Last Post: 06-29-2010, 05:08 PM -
Can't connect to local MySQL server through socket '/var/tmp/mysql.sock' (11)
By motyl in forum Hosting Security and TechnologyReplies: 29Last Post: 03-09-2007, 12:26 PM -
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
By manisha_khtri in forum Hosting Security and TechnologyReplies: 2Last Post: 06-05-2006, 10:05 AM -
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
By stickygoblin in forum Hosting Security and TechnologyReplies: 13Last Post: 06-18-2004, 11:10 AM -
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.
By atul in forum Hosting Security and TechnologyReplies: 5Last Post: 05-11-2004, 12:24 AM