A.It is a static variable and can be set only at MySQL ……

单项选择题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

多项选择题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;

A.$ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sql
B.Mysql＞ INSERT INTO t1 VALUES FROM '/tmp/t1.sql'
C.$ mysql – u root – p – h localhost test ＜ /tmp/t1.sql
D.Mysql＞ LOAD DATA INFILE '/tmp/t1.sql' INTO TABLE t1
E.$ mysqlinport – u root – p – h localhost test /tmp/t1.sql

多项选择题What are three facts about backups with mysqldump?（）

A.Can back up a remote database server
B.Allow a consistent backup to be taken
C.Are always faster to restore than binary backups
D.Are able to back up specific items within a database
E.Create automatically compressed backups
F.Will lock all storage engines for duration of backup

多项选择题You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server. Which two changes would ensure that the temporary table does not propagate to the slave?（）

A.Use the – replicate-do-db, — replicate-do-table, or – replicate-wild-do-table option with the value equal to OLD_INVENTORY
B.Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table
C.Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table
D.Set binlog_format=MIXED with the – replicate-ignore-temp-table option
E.Use the – replicate-ignore-table option with the value equal to OLD_INENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table