MySQL replication constantly checking tables 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?
If your database tables are MyISAM, you might have given the server option myisam-recover in your my.cnf, which will turn on automatic MyISAM checking.


  If recovery is enabled, each time mysqld opens a MyISAM table, it checks whether the table is marked as crashed or was not closed properly.