Příručka:Databázová tabulka querycache_info

This page is a translated version of the page Manual:Querycache info table and the translation is 100% complete.

Languages:

↑ Manuál:Obsah MediaWiki schéma databáze Tabulka querycache_info

Verze MediaWiki:

≥ 1.7

Tabulka querycache_info obsahuje podrobnosti o aktualizacích speciálních stránek uložených v mezipaměti.

Pole

qci_type

Odpovídá hodnotě qc_type

qci_timestamp

Časová značka poslední aktualizace

Přehled změn ve schématu tabulky

Verze MediaWiki:

≥ 1.10

DESCRIBEquerycache_info;

+---------------+---------------+------+-----+----------------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+---------------+------+-----+----------------+-------+
| qci_type | varbinary(32) | NO | PRI | | |
| qci_timestamp | binary(14) | NO | | 19700101000000 | |
+---------------+---------------+------+-----+----------------+-------+

Verze MediaWiki:

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

Indexy

Verze MediaWiki:

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