metadata_locks

1024 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
OBJECT_TYPE VARCHAR 64 null
OBJECT_SCHEMA VARCHAR 64 √ null
OBJECT_NAME VARCHAR 64 √ null
setup_consumers.NAME Implied ConstraintR
COLUMN_NAME VARCHAR 64 √ null
setup_consumers.NAME Implied ConstraintR
OBJECT_INSTANCE_BEGIN BIGINT UNSIGNED 20 null
LOCK_TYPE VARCHAR 32 null
LOCK_DURATION VARCHAR 32 null
LOCK_STATUS VARCHAR 32 null
SOURCE VARCHAR 64 √ null
OWNER_THREAD_ID BIGINT UNSIGNED 20 √ null
OWNER_EVENT_ID BIGINT UNSIGNED 20 √ null
processlist.ID Implied ConstraintR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc OBJECT_INSTANCE_BEGIN
OBJECT_TYPE Performance Asc/Asc/Asc/Asc OBJECT_TYPE + OBJECT_SCHEMA + OBJECT_NAME + COLUMN_NAME
OWNER_THREAD_ID Performance Asc/Asc OWNER_THREAD_ID + OWNER_EVENT_ID

Relationships

Close relationships within degrees of separation