MySQL service stops suddenly

MySQL process stops sometimes without error

[AdrianMG]

Hi guys! I am running a VPS based on Debian Etch 4.0 with Apache 2 and MySQL 5.

All is working fine but sometimes the MySQL stops suddenly without error. I have read that if the MySQL has a high load doesn't stop the service so I am not sure what's going on...

I have tried "/bin/dmesg" but outputs nothing so I don't know what can I read or try to fix it :(

Can you help me please?

[eeek]

It could be segfaulting. Try attaching gdb to the daemon and see what happens when it dies.

/bin/dmesg

That's only for kernel messages. Mysql is just an application.

[nalin]

mysqld will usually have an error log file:

tail /var/log/mysql/mysqld.err

If this does not work your error log is somewhere else try

cat /etc/mysql/my.cnf ¦ grep "log-error"

to get the location of your error log.