Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||||
| type | SMALLINT | 5 | null |
|
|
The type of task. Scheduled task = 0; Adhoc task = 1. |
||||
| component | VARCHAR | 255 |
|
|
The component that the task belongs to |
|||||
| classname | VARCHAR | 255 |
|
|
The class of the task being run |
|||||
| userid | BIGINT | 19 | null |
|
|
The userid that the task was configured to run as (Adhoc tasks only) |
||||
| timestart | DECIMAL | 20,10 | null |
|
|
The start time of the task |
||||
| timeend | DECIMAL | 20,10 | null |
|
|
The end time of the task |
||||
| dbreads | BIGINT | 19 | null |
|
|
The number of DB reads performed during the task. |
||||
| dbwrites | BIGINT | 19 | null |
|
|
The number of DB writes performed during the task. |
||||
| result | TINYINT | 3 | null |
|
|
Whether the task was successful or not. 0 = pass; 1 = fail. |
||||
| output | LONGTEXT | 2147483647 | null |
|
|
|||||
| hostname | VARCHAR | 255 | √ | null |
|
|
Hostname where the task was executed |
|||
| pid | BIGINT | 19 | √ | null |
|
|
PHP process ID that was running the task |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| tasklog_cla_ix | Performance | Asc | classname |
| tasklog_tim_ix | Performance | Asc | timestart |
| tasklog_use_ix | Performance | Asc | userid |