Jobs performed by parallel apache threads or a command-line daemon.
Fields [edit]
job_id [edit]
Primary key.
job_cmd [edit]
Command name, limited to 60 characters to prevent key length overflow.
job_namespace [edit]
Namespace to act on. Should be 0 if the command does not operate on a title. Used in conjunction with job_title.
job_title [edit]
Title to act on. Should be empty if the command does not operate on a title. Used in conjunction with job_namespace.
job_timestamp [edit]
| MediaWiki version: |
≥ 1.19 |
Timestamp of when the job was inserted. NULL for jobs added before addition of the timestamp.
job_params [edit]
Any other parameters to the command. Stored as a PHP serialized array, or an empty string if there are no parameters.
Versions [edit]
| MediaWiki versions: |
1.19 – 1.20 |
mysql> 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 | |
+---------------+------------------+------+-----+---------+----------------+
+---------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+------------------+------+-----+---------+----------------+
| job_id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| job_cmd | varbinary(60) | NO | MUL | NULL | |
| job_namespace | int(11) | NO | | NULL | |
| job_title | varbinary(255) | NO | | NULL | |
| job_params | blob | NO | | NULL | |
+---------------+------------------+------+-----+---------+----------------+
+---------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+------------------+------+-----+---------+----------------+
| job_id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| job_cmd | varbinary(60) | NO | MUL | NULL | |
| job_namespace | int(11) | NO | | NULL | |
| job_title | varchar(255) | NO | | NULL | |
| job_params | blob | NO | | NULL | |
+---------------+------------------+------+-----+---------+----------------+
+---------------+-----------------+------+-----+---------+----------------+
| 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) | NO | | NULL | |
| job_params | blob | NO | | NULL | |
+---------------+-----------------+------+-----+---------+----------------+
