MySQL Shuts down for 10 for some reason

[EchoHost]

I dont know why it does it sometimes.. maybe once a week or once a month but it just does do it. Is there a MySQL error log i can find?

 

[EchoHost]

anyone?

thanks

 

[Devil Inside]

pico -w /var/log/mysqld.log

 

[chirpy]

The MySQL error log is normally in /var/lib/mysql/hostname.err and daemon errors usually show in /var/log/messages

 

[slmsoft]

there's no information in /var/lib/mysql/hostname.err, do you I have to enable logging ?

 

[Blue|Fusion]

The MySQL error log is normally in /var/lib/mysql/hostname.err and daemon errors usually show in /var/log/messages

I do believe daemon errors are logged in /var/log/mysqld.log, atleast on all the systems I've worked with have.

 

[PanelGuy]

MySQL Error Log

I didn't find any of those in any of those places. Besides the messages log of course.

 

[Freezer]

I had a similar problem, and what was causing it was the process manager who killed the process if it consumed more then 128mb memory.

 

[chirpy]

I do believe daemon errors are logged in /var/log/mysqld.log, atleast on all the systems I've worked with have.

Maybe it's a version thing. All the servers I've worked on that I recall may have been v4 and they all definitely log to /var/lib/mysql/whateveryourhostnameis.err by default unless otherwise configured in /etc/my.cnf