MySQL 8.0 Database Administrator — Question 110

Which three settings control global buffers shared by all threads on a MySQL server? (Choose three.)

Answer options

• A. sort_buffer_size
• B. key_buffer_size
• C. table_open_cache
• D. read_buffer_size
• E. innodb_buffer_pool_size
• F. tmp_table_size

Correct answer: A, B, F

Explanation

The correct answers A, B, and F refer to settings that define global buffer sizes for sorting, key caching, and temporary tables in MySQL. Options C and E are not global buffer settings; table_open_cache pertains to the number of open tables, while innodb_buffer_pool_size is specific to InnoDB's buffer pool, not a global buffer for all threads.