Page 2 of 2

Re: MySQL shutting down -- don't know why

Posted: Mon Mar 12, 2012 8:57 pm
by Mia Esqel
scott wrote:I dont think the i386 packages matter here. This isnt a packaging problem at all. The daemon is dying because someone/thing is shutting it down, theres a deeper problem with the system (bad drives, memory, etc), or maybe even a bad my.cnf (overtuned).
[mysqld]

default-storage-engine=MYISAM

general_log=0
general_log_file=/var/log/mysqld-queries.log

slow_query_log=1
slow_query_log_file=/var/log/mysqld-slow.log

character-set-server=utf8
collation-server=utf8_unicode_ci
local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

log_warnings=2


[mysqld_safe]

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Re: MySQL shutting down -- don't know why

Posted: Thu Mar 15, 2012 3:39 am
by paulie
I'm not going to let a little thing like no or contradicting evidence sway me from my pet theory! Whats the output of :

ps aux | grep monit

That'll tell us if watchdog is being run from a different location, though thats only likely to occur if you're not using a RHEL or derivative?

--
If you switch general_log to 1 then it should log all queries, which will prove/disprove whether its a shutdown from inside of MySQL, and if it disproves it it'll show you wish queries are being run immediately prior to shutdown, which may be an indicator to the problem...

Paul.