Manual:job テーブル
| ↑ Manual:コンテンツ | MediaWiki のデータベース レイアウト | job テーブル |
| MediaWiki バージョン: | ≧ 1.6 |
job テーブルは保留中のジョブの一覧を保持します。 $wgJobTypeConf が JobQueueDB クラスを使用する場合のみ使用されます。
フィールド
job_id
主キー。
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.
job_title と一緒に使用されます。
job_title
Title to act on.
Should be empty if the command does not operate on a title.
job_namespace と一緒に使用されます。
job_timestamp
| MediaWiki バージョン: | ≧ 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 バージョン: | ≧ 1.21 |
Random, non-unique, number used for concurrent job acquisition.
job_attempts
| MediaWiki バージョン: | ≧ 1.21 |
The number of times this job has been locked.
job_token
| MediaWiki バージョン: | ≧ 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 バージョン: | ≧ 1.21 |
ジョブがロックされた際のタイムスタンプ。 Unlocked jobs have this field null.
job_sha1
| MediaWiki バージョン: | ≧ 1.21 |
Base 36 SHA1 of the job parameters relevant to detecting duplicates.
スキーマの要約
| MediaWiki バージョン: | ≧ 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 バージョン: | 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 バージョン: | 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 バージョン: | 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 バージョン: | 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 バージョン: | 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 | | +---------------+---------------------+------+-----+---------+----------------+
インデックス
| MediaWiki バージョン: | ≧ 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 | | | +-------+------------+------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+