Results 1 to 7 of 7
  1. #1
    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
    After few minutes working in the system, the error disappears.

    I assume we need to set some parameters lime time out etc., Please help me.

  2. #2
    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.

  3. #3
    check mysql logs for this and try to increase timeout.

  4. #4
    Join Date
    Jul 2004
    Posts
    204
    Quote Originally Posted by gettyhosting View Post
    check mysql logs for this and try to increase timeout.
    Please tell me how / in which file to adjust the timeout?

  5. #5
    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

  6. #6
    Quote Originally Posted by LnxtecH View Post
    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
    Good article! Hope the OP got problem fixed already.

  7. #7
    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

  1. Cloud mysql, round robin mysql, or just a big sql server?
    By eyepaste in forum Hosting Security and Technology
    Replies: 2
    Last Post: 06-29-2010, 05:08 PM
  2. Can't connect to local MySQL server through socket '/var/tmp/mysql.sock' (11)
    By motyl in forum Hosting Security and Technology
    Replies: 29
    Last Post: 03-09-2007, 12:26 PM
  3. Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    By manisha_khtri in forum Hosting Security and Technology
    Replies: 2
    Last Post: 06-05-2006, 10:05 AM
  4. Can't connect to local MySQL server through socket '/tmp/mysql.sock'
    By stickygoblin in forum Hosting Security and Technology
    Replies: 13
    Last Post: 06-18-2004, 11:10 AM
  5. Replies: 5
    Last Post: 05-11-2004, 12:24 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •