Results 1 to 10 of 10

Thread: MYSQL gone away

  1. #1

    Arrow MYSQL gone away

    When I process the bounces in phplist newsletter script, then i got the error "Database error 2006 while doing query MySQL server has gone away" , please tell me which setting in my.cnf need to increase to fix the problem?

  2. #2
    have you process it successfully before?

  3. #3
    sometimes get processed successfully and sometimes got the error

  4. #4
    there mentioned keep wait_timeout=60,

    but as a good practice keep wait_timeout keep low as low as possible, so connections dont get jammed.

  5. #5

    The Fix for the issue is by increasing the value of max_allowed_packet=100M or more .


  6. #6
    Join Date
    Apr 2009
    Perhaps your client and the server had dropped the connection becouse MySQLdirective "wait_timeout" expired

    Read more in:
    █▌KVM-based SSD VPS
    ▌Unmetered Dedicated Servers
    ▌Colocation at 100 Delawanna Ave, Clifton, NJ

  7. #7
    Join Date
    Mar 2011
    I've seen this issue when apache is over loaded and I kill mysql connections that apache is holding on to for too long. Then when apache wants to release them, I see those types of errors.

  8. #8
    Join Date
    Apr 2007
    Brussels, Belgium
    Which version of mysql are you using ?

  9. #9
    version 5.2

  10. #10
    Join Date
    Apr 2011
    Bhaktapur, Nepal
    It usually occurs when there is large gap between two mysql request...

Similar Threads

  1. Need Help, I moved Mysql from /var to /backup/mysql, mysql is no longer working
    By pcnet21 in forum Hosting Security and Technology
    Replies: 4
    Last Post: 05-09-2009, 01:58 AM
  2. Installed MySQL in /usr/local/mysql but error in /var/lib/mysql
    By guest3 in forum Hosting Security and Technology
    Replies: 1
    Last Post: 01-21-2007, 06:38 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. Replies: 5
    Last Post: 05-11-2004, 12:24 AM
  5. Problem with /var/lib/mysql/mysql.sock after MySQL upgrade
    By oldford in forum Dedicated Server
    Replies: 9
    Last Post: 07-30-2003, 11:35 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