I recently moved one of our slave databases to a new server, the database is purely used for offsite replication/backup and doesn't handle any of the live traffic.
Since moving, the new server seems to constantly want to run
CHECK TABLE across the whole database. We've got a a few large tables, one being ~10GB, so it locks everything up for a few minutes while it's checking the table and in result queues up the queries.
I've looked at possible causes as to why it needs to check so often, but can't seem to find a reason.
I was wondering if anyone here has experienced this, or would know of a reason?