[TriLUG] MySQL strangeness

[Alan Porter via TriLUG]

Is there a periodic backup job that's shutting down the database before 
saving?
I've seen jobs in /etc/cron.d before that shut down databases, copy the 
underlying
data store files, and then restart the database.  (I prefer to run 
something like
mysqldump for that).

Alan




On 9/2/15 6:43 AM, Brian McCullough via TriLUG 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 )
>
> ...
>
>
> Suggestions?
>
>
>
> Thanks,
> Brian
>
>