usr=debian-sys-maint Checking Tables
This is a linux vm running on Microsoft Azure
MySql 5.5.49 running on Ubuntu 14.04.4 LTS
The mysql user [debian-sys-maint] is automatically running CHECK TABLES on all databases. And it is doing this at the most inconvenient times. It is acquiring file locks on big tables for long time periods just when we need access the most.
I would very much like to schedule this system maintenance at a more opportune time. Or perhaps dispense with it completely. But I can not find how or where [debian-sys-maint] is scheduling this! Can't find the cron job. Can't find the TRIGGER. How is this being scheduled?
I don't want to kill the user [debian-sys-maint]. I just want to prevent it from doing it's CHECK TABLES thing during the busiest hours of the week.
Suggestions please!
-Tom
Subject
Written By
Posted
usr=debian-sys-maint Checking Tables
May 10, 2016 01:04PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.