Mysql 8.0 OCP认证考试原题题库整理（CUUG内部资料）-第5题
Mysql 8.0 OCP认证考试原题题库整理(CUUG内部资料)-第5题Choose four.A newly deployed replication master database has a 10/90 read to write ratio.The complete dataset is currently 28G but will never fluctuate beyond +-10%.The database storage system consists of two locally attached PCI- E Enterprise grade disks (mounted as /data1 and /data2)The server is dedicated to this MySQL Instance.System memory capacity is 64G.The my.cnf file contents are displayed here:datadir=/data1/innodb_buffer_pool_size=28Ginnodb_log_file_size=150MWhich four changes provide the most performance improvement, without sacrificing data integrity?A) innodb-doublewrite=offB) innodb_log_group_home_dir=/data2/C) innodb_log_file_size=1GD) innodb_undo_directory=/dev/shmE) log-bin=/data2/F) innodb_flush_log_at_trx_commit=0G) sync_binlog=0H) innodb_buffer_pool_size=32GI) disable-log-bin
页:
[1]