MySQL 8.0 Database Administrator — Question 28

You want to check the values of the sort_buffer_size session variables of all existing connections.
Which performance_schema table can you query?

Answer options

• A. user_variables_by_thread
• B. global_variables
• C. variables_by_thread
• D. session_variables

Correct answer: C

Explanation

The correct answer is C, as the variables_by_thread table in performance_schema contains session variables for each thread. The other options, such as user_variables_by_thread, global_variables, and session_variables, do not specifically provide the session-level sort_buffer_size values for all connections.