Unfortunately MySQL can sometimes corrupt its own tables. This happens very rarely, usually under a very high load — when the database has to process a lot of data in big tables, lots of competing tracking requests are coming in simultaneously and there is not much free memory left on the server. Corrupted tables can't be used in the queries at all, thus tracking and reports preparation become unavailable.
We have created a special tool in Stuffed Tracker which will help you to constantly monitor the state of all the tables in the database and automatically repair the tables that got corrupted.
|