Manual:Job table

↑ Manual:ContentsManual:Contents

MediaWiki database layoutManual:Database layout

job table

Jobs performed by parallel apache threads or a command-line daemon.

Fields

job_id

Primary key.

job_cmd

Command name, limited to 60 characters to prevent key length overflow.

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.

job_token_timestamp

Timestamp when the job was locked.

job_sha1

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

Versions

MediaWiki version:

1.21

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    |                |
| 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 |         |                |
+---------------------+------------------+------+-----+---------+----------------+
11 rows in set (0.00 sec)

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

MediaWiki version:

1.18

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

MediaWiki version:

1.10

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

MediaWiki version:

1.9

MediaWiki version:

1.8

MediaWiki version:

1.7

MediaWiki version:

1.6

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

DatabasesManual:Database layout

Engines: MySQLManual:MySQL – OracleManual:Oracle – PostgreSQLManual:PostgreSQL – SQLiteManual:SQLite Technical documentation: SchemaManual:Database layout (tablesCategory:MediaWiki database tables) – API property associationsAPI:Database field and API property associations – Field prefixesDatabase field prefixes – Primary key storage in other fieldsManual:Primary key storage in other fields – Wikimedia extension tablesCategory:Wikimedia extension database tables Configuration: SettingsManual:Configuration_settings#Database_settings – SharingManual:Shared database Development: AccessManual:Database access – OptimizationDatabase optimization – PolicyDevelopment policy#Database_patches – UpdaterManual:DatabaseUpdater.php – Extension schema updatesManual:Hooks/LoadExtensionSchemaUpdates – Patch fileManual:SQL patch file Core tables: archive – category – categorylinks – change_tag – config – externallinks – filearchive – hitcounter – image – imagelinks – interwiki – iwlinks – ipblocks – job – l10n_cache – langlinks – logging – log_search – msg_resource – msg_resource_links – module_deps – objectcache – oldimage – page – pagelinks – page_props – page_restrictions – protected_titles – querycache – querycachetwo – querycache_info – recentchanges – redirect – revision – searchindex – sites – site_stats – tag_summary – templatelinks – text – transcache – updatelog – uploadstash – user – user_former_groups – user_groups – user_newtalk – user_properties – valid_tag – watchlist

Language:	English  • 日本語