Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| CHANNEL_NAME | CHAR | 64 | null |
|
|
|||
| WORKER_ID | BIGINT UNSIGNED | 20 | null |
|
|
|||
| THREAD_ID | BIGINT UNSIGNED | 20 | √ | null |
|
|
||
| SERVICE_STATE | enum('ON', 'OFF') | 3 | null |
|
|
|||
| LAST_ERROR_NUMBER | INT | 10 | null |
|
|
|||
| LAST_ERROR_MESSAGE | VARCHAR | 1024 | null |
|
|
|||
| LAST_ERROR_TIMESTAMP | TIMESTAMP | 26 | null |
|
|
|||
| LAST_APPLIED_TRANSACTION | CHAR | 57 | √ | null |
|
|
||
| LAST_APPLIED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP | TIMESTAMP | 26 | null |
|
|
|||
| LAST_APPLIED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP | TIMESTAMP | 26 | null |
|
|
|||
| LAST_APPLIED_TRANSACTION_START_APPLY_TIMESTAMP | TIMESTAMP | 26 | null |
|
|
|||
| LAST_APPLIED_TRANSACTION_END_APPLY_TIMESTAMP | TIMESTAMP | 26 | null |
|
|
|||
| APPLYING_TRANSACTION | CHAR | 57 | √ | null |
|
|
||
| APPLYING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP | TIMESTAMP | 26 | null |
|
|
|||
| APPLYING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP | TIMESTAMP | 26 | null |
|
|
|||
| APPLYING_TRANSACTION_START_APPLY_TIMESTAMP | TIMESTAMP | 26 | null |
|
|
|||
| LAST_APPLIED_TRANSACTION_RETRIES_COUNT | BIGINT UNSIGNED | 20 | null |
|
|
|||
| LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER | INT | 10 | null |
|
|
|||
| LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE | VARCHAR | 1024 | √ | null |
|
|
||
| LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP | TIMESTAMP | 26 | null |
|
|
|||
| APPLYING_TRANSACTION_RETRIES_COUNT | BIGINT UNSIGNED | 20 | null |
|
|
|||
| APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER | INT | 10 | null |
|
|
|||
| APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE | VARCHAR | 1024 | √ | null |
|
|
||
| APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP | TIMESTAMP | 26 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc/Asc | CHANNEL_NAME + WORKER_ID |
| THREAD_ID | Performance | Asc | THREAD_ID |
