Handbuch:querycache_info-Tabelle
↑ Handbuch:Inhaltsübersicht | MediaWiki-Datenbank-Layout | querycache_info-Tabelle |
MediaWiki Version: | ≥ 1.7 |
The querycache_info table contains details of updates to cached special pages.
Felder
qci_type
Entspricht einem qc_type -Wert
qci_timestamp
Timestamp of last update
Schematische Übersicht
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 | | +---------------+-------------+------+-----+----------------+-------+
Indexe
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 | | | +-----------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+