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 Shuts down for 10 for some reason

Discussion in 'General Discussion' started by EchoHost, Sep 28, 2005.

  1. EchoHost

    EchoHost Well-Known Member

    Joined:
    Jul 27, 2003
    Messages:
    52
    Likes Received:
    0
    Trophy Points:
    6
    I dont know why it does it sometimes.. maybe once a week or once a month but it just does do it. Is there a MySQL error log i can find?
     
  2. EchoHost

    EchoHost Well-Known Member

    Joined:
    Jul 27, 2003
    Messages:
    52
    Likes Received:
    0
    Trophy Points:
    6
    anyone?

    thanks
     
  3. Devil Inside

    Devil Inside Well-Known Member

    Joined:
    Apr 4, 2003
    Messages:
    277
    Likes Received:
    0
    Trophy Points:
    16
    pico -w /var/log/mysqld.log
     
  4. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,475
    Likes Received:
    20
    Trophy Points:
    38
    Location:
    Go on, have a guess
    The MySQL error log is normally in /var/lib/mysql/hostname.err and daemon errors usually show in /var/log/messages
     
  5. slmsoft

    slmsoft Member

    Joined:
    Aug 8, 2005
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    there's no information in /var/lib/mysql/hostname.err, do you I have to enable logging ?
     
  6. Blue|Fusion

    Blue|Fusion Well-Known Member

    Joined:
    Sep 12, 2004
    Messages:
    378
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Cleveland, Ohio
    I do believe daemon errors are logged in /var/log/mysqld.log, atleast on all the systems I've worked with have.
     
  7. PanelGuy

    PanelGuy Well-Known Member

    Joined:
    Oct 13, 2004
    Messages:
    106
    Likes Received:
    0
    Trophy Points:
    16
    MySQL Error Log

    I didn't find any of those in any of those places. Besides the messages log of course.
     
  8. Freezer

    Freezer Well-Known Member

    Joined:
    Jun 13, 2005
    Messages:
    120
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Den Haag
    I had a similar problem, and what was causing it was the process manager who killed the process if it consumed more then 128mb memory.
     
  9. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,475
    Likes Received:
    20
    Trophy Points:
    38
    Location:
    Go on, have a guess
    Maybe it's a version thing. All the servers I've worked on that I recall may have been v4 and they all definitely log to /var/lib/mysql/whateveryourhostnameis.err by default unless otherwise configured in /etc/my.cnf
     
Loading...

Share This Page