My Oracle Support Banner

Metadata Locking -- Which Connection is Holding on to the Lock? (Doc ID 1473704.1)

Last updated on FEBRUARY 19, 2024

Applies to:

MySQL Server - Version 5.5 and later
Information in this document applies to any platform.

Goal

Identify what user and thread are holding on to a meta data lock that is preventing other queries from running

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 Metadata Lock Instrumentation Enabled
 Metadata Lock Instrumentation Not Enabled
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.