Manual:querycache_info table

From mediawiki.org
Other languages:
Manual:Contents MediaWiki database layout querycache_info table
MediaWiki version:
1.7

The querycache_info table contains details of updates to cached special pages.

Fields[edit]

qci_type[edit]

Corresponds to a qc_type value

qci_timestamp[edit]

Timestamp of last update

Schema summary[edit]

MediaWiki version:
1.10

DESCRIBE querycache_info;

+---------------+---------------+------+-----+----------------+-------+
| Field         | Type          | Null | Key | Default        | Extra |
+---------------+---------------+------+-----+----------------+-------+
| qci_type      | varbinary(32) | NO   | PRI |                |       |
| qci_timestamp | binary(14)    | NO   |     | 19700101000000 |       |
+---------------+---------------+------+-----+----------------+-------+
MediaWiki versions:
1.7 – 1.9

DESCRIBE querycache_info;

+---------------+-------------+------+-----+----------------+-------+
| Field         | Type        | Null | Key | Default        | Extra |
+---------------+-------------+------+-----+----------------+-------+
| qci_type      | varchar(32) | NO   | PRI | NULL           |       |
| qci_timestamp | char(14)    | NO   |     | 19700101000000 |       |
+---------------+-------------+------+-----+----------------+-------+

Indexes[edit]

MediaWiki version:
1.30

SHOW INDEX IN querycache_info;

+-----------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table           | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-----------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| querycache_info |          0 | PRIMARY  |            1 | qci_type    | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
+-----------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+