Job table/ja

From MediaWiki.org

↑ Manual:Contents/ja

MediaWiki データベース レイアウト

Job table/ja

Jobs は、parallel apache threads あるいはコマンドラインデーモンによって機能します。

"DESCRIBE mw_job" により、 MediaWiki 1.8 においては下記の内容を示します。:

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

mysql> describe mw_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)    | NO   |     | NULL    |                |
| job_params    | blob            | NO   |     | NULL    |                |
+---------------+-----------------+------+-----+---------+----------------+
5 rows in set (0.03 sec)

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   |     |         |                |
| job_title     | varchar(255)     | NO   |     |         |                |
| job_params    | blob             | NO   |     |         |                |
+---------------+------------------+------+-----+---------+----------------+
5 rows in set (1.03 sec)