Manual:querycache_info table
Appearance
↑ 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 | | | +-----------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+