[TriLUG] MySQL strangeness

[Mauricio Tavares via TriLUG]

On Wed, Sep 2, 2015 at 6:43 AM, Brian McCullough via TriLUG
<trilug at trilug.org> wrote:
> 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
>
      Maybe check the sort_buffer_size? Don't know if it is still
should be set to 256K, but whatever it is, it is per thread.

>
> --
> This message was sent to: raubvogel at gmail.com <raubvogel at gmail.com>
> To unsubscribe, send a blank message to trilug-leave at trilug.org from that address.
> TriLUG mailing list : http://www.trilug.org/mailman/listinfo/trilug
> Unsubscribe or edit options on the web  : http://www.trilug.org/mailman/options/trilug/raubvogel%40gmail.com
> Welcome to TriLUG: http://trilug.org/welcome