Querycachetwo table

From MediaWiki.org

↑ Manual:Contents

MediaWiki database layout

Querycachetwo table

querycachetwo is a table used for caching expensive grouped queries that need two links (for example double-redirects).

MediaWiki version:

1.9

DESCRIBE querycachetwo; in version 1.9 gives the following:

+------------------+-----------------+------+-----+---------+-------+
| Field            | Type            | Null | Key | Default | Extra |
+------------------+-----------------+------+-----+---------+-------+
| qcc_type         | char(32)        | NO   | MUL | NULL    |       |
| qcc_value        | int(5) unsigned | NO   |     | 0       |       |
| qcc_namespace    | int(11)         | NO   |     | 0       |       |
| qcc_title        | char(255)       | NO   |     | NULL    |       |
| qcc_namespacetwo | int(11)         | NO   |     | 0       |       |
| qcc_titletwo     | char(255)       | NO   |     | NULL    |       |
+------------------+-----------------+------+-----+---------+-------+

MediaWiki version:

1.11

DESCRIBE querycachetwo; in version 1.11 gives the following:

+------------------+------------------+------+-----+---------+-------+
| Field            | Type             | Null | Key | Default | Extra |
+------------------+------------------+------+-----+---------+-------+
| qcc_type         | varbinary(32)    | NO   | MUL | NULL    |       |
| qcc_value        | int(10) unsigned | NO   |     | 0       |       |
| qcc_namespace    | int(11)          | NO   |     | 0       |       |
| qcc_title        | varchar(255)     | NO   |     | NULL    |       |
| qcc_namespacetwo | int(11)          | NO   |     | 0       |       |
| qcc_titletwo     | varchar(255)     | NO   |     | NULL    |       |
+------------------+------------------+------+-----+---------+-------+

MediaWiki version:

1.12

DESCRIBE querycachetwo; in version 1.12 gives the following:

+------------------+-----------------+------+-----+---------+-------+
| Field            | Type            | Null | Key | Default | Extra |
+------------------+-----------------+------+-----+---------+-------+
| qcc_type         | char(32)        | NO   | MUL | NULL    |       |
| qcc_value        | int(5) unsigned | NO   |     | 0       |       |
| qcc_namespace    | int(11)         | NO   |     | 0       |       |
| qcc_title        | char(255)       | NO   |     | NULL    |       |
| qcc_namespacetwo | int(11)         | NO   |     | 0       |       |
| qcc_titletwo     | char(255)       | NO   |     | NULL    |       |
+------------------+-----------------+------+-----+---------+-------+