The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mysql error

Discussion in 'General Discussion' started by ajishcheeran, Feb 27, 2007.

  1. ajishcheeran

    ajishcheeran Member

    Joined:
    Dec 19, 2006
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    1
    When i am starting mysql the following error displaying

    ERROR! MySQL PID file could not be found!

    can u help me
     
  2. jayh38

    jayh38 Well-Known Member

    Joined:
    Mar 3, 2006
    Messages:
    1,215
    Likes Received:
    0
    Trophy Points:
    36
    I usually see this when a server uses up most or all of its sockets from a runaway process or bad script that doesn't close its threads. Install MyTop and also monitor top to view more closely at the resources mysql is using and the amount of threads and connections on your box.

    Look in your logs for further details of the error. If you find nothing then try some of these things. If you adjusted my.cnf then revert to your backup.

    Restart your apache

    killall -9 mysql

    ps xua | grep mysql | awk '{print $2}' | xargs kill
     
  3. ajishcheeran

    ajishcheeran Member

    Joined:
    Dec 19, 2006
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    1
    Hi,

    The following worked for me

    i checked the error log of myql

    /var/lib/mysql/hostname.err

    That file explained the following error Not writable /var/log/pid file

    i checked df -h
    /var was 100%

    removed

    from /var/log

    abcd.0
    abcd.1

    and
    echo > exim_mainlog


    Restart mysql


    It will work

    Thanks
    Ajish Cheeran
     
Loading...

Share This Page