usr=debian-sys-maint Checking Tables
Posted by: Thomas Bartkus
Date: May 10, 2016 01:04PM

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!


Options: ReplyQuote

Written By
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.