Skip to content

Table workerqueue#

Background tasks queue entries

Fields#

Field Description Type Null Key Default Extra
id Auto incremented worker task id int unsigned NO PRI NULL auto_increment
command Task command varchar(100) YES NULL
parameter Task parameter mediumtext YES NULL
priority Task priority tinyint unsigned NO 0
created Creation date datetime NO 0001-01-01 00:00:00
pid Process id of the worker int unsigned NO 0
executed Execution date datetime NO 0001-01-01 00:00:00
next_try Next retrial date datetime NO 0001-01-01 00:00:00
retrial Retrial counter tinyint NO 0
done Marked 1 when the task was done - will be deleted later boolean NO 0

Indexes#

Name Fields
PRIMARY id
command command
done_command_parameter done, command, parameter(64)
done_executed done, executed
done_priority_retrial_created done, priority, retrial, created
done_priority_next_try done, priority, next_try
done_pid_next_try done, pid, next_try
done_pid_retrial done, pid, retrial
done_pid_priority_created done, pid, priority, created

Return to database documentation