You work as the Database Administrator for a MySQL database server. In an hour or so, you are able
to bring a corrupted server online. You execute the CHECK TABLE command and find that some of
the InnoDB tables need to be repaired. You restart the server and discover that auto-recover has
failed. Which of the following steps will you take to recover the corrupted InnoDB tables?
A.
Run the ANALYZE TABLE command.
B.
Run the REPAIR TABLE command.
C.
Recover the tables from the last backup.
D.
Run the OPTIMIZE TABLE command.
E.
Restart the server with the innodb_force_recovery option.
Explanation:
According to the question, the corrupted InnoDB tables are not auto-recovered. In such a case, you
will have to restart the server with the innodb_force_recovery option. Further, you can dump the
table, restart the server normally, and recover the tables from the dump file.
To investigate database page corruption, you might dump your tables from the database with SELECT … INTO OUTFILE. Usually, most of the data obtained in this way is intact. Serious corruption might cause SELECT * FROM tbl_name statements or InnoDB background operations to crash or assert, or even cause InnoDB roll-forward recovery to crash. In such cases, 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.
Yep, E is the correct one.