A.Increase the value of table_definition_cacheB.Increas……

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

单项选择题You adjust a default configuration to the following etc my.cnf on a Linux installation:[mysqld] Loq-bin Binrylog_format=ROW You do not notice the spelling error in binrylog_format and restart your production server. How does the MySQL server behave with incorrectly spelled options?（）

A.Mysqld uses internal configuration versioning and reverts to the previous configuration
B.When using mysql_config_editor for configuration adjustments, it detects incorrect syntax and typing mistakes
C.The mysqld_safe script skips the unknown variable and starts using the remaining configuration changes
D.Mysqld prints to the error log about an unknown variable, and then exits