Results 1 to 9 of 9
  1. #1
    Join Date
    Mar 2004

    MySQL Connection Error


    I have one site in this server: P4 / 1G Ram / Linux / Apache / MySQL4 / PHP4

    and the site is working fine, but sometimes (about 5%) the following error appear:

    Can't connect to local MySQL server through socket '/var/tmp/mysql.sock' (2)

    Any help please...

  2. #2
    What CPU loads do you see usually?

    Is this always at the same time? Maybe you have some background scripts running at certain times (e.g. backup) consuming much CPU cycles?

  3. #3
    Join Date
    Mar 2004
    Thanks Mr. Walter for you replay,,

    The CPU loads is normal and it is always idel 95%-100%
    and the backup happen once a day..
    So, no thing is consuming the CPU.

    And, still I'm facing this problem,, Need your help please..

  4. #4
    Join Date
    Jan 2002
    Home, chair
    Seems like your MySQL server hangs up. Can you paste here the contents of /etc/my.cnf file?

  5. #5
    When this happen see how many mysql connections you have.
    Datums Internet Solutions, LLC
    Systems Engineering & Managed Hosting Services
    Complex Hosting Consultants

  6. #6
    Join Date
    Mar 2004
    I'm always receiving 4 error messages when that error happen, they are:

    syslogd failed @ Mon Mar 15 19:58:00 2004. A restart was attempted automagicly.

    mysql failed @ Mon Mar 15 19:57:39 2004. A restart was attempted automagicly.

    eximstats failed @ Mon Mar 15 19:57:38 2004. A restart was attempted automagicly.

    bind failed @ Mon Mar 15 19:57:22 2004. A restart was attempted automagicly.

    the file /etc/my.cnf contain:
    set-variable = max_connections=500

    And I think it is not too many connection error.

    I need your help please........

  7. #7


    I've had this exact same problem. Try removing max_connections in my.cnf. Also lower the wait_timeout and see what happens. Let me know how that works for you.

  8. #8
    Join Date
    Mar 2003
    California USA
    what distro of linux?
    Steven Ciaburri | Proactive Linux Server Management -
    Managed Servers (AS62710), Server Management, and Security Auditing.

  9. #9
    Join Date
    Apr 2004
    Atlanta, GA
    did this fix work? i to am experiencing a similar problem

Posting Permissions

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