1Z0-908: MySQL 8.0 Database AdministratorDemo

By Oracle · Question Mode

QuestionQ197

Performance

You need to check the values of the sort_buffer_size session variables for every established connection.

Which performance_schema table can you query?

  • A variables_by_thread
  • B session_variables
  • C user_variables_by thread
  • D global_variables
Explanation

performance_schema.variables_by_thread contains session system-variable values for each active session, identified by thread ID. It therefore exposes the per-connection sort_buffer_size values. session_variables shows only the current session’s values, while global_variables shows global values rather than each connection’s session setting.

Learn more

Community Discussion

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