Manual:Job table
| ↑ Manual:Contents | MediaWiki database layout | job table |
| MediaWiki version: | ≥ 1.6 |
The job table holds a list of pending jobs. Used only when $wgJobTypeConf uses the JobQueueDB class.
Fields
job_id
Primary key.
job_cmd
Command name, limited to 60 characters to prevent key length overflow. Command names correspond to keys from $wgJobClasses.
job_namespace
Namespace to act on.
Should be 0 if the command does not operate on a title.
Used in conjunction with job_title.
job_title
Title to act on.
Should be empty if the command does not operate on a title.
Used in conjunction with job_namespace.
job_timestamp
| MediaWiki version: | ≥ 1.19 |
Timestamp of when the job was inserted. NULL for jobs added before addition of the timestamp.
job_params
Any other parameters to the command. Stored as a PHP serialized array, or an empty string if there are no parameters.
job_random
| MediaWiki version: | ≥ 1.21 |
Random, non-unique, number used for concurrent job acquisition.
job_attempts
| MediaWiki version: | ≥ 1.21 |
The number of times this job has been locked.
job_token
| MediaWiki version: | ≥ 1.21 |
Field that conveys process locks on rows via process UUIDs. Unlocked jobs have this field set to an empty string.
job_token_timestamp
| MediaWiki version: | ≥ 1.21 |
Timestamp when the job was locked. Unlocked jobs have this field null.
job_sha1
| MediaWiki version: | ≥ 1.21 |
Base 36 SHA1 of the job parameters relevant to detecting duplicates.
Schema summary
| MediaWiki version: | ≥ 1.36 |
DESCRIBE job;
+---------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------------+------------------+------+-----+---------+----------------+ | job_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | job_cmd | varbinary(60) | NO | MUL | | | | job_namespace | int(11) | NO | | NULL | | | job_title | varbinary(255) | NO | | NULL | | | job_timestamp | binary(14) | YES | MUL | NULL | | | job_params | mediumblob | NO | | NULL | | | job_random | int(10) unsigned | NO | | 0 | | | job_attempts | int(10) unsigned | NO | | 0 | | | job_token | varbinary(32) | NO | | | | | job_token_timestamp | binary(14) | YES | | NULL | | | job_sha1 | varbinary(32) | NO | MUL | | | +---------------------+------------------+------+-----+---------+----------------+
| MediaWiki versions: | 1.33 – 1.35 |
DESCRIBE job;
+---------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------------+------------------+------+-----+---------+----------------+ | job_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | job_cmd | varbinary(60) | NO | MUL | | | | job_namespace | int(11) | NO | | NULL | | | job_title | varbinary(255) | NO | | NULL | | | job_timestamp | varbinary(14) | YES | MUL | NULL | | | job_params | mediumblob | NO | | NULL | | | job_random | int(10) unsigned | NO | | 0 | | | job_attempts | int(10) unsigned | NO | | 0 | | | job_token | varbinary(32) | NO | | | | | job_token_timestamp | varbinary(14) | YES | | NULL | | | job_sha1 | varbinary(32) | NO | MUL | | | +---------------------+------------------+------+-----+---------+----------------+
| MediaWiki versions: | 1.21 – 1.32 |
DESCRIBE job;
+---------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------------+------------------+------+-----+---------+----------------+ | job_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | job_cmd | varbinary(60) | NO | MUL | | | | job_namespace | int(11) | NO | | NULL | | | job_title | varbinary(255) | NO | | NULL | | | job_timestamp | varbinary(14) | YES | MUL | NULL | | | job_params | blob | NO | | NULL | | | job_random | int(10) unsigned | NO | | 0 | | | job_attempts | int(10) unsigned | NO | | 0 | | | job_token | varbinary(32) | NO | | | | | job_token_timestamp | varbinary(14) | YES | | NULL | | | job_sha1 | varbinary(32) | NO | MUL | | | +---------------------+------------------+------+-----+---------+----------------+
| MediaWiki versions: | 1.19 – 1.20 |
DESCRIBE job;
+---------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+---------------------+------+-----+---------+----------------+ | job_id | int(10) unsigned | NO | PRI | NULL | AUTO_INCREMENT | | job_cmd | varbinary(60) | NO | MUL | NULL | | | job_namespace | int(11) | NO | | NULL | | | job_title | varchar(255) binary | NO | | NULL | | | job_timestamp | varbinary(14) | YES | MUL | NULL | | | job_params | blob | NO | | NULL | | +---------------+---------------------+------+-----+---------+----------------+
| MediaWiki versions: | 1.10 – 1.18 |
DESCRIBE job;
+---------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+---------------------+------+-----+---------+----------------+ | job_id | int(10) unsigned | NO | PRI | NULL | AUTO_INCREMENT | | job_cmd | varbinary(60) | NO | MUL | NULL | | | job_namespace | int(11) | NO | | NULL | | | job_title | varchar(255) binary | NO | | NULL | | | job_params | blob | NO | | NULL | | +---------------+---------------------+------+-----+---------+----------------+
| MediaWiki versions: | 1.6 – 1.9 |
DESCRIBE job;
+---------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+---------------------+------+-----+---------+----------------+ | job_id | int(9) unsigned | NO | PRI | NULL | AUTO_INCREMENT | | job_cmd | varchar(255) | NO | MUL | NULL | | | job_namespace | int(11) | NO | | NULL | | | job_title | varchar(255) binary | NO | | NULL | | | job_params | blob | NO | | NULL | | +---------------+---------------------+------+-----+---------+----------------+
Indexes
| MediaWiki version: | ≥ 1.21 |
SHOW INDEX IN job;
+-------+------------+------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +-------+------------+------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | job | 0 | PRIMARY | 1 | job_id | A | 0 | NULL | NULL | | BTREE | | | | job | 1 | job_sha1 | 1 | job_sha1 | A | 0 | NULL | NULL | | BTREE | | | | job | 1 | job_cmd_token | 1 | job_cmd | A | 0 | NULL | NULL | | BTREE | | | | job | 1 | job_cmd_token | 2 | job_token | A | 0 | NULL | NULL | | BTREE | | | | job | 1 | job_cmd_token | 3 | job_random | A | 0 | NULL | NULL | | BTREE | | | | job | 1 | job_cmd_token_id | 1 | job_cmd | A | 0 | NULL | NULL | | BTREE | | | | job | 1 | job_cmd_token_id | 2 | job_token | A | 0 | NULL | NULL | | BTREE | | | | job | 1 | job_cmd_token_id | 3 | job_id | A | 0 | NULL | NULL | | BTREE | | | | job | 1 | job_cmd | 1 | job_cmd | A | 0 | NULL | NULL | | BTREE | | | | job | 1 | job_cmd | 2 | job_namespace | A | 0 | NULL | NULL | | BTREE | | | | job | 1 | job_cmd | 3 | job_title | A | 0 | NULL | NULL | | BTREE | | | | job | 1 | job_cmd | 4 | job_params | A | 0 | 128 | NULL | | BTREE | | | | job | 1 | job_timestamp | 1 | job_timestamp | A | 0 | NULL | NULL | YES | BTREE | | | +-------+------------+------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+