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_cla2_ix | Performance | Asc | classname |
| tasklog_tim2_ix | Performance | Asc | timestart |
Diagram producer might be missing
No diagrams were produced please see application output for any errors