Manual:querycachetwo table

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

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

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

Target namespace. Used in conjunction with qcc_title.

Target title. Used in conjunction with qcc_namespace.

Target namespace2. Used in conjunction with qcc_titletwo.

Target title2. Used in conjunction with qcc_namespacetwo.

DESCRIBEquerycachetwo;

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

DESCRIBEquerycachetwo;

+------------------+------------------+------+-----+---------+-------+
| 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 | char(255) binary | NO | | NULL | |
| qcc_namespacetwo | int(11) | NO | | 0 | |
| qcc_titletwo | char(255) binary | NO | | NULL | |
+------------------+------------------+------+-----+---------+-------+

DESCRIBEquerycachetwo;

+------------------+------------------+------+-----+---------+-------+
| 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) binary | NO | | NULL | |
| qcc_namespacetwo | int(11) | NO | | 0 | |
| qcc_titletwo | char(255) binary | NO | | NULL | |
+------------------+------------------+------+-----+---------+-------+

SHOWINDEXINquerycachetwo;

+---------------+------------+--------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+---------------+------------+--------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| querycachetwo | 1 | qcc_type | 1 | qcc_type | A | 0 | NULL | NULL | | BTREE | | |
| querycachetwo | 1 | qcc_type | 2 | qcc_value | A | 0 | NULL | NULL | | BTREE | | |
| querycachetwo | 1 | qcc_title | 1 | qcc_type | A | 0 | NULL | NULL | | BTREE | | |
| querycachetwo | 1 | qcc_title | 2 | qcc_namespace | A | 0 | NULL | NULL | | BTREE | | |
| querycachetwo | 1 | qcc_title | 3 | qcc_title | A | 0 | NULL | NULL | | BTREE | | |
| querycachetwo | 1 | qcc_titletwo | 1 | qcc_type | A | 0 | NULL | NULL | | BTREE | | |
| querycachetwo | 1 | qcc_titletwo | 2 | qcc_namespacetwo | A | 0 | NULL | NULL | | BTREE | | |
| querycachetwo | 1 | qcc_titletwo | 3 | qcc_titletwo | A | 0 | NULL | NULL | | BTREE | | |
+---------------+------------+--------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

• MediaWiki database tables
• MediaWiki database tables that lack a primary key