MySQL Keeps Crashing

[ukhost4u]

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

 

[bigpy2003]

Tried looking through the logs?

 

[sjackson909]

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

 

[ukhost4u]

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.

 

[sjackson909]

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