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 Keeps Crashing

Discussion in 'General Discussion' started by ukhost4u, Aug 2, 2004.

  1. ukhost4u

    ukhost4u Active Member
    PartnerNOC

    Joined:
    Apr 24, 2003
    Messages:
    42
    Likes Received:
    0
    Trophy Points:
    6
    Hello,

    Im having a problem with MySQL on my FreeBSD box. I have searched this whole forum but can't find a fix. Is anyone else having this issue and if so is there a fix.

    The problem we are seeing is that from time to time MySQL keeps crashing out. It does not effect any other service and does not show as down as connections can still be made on the port. The problem is that when we attempt to restart mySQL we can't. The only way to do it is kill the running process first.

    I also can't see why its crashing. We have plenty memory left, there is not too many open connections and its totally random.

    Im at a loss. Any help would be great.

    Paul Hughes
     
  2. bigpy2003

    bigpy2003 Well-Known Member

    Joined:
    Feb 22, 2004
    Messages:
    124
    Likes Received:
    0
    Trophy Points:
    16
    Tried looking through the logs?
     
  3. sjackson909

    sjackson909 Well-Known Member

    Joined:
    Jun 8, 2004
    Messages:
    113
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Columbus, OH
    Try checking your err files in /var/db/mysql/. Should be a file called yourhostname.err or just mysql.err. Check that log file out atfer mysql poos out.

    Thanks
    -Seth
     
  4. ukhost4u

    ukhost4u Active Member
    PartnerNOC

    Joined:
    Apr 24, 2003
    Messages:
    42
    Likes Received:
    0
    Trophy Points:
    6
    Im looking at this file but exaclty what am i looking for and how do I read it as there does not seem to be any dates on anything like a normal log.
     
  5. sjackson909

    sjackson909 Well-Known Member

    Joined:
    Jun 8, 2004
    Messages:
    113
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Columbus, OH
    if you tail it after mysql crashes, there may be some clues to why it crashed. When I have problems with mysql this is the first file I look at.

    Thanks
    -Seth
     
Loading...

Share This Page