I'm having problems with a large MySQL InnoDB table and I was wondering if anyone here had advice for improving stabililty.
The issue that I'm having is that
CHECK TABLE ... FAST will lock the table, preventing any reading, and for a table this large, that means its offline for an hour.
The default Debian install will run
CHECK TABLE on everything whenever MySQL starts, and this is causing downtime. For now, I have disabled this functionality, but it makes me a little nervous to me mucking with these kind of system settings.
I have another cronjob that was bulk loading data into the table that was using
ALTER TABLE ... DISABLE KEYS and
ALTER TABLE ... ENABLE KEYS, and it's possible that this is related, but I haven't been able to confirm that yet.
Has anyone seen situations where
CHECK TABLE prevents access to large InnoDB tables?