Exam 1z0-908 All QuestionsBrowse all questions from this exam
Go to Exam
Question 70

You want to check the values of the sort_buffer_size session variables of all existing connections.

Which performance_schema table can you query?

    Correct Answer: C

    The performance_schema table you can query to check the values of the sort_buffer_size session variables of all existing connections is variables_by_thread. This table contains session system variables for each active session identified by the thread ID.

Discussion
DhanushkaOption: C

variables_by_thread: Session system variables for each active session. An application that wants to know the session variable values for specific sessions should use this table. It includes session variables only, identified by thread ID.

FelipeKOption: C

root@localhost[shop]> select * from performance_schema.variables_by_thread where VARIABLE_NAME='sort_buffer_size'; +-----------+------------------+----------------+ | THREAD_ID | VARIABLE_NAME | VARIABLE_VALUE | +-----------+------------------+----------------+ | 66 | sort_buffer_size | 262144 | | 67 | sort_buffer_size | 262144 | +-----------+------------------+----------------+ 2 rows in set (0.00 sec)