Results 1 to 7 of 7

Thread: MySQL Problem.

  1. #1
    Join Date
    May 2004
    Location
    India
    Posts
    91

    MySQL Problem.

    Hi all,
    In my dedicated server ( cPanel ) , after each 1 hours MySQL stop working, and web pages connection to sql giving the errors like :

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

    And in top, MySQL process on the top after every 1/2 hour. My current my.cnf file is attached with this msg. Please advice me what I should do to fix it up.
    Attached Files Attached Files

  2. #2
    Join Date
    Mar 2002
    Posts
    295
    Take a look at your server and see if you a symlink to mysql.sock in your /tmp directory. Is it there?

  3. #3
    Join Date
    May 2004
    Location
    India
    Posts
    91
    Yes it is there.

    [email protected] [/var/tmp]# ls
    ./ ../ mysql.sock@

    [email protected] [/var/tmp]# pwd
    /var/tmp

    Can you suggest some optimum setting for my.cnf ? I have 495 user on that server.

  4. #4
    I used to get that error quite a bite, tryd a few things with no luck, so I figured it was time for me to update to the new apache / php / mysql versions, so I reinstalld apache and the errors did go away...

    I tryd looking around for other solutions, but found only one which I found not to be the reason.

  5. #5
    Join Date
    May 2004
    Location
    India
    Posts
    91
    But MySQL , Apache and PHP is up to date ?? What else I can do to fix it ?

  6. #6
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,202
    Update apache , mysql , php and recompile apache - easyapache .

    I may have got some wording wrong :\
    DigitalGoods.info
    FREE Shared, Mega Resellers + Dedicated Servers

  7. #7
    Join Date
    Mar 2003
    Location
    California USA
    Posts
    13,294
    change the lines saying:

    socket = /var/lib/mysql/mysql.sock

    to

    socket = /var/tmp/mysql.sock
    Steven Ciaburri | Industry's Best Server Management - Rack911.com
    Software Auditing - 400+ Vulnerabilities Found - Quote @ https://www.RACK911Labs.com
    Fully Managed Dedicated Servers (Las Vegas, New York City, & Amsterdam) (AS62710)
    FreeBSD & Linux Server Management, Security Auditing, Server Optimization, PCI Compliance

Posting Permissions

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