I am curious if there's any tools out there or methods to simulate mysql innodb crashes which would test and require the use of each of the 6 levels of innodb_force_recovery 1-6 http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html ?

What would I need to do to replicate each level of crash recovery ?


1 Answer 1


I use bvi to corrupt a tablespace. However you need to know InnoDB files format and how InnoDB works in order to make it start with particular recovery level. For example, for level 1 you need to change a checksum. For 3 - corrupt UNDO and so on.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.