MySQL Forums
Forum List  »  InnoDB

Innodb Table Recovery
Posted by: Dvaid zzzzz
Date: September 05, 2012 01:37PM

I was recently dropping an index from a very large (20GB) InnoDB and the MySQL instance crashed. When I restarted it, the instance wouldn't start and my server log had a message linking to the MySQL article about forcing InnoDB Recovery (http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html). I set innodb_force_recovery to 4, dumped my tables, and re-loaded them into the database.

However, I would like to avoid having this problem re-occur in the future. Was dropping the index the cause of the inndob crash? What else might have caused it? Is there any maintenance that I should be performing to minimize these innodb crashes?

Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
Innodb Table Recovery
1813
September 05, 2012 01:37PM
647
September 06, 2012 01:06AM
670
September 06, 2012 09:34AM
680
September 06, 2012 02:12AM
672
September 06, 2012 09:35AM
915
September 06, 2012 10:31PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.