A.systemdattempted to start mysqld, found another systemd mysqldprocess running, and shut it down.

B.systemdwaited for 30 seconds before timing out and start up failed.

C.MySQL server continued to start up even though another process existed.

D.systemd found the mysqldservice disabled and failed to start it.

E.MySQL server was not started due to a problem while executing process 2732.

A.doublewrite buffer

B.change buffer

C.primary indexes

D.table data

E.InnoDB Data Dictionary

F.user privileges

A./var/lib/mysql

B./etc/my.cnf

C./usr/mysql

D./usr/bin

E./usr

A.The mysqlcheck --optimize --all-databases command reclaims free space from table files.

B.The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual table corruptions.
Section: (none)
Explanation

C.The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.

D.The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks.

E.The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.

A.It defines all innodb tablespace options relative to a starting parent directory.

B.It adds more temporary workspace in addition to the innodb_tmpdir location.

C.It allows scanning of other locations to discover more innodb tablespaces.

D.It is not necessary because innodb_data_home_dir is already defined.

E.It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.