Examine these commands and output:
Which connection ID is holding the metadata lock?
Exam 1z0-908 All QuestionsBrowse all questions from this exam
Question 51
Correct Answer: C
Connection ID 21 is holding the metadata lock. This can be inferred because it is waiting for a table metadata lock for 'test.demo_test' as shown in the process list. Additionally, the metadata locks table shows that there is a pending lock for thread 62, which corresponds to process list ID 21.
Discussion
marklvOption: A
A. 20 is holding read and write locks which blocks the other commands.
marklvOption: A
It is not D, it wouldn't block access to the table. Its either id 20 or 21