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

The correct answer is A. sort_buffer_size B. key_buffer_size F. tmp_table_size. https://docs.oracle.com/cd/E17952_01/mysql-5.7-en/server-system-variables.html

Performance Tuning

Question

Options

Asort_buffer_size
Bkey_buffer_size
Ctable_open_cache
Dread_buffer_size
Einnodb_buffer_pool_size
Ftmp_table_size

How the community answered

(50 responses)

A
80% (40)
C
6% (3)
D
12% (6)
E
2% (1)

Explanation

https://docs.oracle.com/cd/E17952_01/mysql-5.7-en/server-system-variables.html

Topics

#global buffers#key_buffer_size#innodb_buffer_pool_size#per-thread vs shared memory

Community Discussion

No community discussion yet for this question.

Full 1Z0-908 Practice