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 |