[TriLUG] MySQL strangeness

[Brian McCullough via TriLUG]

I am looking for somebody who is a decent MySQL DBA.

I just "play a DBA on TV," and have run into an issue which I don't know
how to solve.


My user complains that his database keeps shutting down and rebooting
every 10-12 hours, for no apparent reason.  There doesn't seem to be
anything useful in the log except the entries that show this happening,
which I will quote below.  There is plenty of disk space, there is about
1% use on that drive, and the database takes up about 550 Meg. ( InnoDB
in Centos 6.5 )

The log:

150901 21:24:13 [Note] Event Scheduler: Loaded 0 events
150901 21:24:13 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306
Source distribution
150902  5:50:54 [Note] /usr/libexec/mysqld: Normal shutdown

150902  5:50:54 [Note] Event Scheduler: Purging the queue. 0 events
150902  5:50:54 [ERROR] /usr/libexec/mysqld: Sort aborted
150902  5:50:54 [ERROR] /usr/libexec/mysqld: Sort aborted
150902  5:50:54 [ERROR] /usr/libexec/mysqld: Sort aborted
150902  5:50:54 [ERROR] /usr/libexec/mysqld: Sort aborted
.
.
.
many more of these
.
.
.
150902  5:50:54 [ERROR] /usr/libexec/mysqld: Sort aborted
150902  5:50:55 [ERROR] /usr/libexec/mysqld: Sort aborted
150902  5:50:55 [ERROR] /usr/libexec/mysqld: Sort aborted
150902  5:50:55 [ERROR] /usr/libexec/mysqld: Sort aborted
150902  5:50:55 [ERROR] /usr/libexec/mysqld: Sort aborted
150902  5:50:57  InnoDB: Starting shutdown...
150902  5:51:00  InnoDB: Shutdown completed; log sequence number 0
4172635755
150902  5:51:00 [Note] /usr/libexec/mysqld: Shutdown complete

150902 05:51:01 mysqld_safe mysqld from pid file
/mnt/cbsvolume1/mysql/mysqld.pid ended
150902 05:51:02 mysqld_safe Starting mysqld daemon with databases from
/mnt/cbsvolume1/mysql
150902  5:51:02  InnoDB: Initializing buffer pool, size = 8.0M
150902  5:51:02  InnoDB: Completed initialization of buffer pool
150902  5:51:02  InnoDB: Started; log sequence number 0 4172635755
150902  5:51:02 [Note] Event Scheduler: Loaded 0 events
150902  5:51:02 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306
Source distribution




Suggestions?



Thanks,
Brian