User:RichMorin/mw jobs

From Meta, a Wikimedia project coordination wiki

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


Inter-table Relationships[edit]

NA

MySQL Table Description[edit]

mysql> desc mw_jobs;
+---------+--------------+------+-----+---------+-------+
| Field   | Type         | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| keyname | varchar(255) |      | PRI |         |       |
| value   | mediumblob   | YES  |     | NULL    |       |
| exptime | datetime     | YES  | MUL | NULL    |       |
+---------+--------------+------+-----+---------+-------+
5 rows in set


Annotated Table Creation Code[edit]

-- Jobs performed by parallel Apache threads
-- or a command-line daemon

CREATE TABLE /*$wgDBprefix*/job (

  job_id int(9) unsigned NOT NULL auto_increment,

  -- Command name, currently only refreshLinks is defined

  job_cmd             varchar(255)                NOT NULL  default '',

  -- Namespace and title to act on.
  -- Should be 0 and '' if the command does not operate on a title.

  job_namespace       int                         NOT NULL,
  job_title           varchar(255)   binary       NOT NULL,

  -- Any other parameters to the command
  -- Presently unused, format undefined
  
  job_params          blob                        NOT NULL  default '',

PRIMARY KEY           job_id (job_id),
KEY                   (job_cmd, job_namespace, job_title)

) ENGINE=InnoDB;