Examine the following commands and output:
Which connection ID holds the metadata lock?
A granted metadata lock is held by thread 60, which maps to connection ID 20. Connection 22 owns the pending lock request for OPTIMIZE TABLE, so it is waiting for the lock rather than holding it.
OPTIMIZE TABLE
Community Discussion