data_locks

99999 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ENGINE VARCHAR 32 null
ENGINE_LOCK_ID VARCHAR 128 null
ENGINE_TRANSACTION_ID BIGINT UNSIGNED 20 √ null
processlist.ID Implied ConstraintR
THREAD_ID BIGINT UNSIGNED 20 √ null
EVENT_ID BIGINT UNSIGNED 20 √ null
processlist.ID Implied ConstraintR
OBJECT_SCHEMA VARCHAR 64 √ null
OBJECT_NAME VARCHAR 64 √ null
setup_consumers.NAME Implied ConstraintR
PARTITION_NAME VARCHAR 64 √ null
setup_consumers.NAME Implied ConstraintR
SUBPARTITION_NAME VARCHAR 64 √ null
setup_consumers.NAME Implied ConstraintR
INDEX_NAME VARCHAR 64 √ null
setup_consumers.NAME Implied ConstraintR
OBJECT_INSTANCE_BEGIN BIGINT UNSIGNED 20 null
LOCK_TYPE VARCHAR 32 null
LOCK_MODE VARCHAR 32 null
LOCK_STATUS VARCHAR 32 null
LOCK_DATA VARCHAR 8192 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc ENGINE_LOCK_ID + ENGINE
ENGINE_TRANSACTION_ID Performance Asc/Asc ENGINE_TRANSACTION_ID + ENGINE
OBJECT_SCHEMA Performance Asc/Asc/Asc/Asc OBJECT_SCHEMA + OBJECT_NAME + PARTITION_NAME + SUBPARTITION_NAME
THREAD_ID Performance Asc/Asc THREAD_ID + EVENT_ID

Relationships

Close relationships within degrees of separation