MySQL shutting down -- don't know why

Support/Development for MySQL, MariaDB, and other database systems
Mia Esqel
Forum User
Forum User
Posts: 8
Joined: Mon Mar 05, 2012 11:36 am
Location: USA

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

Unread post 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
paulie
Forum User
Forum User
Posts: 76
Joined: Tue Apr 20, 2010 2:49 am

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

Unread post 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.
Post Reply