Manual:querycachetwo table

↑ 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).

Fields

qcc_type

A key name, generally the base name of of the special page.

qcc_value

Some sort of stored value. Sizes, counts...

qcc_namespace

Target namespace. Used in conjunction with gcc_title.

qcc_title

Target title. Used in conjunction with gcc_namespace.

qcc_namespacetwo

Target namespace2. Used in conjunction with gcc_titletwo.

qcc_titletwo

Target title2. Used in conjunction with gcc_namespacetwo.

Versions

MediaWiki version:

1.19

mysql> describe querycachetwo;
+------------------+------------------+------+-----+---------+-------+
| 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        | varbinary(255)   | NO   |     |         |       |
| qcc_namespacetwo | int(11)          | NO   |     | 0       |       |
| qcc_titletwo     | varbinary(255)   | NO   |     |         |       |
+------------------+------------------+------+-----+---------+-------+

MediaWiki version:

1.18

DESCRIBE querycachetwo; in version 1.18 gives the following:

+------------------+-----------------+------+-----+---------+-------+
| Field            | Type            | Null | Key | Default | Extra |
+------------------+-----------------+------+-----+---------+-------+
| qcc_type         | binary(32)      | NO   | MUL | NULL    |       |
| qcc_value        | int(5) unsigned | NO   |     | 0       |       |
| qcc_namespace    | int(11)         | NO   |     | 0       |       |
| qcc_title        | binary(255)     | NO   |     | NULL    |       |
| qcc_namespacetwo | int(11)         | NO   |     | 0       |       |
| qcc_titletwo     | binary(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    |       |
+------------------+-----------------+------+-----+---------+-------+

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

Databases

Engines: MySQL – Oracle – PostgreSQL – SQLite Technical documentation: Schema (tables) – API property associations – Field prefixes – Primary key storage in other fields – Wikimedia extension tables Configuration: Settings – Sharing Development: Access – Optimization – Policy – Updater – Extension schema updates – Patch file Core tables: archive – category – categorylinks – change_tag – config – externallinks – filearchive – hitcounter – image – imagelinks – interwiki – iwlinks – ipblocks – job – l10n_cache – langlinks – logging – log_search – msg_resource – msg_resource_links – module_deps – objectcache – oldimage – page – pagelinks – page_props – page_restrictions – protected_titles – querycache – querycachetwo – querycache_info – recentchanges – redirect – revision – searchindex – sites – site_stats – tag_summary – templatelinks – text – transcache – updatelog – uploadstash – user – user_former_groups – user_groups – user_newtalk – user_properties – valid_tag – watchlist