task_log

0 rows


Description

The log table for all tasks

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
user.id Implied ConstraintR

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

Relationships