多项选择题
Full Atomicity, Consistency, Isolation, Durability (ACID) compliance is a necessity for a new application, which heavily reads and writes data.
This requires the following config file options: Sync_binlog=1 Innodb_flush_log_at_trx_commit=1 Innodb_doublewrite=1 However, this configuration is expected to introduce disk I/O overhead.
What three changes will reduce disk I/O overheads?（）
A.Use of soft links for database directories on the same physical disk
B.Use of delay_key_write=ON for batch index update
C.Allocation of RAM to the buffer pool such that more of the data can fit in RAM
D.Placement of InnoDB log files and datadir on separate physical disks
E.Use of separate directories on the same physical disk for log files and data files
相关考题
-
单项选择题
Consider the following table: Which method should used to add a new g201305 partition to the table?（）
A.A
B.B
C.C
D.D
E.E -
多项选择题
What are two methods of taking a binary backup of a Mysql Server using InnoDB storage engine?（）
A.File system snapshots
B.Mysqldumpslow
C.Mysqlhotcopy
D.Mysqldump with – binary-data option
E.Mysql Enterprise Backup -
多项选择题
You want to shutdown a running Mysql Server cleanly. Which three commands that are valid on either Windows or Linux will achieve this?（）
A.Shell＞ mysqladmin –u root –p shutdown
B.Shell＞ nmc mysql shutdown
C.Mysql＞ STOP PROCESS mysqld
D.Shell＞ /etc/init.d/mysql stop
E.Shell＞ service mysql safe_exit
F.Shell＞ pkill –u mysql mysqld_safe
G.Shell＞ net stop mysql
