Jump to content

Handbuch:querycache_info-Tabelle

From mediawiki.org
This page is a translated version of the page Manual:Querycache info table and the translation is 71% complete.
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      |         |               |
+-----------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+