Which three settings control global buffers shared by all threads on a MySQL server? (Choose three.)
Which three settings control global buffers shared by all threads on a MySQL server? (Choose three.)
The three settings that control global buffers shared by all threads on a MySQL server are key_buffer_size, table_open_cache, and innodb_buffer_pool_size. The key_buffer_size determines the size of the buffer used for index blocks, table_open_cache influences the number of file descriptors available for open tables, and innodb_buffer_pool_size specifies the size of the buffer pool where InnoDB caches data and indexes.
CDF. cache and pool are global. Whoever answered these question is not an expert.
I am an idiot. read question wrong. BCE. table cache, innodb buffer pool, key cache as used by all.