Exam 1z0-908 topic 1 question 4 discussion

B, E, G

D. sync_binlog=0: This disables the synchronizing of the binary log to disk after every commit. This can reduce disk I/O, but it comes with a risk of losing transactions in case of a crash. Since your data is transient, this might be an acceptable risk. E. innodb_doublewrite=0: Disabling innodb_doublewrite can reduce disk I/O, but it comes with a risk of data corruption in the event of a crash. Since your data is transient and doesn’t require backup or replication, this might be an acceptable risk. G. innodb_undo_directory=/dev/shm: Moving the innodb_undo_directory to a memory-based filesystem like /dev/shm can reduce disk I/O and improve performance. However, this comes with a risk of running out of space for undo logs if the system has a high rate of updates/deletes/inserts.

Agree DEG is correct

DEG buffer pool is already larger than data trx makes things worse log file doesn't necessarily make things better

B. buffer_pool_size=24G: Increasing the buffer pool size to 24G can help reduce disk I/O by keeping more data in memory. This can improve performance, especially if disk is a bottleneck. E. innodb_doublewrite=0: Disabling the doublewrite buffer can reduce disk I/O and improve performance. However, this comes at the cost of increased risk of data corruption in the event of a crash. G. innodb_undo_directory=/dev/shm: Setting the undo directory to /dev/shm can improve performance by storing undo logs in memory instead of on disk.