MySQL Optimization
- To reactivate indexes the command used is _________________.
-
View Hint View Answer Discuss in Forum
NA
Correct Option: B
In MySQL, the clauses ‘DISABLE KEYS’ and ‘ENABLE KEYS’ are used to deactivate and reactivate indexes for the table. The server does the work in deactivations and reactivations.
- TO enable the compressed client/server protocol the option is _________________.
-
View Hint View Answer Discuss in Forum
NA
Correct Option: D
The compressed client/server protocol is used to reduce the amount of data going over the network. For most of the MySQL clients this is specified using the –compress command line option.
- The option which delays index flushing for slave server is _________________.
-
View Hint View Answer Discuss in Forum
NA
Correct Option: D
For the replication slave servers, the –delay-key-write=ALL option delays index flushing for all MyISAM tables, regardless of how they were created originally on the master server.
- Which option repairs MyISAM tables automatically after they open?
-
View Hint View Answer Discuss in Forum
NA
Correct Option: C
In order to make sure that the repairs happen the server is started with the –myisam-recover=FORCE option. This enables the server to check MyISAM tables when it opens them and repair them automatically.
- Which table option for MyISAM tables reduces index flushing?
-
View Hint View Answer Discuss in Forum
NA
Correct Option: C
For MyISAM tables a strategy for reducing index flushing is to use the DELAY_KEY_WRITE table option. With this option the data rows are written to the data file immediately.