homepage Welcome to WebmasterWorld Guest from 54.204.128.190
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Hardware and OS Related Technologies / Linux, Unix, and *nix like Operating Systems
Forum Library, Charter, Moderators: bakedjake

Linux, Unix, and *nix like Operating Systems Forum

    
MySQL service stops suddenly
MySQL process stops sometimes without error
AdrianMG




msg:3887003
 8:54 am on Apr 7, 2009 (gmt 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?

 

eeek




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

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




msg:3932872
 3:39 am on Jun 14, 2009 (gmt 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.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Hardware and OS Related Technologies / Linux, Unix, and *nix like Operating Systems
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved