Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| ENGINE | VARCHAR | 32 | null |
|
|
|||||
| REQUESTING_ENGINE_LOCK_ID | VARCHAR | 128 | null |
|
|
|||||
| REQUESTING_ENGINE_TRANSACTION_ID | BIGINT UNSIGNED | 20 | √ | null |
|
|
||||
| REQUESTING_THREAD_ID | BIGINT UNSIGNED | 20 | √ | null |
|
|
||||
| REQUESTING_EVENT_ID | BIGINT UNSIGNED | 20 | √ | null |
|
|
||||
| REQUESTING_OBJECT_INSTANCE_BEGIN | BIGINT UNSIGNED | 20 | null |
|
|
|||||
| BLOCKING_ENGINE_LOCK_ID | VARCHAR | 128 | null |
|
|
|||||
| BLOCKING_ENGINE_TRANSACTION_ID | BIGINT UNSIGNED | 20 | √ | null |
|
|
||||
| BLOCKING_THREAD_ID | BIGINT UNSIGNED | 20 | √ | null |
|
|
||||
| BLOCKING_EVENT_ID | BIGINT UNSIGNED | 20 | √ | null |
|
|
||||
| BLOCKING_OBJECT_INSTANCE_BEGIN | BIGINT UNSIGNED | 20 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| BLOCKING_ENGINE_LOCK_ID | Performance | Asc/Asc | BLOCKING_ENGINE_LOCK_ID + ENGINE |
| BLOCKING_ENGINE_TRANSACTION_ID | Performance | Asc/Asc | BLOCKING_ENGINE_TRANSACTION_ID + ENGINE |
| BLOCKING_THREAD_ID | Performance | Asc/Asc | BLOCKING_THREAD_ID + BLOCKING_EVENT_ID |
| REQUESTING_ENGINE_LOCK_ID | Performance | Asc/Asc | REQUESTING_ENGINE_LOCK_ID + ENGINE |
| REQUESTING_ENGINE_TRANSACTION_ID | Performance | Asc/Asc | REQUESTING_ENGINE_TRANSACTION_ID + ENGINE |
| REQUESTING_THREAD_ID | Performance | Asc/Asc | REQUESTING_THREAD_ID + REQUESTING_EVENT_ID |
Relationships
Close relationships within degrees of separation
