A.it contains the binary log.

B.it contains a general tablespace.

C.it is the default location for all new tables that you create.

D.it contains the system tablespace.

E.it contains the redo log.

F.it contains the undo log.

A.There are 140 Performance Schema threads at the time of the output.

B.There are more connections being idle than executing queries.

C.There are 510 connections to MySQL at the time of the output.

D.The thread cache has been configured with thread_cache_size set to at least 6.

E.All max_connections were in use at 2018-03-22 14:54:06

A.Some settings for innodb_autoinc_lock_mode can help reduce locking.

B.InnoDB never uses table_level locks.

C.InnoDB always protects auto-increment updates with a table-level lock

D.InnoDB does not use locks to enforce auto-increment uniqueness.

E.The auto-increment lock can be a table-level lock.

A.The mysql user needs to have sudo privileges.

B.The mysqld process owner should own all files and directories to which the server writes.

C.The root or administrator users should own all files and directories to which the server writes.

D.The mysqld process should be run as root or administrator.

E.The mysqld process should not be run as root or administrator.

A.executing REVOKE FILE FROM *.*

B.executing REVOKE FILE ON *.* FROM ' ' @'%'

C.setting the --open-files-limit=0 option when starting mysqld

D.setting the --local-service=0 option when starting mysqld

E.executing REVOKE LOAD FROM *.*

F.setting the --local-infile=0 option when starting mysqld