Welcome to WebmasterWorld Guest from 54.144.231.243

Forum Moderators: bakedjake

MySQL service stops suddenly

MySQL process stops sometimes without error

   
8:54 am on Apr 7, 2009 (gmt 0)

5+ Year Member



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?

3:03 am on Apr 11, 2009 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



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.

3:39 am on Jun 14, 2009 (gmt 0)

10+ Year Member



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.
 

Featured Threads

My Threads

Hot Threads This Week

Hot Threads This Month