A.The General Query Log records more data than the Bina……

单项选择题Consider the MySQL Enterprise Audit plugin. On attempting to start the MySQL service after a crash, notice the following error: [ERROR] Plugin ‘audit_log’ init function returned error. In the audit log file, you notice the final entry: … What action should you take to fix the error and allow the service to start?（）

A.Re-install the audit plugin
B.Execute the command FLUSH LOGS
C.Execute the command SET GLOBAL audit_log_fiush= ON
D.Move or rename the existing audit.log file

单项选择题What is true regarding InnoDB locking?（）

A.InnoDB uses row and table-level locks, but row locks are not escalates
B.InnoDB locks only those rows that are updated
C.InnoDB only uses row locks, not page or table-level locks
D.InnoDB row locks may be escalated to page or table-level locks
E.InnoDB uses row-level or table-level locks depending on the number of rows affected

单项选择题Which statement is true about the log-output variable?（）

A.It is a static variable and can be set only at MySQL server startup
B.It enables and starts the General Query Log
C.It sets the target location for the binary logs generated by the MySQL sever
D.It specifies output destinations for the slow and General Query logs

单项选择题You are investigating the performance of the server and see the following information: Events_waits_summary_global_by_event_name in the performance schema shows that the wait synch mutex sql LOCK_table_cache event is dominating other wait events. The table_open_cache_overflows status variable is 0. Which action should be taken to remove the performance bottleneck described here?（）

A.Increase the value of table_definition_cache
B.Increase the value of table_open_cache_instances
C.Decrease the value of table_open_cache_instances
D.Increase the value of table_open_cache
E.Decrease the value of table_definition_cache
F.Decrease the value of table_open_cache

多项选择题Which two statements are true about setting the per-thread buffers higher than required?（）

A.More memory per thread is beneficial in all scenarios
B.It causes increased overhead due to initial memory allocation
C.It can affect system stability during peak load times, due to swapping
D.It requires increasing the thread_cache_size variable