单项选择题
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?()
多项选择题 Which two statements are true about setting the per-thread buffers higher than required?()
多项选择题 In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data. You then TRUNCATE this table to empty it.() Mysql> SELECT * INTO OUTFILE /tmp/t1.sql from t1; mysql> TRUNCATE t1;