Oracle
1Z0-908 · Question #41
1Z0-908 Question #41: Real Exam Question with Answer & Explanation
The correct answer is A. innodb_flush_log_at_trx_commit=1 C. innodb_log_file_size=1G F. max_connections=10000. https://aws.amazon.com/blogs/database/best-practices-for-configuring-parameters-for-amazon- rds-for-mysql-part-1-parameters-related-to-performance/
Question
The data in this instance is transient; no backup or replication will be required. It is currently under performing. The database size is static and including indexes is 19G. Total system memory is 32G. After profiling the system, you highlight these MySQL status and global variables: The OS metrics indicate that disk is a bottleneck. Other variables retain their default values. Which three changes will provide the most benefit to the instance? (Choose three.)
Exhibit
Options
- Ainnodb_flush_log_at_trx_commit=1
- Bbuffer_pool_size=24G
- Cinnodb_log_file_size=1G
- Dsync_binlog=0
- Einnodb_doublewrite=0
- Fmax_connections=10000
- Ginnodb_undo_directory=/dev/shm
Explanation
https://aws.amazon.com/blogs/database/best-practices-for-configuring-parameters-for-amazon- rds-for-mysql-part-1-parameters-related-to-performance/
Community Discussion
No community discussion yet for this question.