After a server crash, some InnoDB tables need to be repaired. However, when the server is restarted, auto-recover failed. How would you repair the InnoDB tables?

The correct answer is A. Restart the server with the --innodb_force_recovery option. In rare cases, the server might not start up due to failure of InnoDB auto-recovery. If that happens, use the following procedure: Restart the server with the --innodb_force_recovery option set to a value in the range from 1 to 6. These values indicate increasing levels of…

MySQL Backup and Recovery

Question

Options

ARestart the server with the --innodb_force_recovery option.
BExecute the REPAIR TABLE command.
CExecute the OPTIMIZE TABLE command.

How the community answered

(58 responses)

A
83% (48)
B
10% (6)
C
7% (4)

Explanation

In rare cases, the server might not start up due to failure of InnoDB auto-recovery. If that happens, use the following procedure: Restart the server with the --innodb_force_recovery option set to a value in the range from 1 to 6. These values indicate increasing levels of caution in avoiding a crash, and increasing levels of tolerance for possible inconsistency in the recovered tables. A good value to start with is 4. (...)

Topics

#InnoDB crash recovery#innodb_force_recovery#server startup options#disaster recovery

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice