Welcome to WebmasterWorld Guest from 50.17.117.221

Forum Moderators: bakedjake

Message Too Old, No Replies

MySQL service stops suddenly

MySQL process stops sometimes without error

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

New User

5+ Year Member

joined:Mar 6, 2009
posts: 4
votes: 0


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)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Nov 20, 2004
posts:875
votes: 2


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 June 14, 2009 (gmt 0)

Junior Member

10+ Year Member

joined:Feb 17, 2004
posts:174
votes: 0


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.
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members