Manual:job table

From mediawiki.org

Translate this page

The job table holds a list of pending jobs . Used only when $wgJobTypeConf uses the JobQueueDB class.

Primary key.

Command name, limited to 60 characters to prevent key length overflow. Command names correspond to keys from $wgJobClasses .

Namespace to act on. Should be 0 if the command does not operate on a title. Used in conjunction with job_title.

Title to act on. Should be empty if the command does not operate on a title. Used in conjunction with job_namespace.

Timestamp of when the job was inserted. NULL for jobs added before addition of the timestamp.

Any other parameters to the command. Stored as a PHP serialized array, or an empty string if there are no parameters.

Random, non-unique, number used for concurrent job acquisition.

The number of times this job has been locked.

Field that conveys process locks on rows via process UUIDs. Unlocked jobs have this field set to an empty string.

Timestamp when the job was locked. Unlocked jobs have this field null.

Base 36 SHA1 of the job parameters relevant to detecting duplicates.

DESCRIBEjob;

+---------------------+------------------+------+-----+---------+----------------+
| 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 | | |
+---------------------+------------------+------+-----+---------+----------------+

DESCRIBEjob;

+---------------------+------------------+------+-----+---------+----------------+
| 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 | | |
+---------------------+------------------+------+-----+---------+----------------+

DESCRIBEjob;

+---------------------+------------------+------+-----+---------+----------------+
| 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 | | |
+---------------------+------------------+------+-----+---------+----------------+

DESCRIBEjob;

+---------------+---------------------+------+-----+---------+----------------+
| 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 | |
+---------------+---------------------+------+-----+---------+----------------+

DESCRIBEjob;

+---------------+---------------------+------+-----+---------+----------------+
| 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 | |
+---------------+---------------------+------+-----+---------+----------------+

DESCRIBEjob;

+---------------+---------------------+------+-----+---------+----------------+
| 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 | |
+---------------+---------------------+------+-----+---------+----------------+

SHOWINDEXINjob;

+-------+------------+------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| 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 | | |
+-------+------------+------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

Retrieved from "https://www.mediawiki.org/w/index.php?title=Manual:Job_table&oldid=6230928"

Category:

• MediaWiki database tables