Maintaining a stable system Flashcards
1
Q
Following a server crash, the automatic recovery of InnoDB fails.
How would you begin to manually repair the InnoDB tables?
A. Start the server with the – innodb_force_recovery option set to a non-zero value.
B. Start the server as usual, and then execute the REPAIR TABLE command.
C. Start the server as usual, and then execute the CHECK TABLE command.
D. Start the server with the – innodb_recover_options option set to FORCE.
A
a)
Start the server with the – innodb_force_recovery option set to a non-zero value
you can use the innodb_force_recovery option to force the InnoDB storage engine to start up while preventing background operations from running, so that you can dump your tables.
