You are using mysqlcheck for server maintenance.
Which two statements are true? (Choose two.)
You are using mysqlcheck for server maintenance.
Which two statements are true? (Choose two.)
When using mysqlcheck for server maintenance, the mysqlcheck --check --all-databases command takes table write locks while performing a series of checks, ensuring data integrity during the maintenance process. Moreover, the mysqlcheck --optimize --all-databases command reclaims free space from table files by defragmenting the tables and optimizing their storage. These commands are part of common database maintenance tasks to ensure smooth operation and efficient storage management.
AC, answers don't make sense
AD. B is not always going to free up space if the innodb tables use general tablespace. For check, there is a read lock.
B is not guarantied, innodb use general space won't free up. E might be the other right answer.
Analyze table does not execute --auto-repair