Manual:querycachetwo table

From MediaWiki.org
Jump to navigation Jump to search
This page is a translated version of the page Manual:Querycachetwo table and the translation is 20% complete.
Other languages:
English • ‎español • ‎polski • ‎日本語
Podręcznik:Spis treści Opis i struktura bazy danych MediaWiki querycachetwo table


Wersja MediaWiki: 1.9

The querycachetwo table is a table used for caching expensive grouped queries that need two links (for example double-redirects).

Pola

qcc_type

A key name, generally the base name of the special page.

qcc_value

Some sort of stored value. Sizes, counts...

qcc_namespace

Target namespace. Used in conjunction with qcc_title.

qcc_title

Target title. Used in conjunction with qcc_namespace.

qcc_namespacetwo

Target namespace2. Used in conjunction with qcc_titletwo.

qcc_titletwo

Target title2. Used in conjunction with qcc_namespacetwo.

Podsumowanie struktury

Wersja MediaWiki: 1.11

DESCRIBE querycachetwo;

+------------------+------------------+------+-----+---------+-------+
| Field            | Type             | Null | Key | Default | Extra |
+------------------+------------------+------+-----+---------+-------+
| qcc_type         | varbinary(32)    | NO   | MUL | NULL    |       |
| qcc_value        | int(10) unsigned | NO   |     | 0       |       |
| qcc_namespace    | int(11)          | NO   |     | 0       |       |
| qcc_title        | varbinary(255)   | NO   |     |         |       |
| qcc_namespacetwo | int(11)          | NO   |     | 0       |       |
| qcc_titletwo     | varbinary(255)   | NO   |     |         |       |
+------------------+------------------+------+-----+---------+-------+
Wersja MediaWiki: 1.10

DESCRIBE querycachetwo;

+------------------+------------------+------+-----+---------+-------+
| Field            | Type             | Null | Key | Default | Extra |
+------------------+------------------+------+-----+---------+-------+
| qcc_type         | varbinary(32)    | NO   | MUL | NULL    |       |
| qcc_value        | int(10) unsigned | NO   |     | 0       |       |
| qcc_namespace    | int(11)          | NO   |     | 0       |       |
| qcc_title        | char(255) binary | NO   |     | NULL    |       |
| qcc_namespacetwo | int(11)          | NO   |     | 0       |       |
| qcc_titletwo     | char(255) binary | NO   |     | NULL    |       |
+------------------+------------------+------+-----+---------+-------+
Wersja MediaWiki: 1.9

DESCRIBE querycachetwo;

+------------------+------------------+------+-----+---------+-------+
| Field            | Type             | Null | Key | Default | Extra |
+------------------+------------------+------+-----+---------+-------+
| qcc_type         | char(32)         | NO   | MUL | NULL    |       |
| qcc_value        | int(5) unsigned  | NO   |     | 0       |       |
| qcc_namespace    | int(11)          | NO   |     | 0       |       |
| qcc_title        | char(255) binary | NO   |     | NULL    |       |
| qcc_namespacetwo | int(11)          | NO   |     | 0       |       |
| qcc_titletwo     | char(255) binary | NO   |     | NULL    |       |
+------------------+------------------+------+-----+---------+-------+