Manual:querycache_info table

Translate this page

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

DESCRIBEquerycache_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

DESCRIBEquerycache_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

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