Manual:job テーブル

From mediawiki.org
This page is a translated version of the page Manual:Job table and the translation is 38% complete.
Other languages:
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

ジョブがロックされた際のタイムスタンプ。 Unlocked jobs have this field null.

job_sha1

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