Need assistance in repair of corrupted Inndob table

Question

Our Magento website has been having problems lately and every now and then we receive on our webpage an error:

SQLSTATE[HY000]: General error: 1712 Index [table] is corrupted

As i understand, innodb does not support repair via phpmyadmin. We are able to shutoff website and database for a few hours in order to repair but do not understand repair well enough after reading online.

Would appreciate any help on repair of innodb tables.

score -2 · Answer 1 · answered May 24 '16 at 21:37

-2

What version of MySQL?

1712 is very rare. See if Bug 72858 is relevant.

Here is a way to rebuild (not "repair") the index(es):

ALTER TABLE your_table ENGINE=InnoDB;

If that does not help, please provide any output from the ALTER, including execution time.

answered May 24 '16 at 21:37

Rick James

106,233
9
103
171

MySQL version: 5.6.29 – OREO May 26 '16 at 10:26
Doesn't the linked bugreport just indicate that MySQL server query optimizer should avoid using the index in case of corruption? How can this be relevant? – helvete Dec 16 '16 at 13:58
I was not sure whether it was relevant; that is the only one I could find. – Rick James Dec 19 '16 at 16:31

Need assistance in repair of corrupted Inndob table

1 Answers1