Rick works as a database administrator for a MySQL server. The server uses the InnoDB storage engine. Rick
finds that a table’s performance is inconsistent. He wants to bring the table to a consistent state without
shutting down the server. Choose the required stepsto accomplish the task.
Answer:
Explanation:
Dump the table through mysqldump.
Drop the table.
Recreate the table through dump.
These steps will not require Rick to shut down the server and will put the table in a consistent state.
Dump the table through mysqldump.
Drop the table.
Recreate the table through dump.
These steps will not require Rick to shut down the server and will put the table in a consistent state.