Results 1 to 8 of 8
  1. #1

    Arrow MySQL has gone away

    In my PHPBB forum or any other script which use MYSQL in that sometimes i encountereted an error "MYSQL has gone away" on refreshing this problem is gone... please tell me what can be solution of this, i noticed this problem more when i am on slow internet connection and page taking time to load due to slow internet connection.

  2. #2
    Try increasing wait_timeout value in my.cnf by 60 second increments until it goes away. Your must restart mysql after you modify my.cnf for the setting to take affect. If it is not there then add it.
    Instant vps setup
    Cpanel/WHM Direct Admin

  3. #3
    Thanks, btw what can be the optimized value. Currently wait_timeout set to 10.

    Any other value also need to be increased...?

  4. #4
    I would increase it at 60 for starters and go from there. after 60 try 120,240 and so on.
    Instant vps setup
    Cpanel/WHM Direct Admin

  5. #5
    you mean... if high traffic then increase the value accordingly..?

  6. #6
    No. It doesnt need to be that high. Probably around 120 maybe 140 is as high as you need to go. It is a set it and leave it setting.
    Instant vps setup
    Cpanel/WHM Direct Admin

  7. #7
    Join Date
    Jul 2009
    You get these errors if you send a query to the server that is incorrect or too large. If mysqld receives a packet that is too large or out of order, it assumes that something has gone wrong with the client and closes the connection.

    Try to increase the max_allowed_packet to 8MB. The entry should be as following in my.cnf:

    ServerManagementAdmins -- Expert in Server Management, Server Hardening & Server Optimization.
    Server Management Company
    IM (skype): servermanagementadmins Email: sales[at]servermanagementadmins[dot]com

  8. #8
    the value id already high in my settings..


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