Manual:job table

From MediaWiki.org
Jump to: navigation, search
Manual:ContentsManual:Contents MediaWiki database layoutManual:Database layout job table


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.

job_random[edit]

MediaWiki version: 1.21

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

job_attempts[edit]

MediaWiki version: 1.21

The number of times this job has been locked.

job_token[edit]

MediaWiki version: 1.21

Field that conveys process locks on rows via process UUIDs.

job_token_timestamp[edit]

Timestamp when the job was locked.

job_sha1[edit]

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

Schema summary[edit]

MediaWiki version: 1.21

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    |                |
| job_random          | int(10) unsigned    | NO   |     | 0       |                |
| job_attempts        | int(10) unsigned    | NO   |     | 0       |                |
| job_token           | varbinary(32)       | NO   |     | NULL    |                |
| job_token_timestamp | varbinary(14)       | YES  |     | NULL    |                |
| job_sha1            | varbinary(32)       | NO   |     | NULL    |                |
+---------------------+---------------------+------+-----+---------+----------------+


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    |                |
+---------------+---------------------+------+-----+---------+----------------+
DatabasesManual:Database layout Engines: MySQL/MariaDBManual:MySQLOracleManual:OraclePostgreSQLManual:PostgreSQLSQLiteManual:SQLiteSQL ServerManual:Microsoft SQL Server

Technical documentation: SchemaManual:Database layout (tablesCategory:MediaWiki database tables) – API property associationsAPI:Database field and API property associationsField prefixesDatabase field prefixesPrimary key storage in other fieldsManual:Primary key storage in other fieldsWikimedia extension tablesCategory:Wikimedia extension database tables
Configuration: SettingsManual:Configuration_settings#Database_settingsSharingManual:Shared database
Development: AccessManual:Database accessOptimizationDatabase optimizationPolicyDevelopment policy#Database_patchesUpdaterManual:DatabaseUpdater.phpExtension schema updatesManual:Hooks/LoadExtensionSchemaUpdatesPatch fileManual:SQL patch file

Core tables: archivebot_passwordscategorycategorylinkschange_tagconfigexternallinksfilearchivehitcounterimageimagelinksinterwikiiwlinksipblocksjobl10n_cachelanglinkslogginglog_searchmsg_resourcemsg_resource_linksmodule_depsobjectcacheoldimagepagepagelinkspage_propspage_restrictionsprotected_titlesquerycachequerycachetwoquerycache_inforecentchangesredirectrevisionsearchindexsitessite_identifiers - site_statstag_summarytemplatelinkstexttranscacheupdateloguploadstashuseruser_former_groupsuser_groupsuser_newtalkuser_propertiestag_summaryvalid_tagwatchlist
Language:Project:Language policy English  • 日本語