Weird error this evening on one of my MySQL databases, reading a simple application consisting of a Select, I received the following error message: ERROR 1194 (HY000). A little over 3 million registered in the table, I raise a few seconds later another query with a limit 5 and apparently this time she returns a correct result. ago in this particular application an order by id desc specifying one, I get the correct results but specifying an ASC, error message again.

I find that certain record in the table are damaged. Fortunately this is a temporary table and I can drop it at will but this is not so reassuring to its neighbors.

Table xxx is marked as crashed and should be repaired.

After a repair with MySQL, the table is like new!

The REPAIR TABLE command [your table name] will therefore necessary.