1Z0-908: MySQL 8.0 Database AdministratorDemo

By Oracle · Question Mode

QuestionQ209

Performance

You need to inspect the values of the sort_buffer_size session variables for all existing connections.

Which performance_schema table can you query?

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

variables_by_thread stores session system-variable values for each active session and identifies each session by THREAD_ID. Filtering it for VARIABLE_NAME = 'sort_buffer_size' returns the per-connection values.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!