1Z0-873 · Question #94
Suppose you have a server that has been started with the --myisam-recover option. When does the server perform the check on the MyISAM tables?
The correct answer is C. Each time it opens the MyISAM table files. The MySQL server can be instructed to check and repair MyISAM tables automatically. With automatic repair enabled, the server checks each MyISAM table when it opens it to see whether the table was closed properly the last time it was used and is not marked as needing repair. If…
Question
Suppose you have a server that has been started with the --myisam-recover option. When does the server perform the check on the MyISAM tables?
Options
- AEach time the server is started.
- BEach time it encounters an error.
- CEach time it opens the MyISAM table files.
- DEach time the CHECK TABLE command is issued.
How the community answered
(36 responses)- A3% (1)
- B3% (1)
- C83% (30)
- D11% (4)
Explanation
The MySQL server can be instructed to check and repair MyISAM tables automatically. With automatic repair enabled, the server checks each MyISAM table when it opens it to see whether the table was closed properly the last time it was used and is not marked as needing repair. If the table is not okay, the server repairs it. To enable automatic MyISAM table maintenance, start the server with the --myisam-recover option.
Topics
Community Discussion
No community discussion yet for this question.