Manual:Querycache table

From MediaWiki.org

↑ Manual:Contents

MediaWiki database layout

Querycache table

Table used for caching expensive grouped queries.

describe querycache;

+--------------+---------------------+------+-----+---------+-------+
| Field        | Type                | Null | Key | Default | Extra |
+--------------+---------------------+------+-----+---------+-------+
| qc_type      | char(32)            |      | MUL |         |       |
| qc_value     | int(5) unsigned     |      |     | 0       |       |
| qc_namespace | tinyint(2) unsigned |      |     | 0       |       |
| qc_title     | char(255) binary    |      |     |         |       |
+--------------+---------------------+------+-----+---------+-------+

describe querycache; in MediaWiki 1.8 gives the following:

+--------------+-----------------+------+-----+---------+-------+
| Field        | Type            | Null | Key | Default | Extra |
+--------------+-----------------+------+-----+---------+-------+
| qc_type      | char(32)        | NO   | MUL | NULL    |       |
| qc_value     | int(5) unsigned | NO   |     | 0       |       |
| qc_namespace | int(11)         | NO   |     | 0       |       |
| qc_title     | char(255)       | NO   |     | NULL    |       |
+--------------+-----------------+------+-----+---------+-------+

+--------------+-----------------+------+-----+---------+-------+
| Field        | Type            | Null | Key | Default | Extra |
+--------------+-----------------+------+-----+---------+-------+
| qc_type      | char(32)        | NO   | MUL | NULL    |       |
| qc_value     | int(5) unsigned | NO   |     | 0       |       |
| qc_namespace | int(11)         | NO   |     | 0       |       |
| qc_title     | char(255)       | NO   |     | NULL    |       |
+--------------+-----------------+------+-----+---------+-------+

+--------------+------------------+------+-----+---------+-------+
| Field        | Type             | Null | Key | Default | Extra |
+--------------+------------------+------+-----+---------+-------+
| qc_type      | varbinary(32)    | NO   | MUL | NULL    |       |
| qc_value     | int(10) unsigned | NO   |     | 0       |       |
| qc_namespace | int(11)          | NO   |     | 0       |       |
| qc_title     | varchar(255)     | NO   |     | NULL    |       |
+--------------+------------------+------+-----+---------+-------+

+--------------+-----------------+------+-----+---------+-------+
| Field        | Type            | Null | Key | Default | Extra |
+--------------+-----------------+------+-----+---------+-------+
| qc_type      | char(32)        | NO   | MUL | NULL    |       |
| qc_value     | int(5) unsigned | NO   |     | 0       |       |
| qc_namespace | int(11)         | NO   |     | 0       |       |
| qc_title     | char(255)       | NO   |     | NULL    |       |
+--------------+-----------------+------+-----+---------+-------+