Manual:querycache table

From MediaWiki.org
Jump to: navigation, search

Other languages:
English • ‎español • ‎日本語 • ‎polski
Manual:ContentsManual:Contents MediaWiki database layoutManual:Database layout querycache table


The querycache table is used for caching expensive grouped queries. This table is populated with the updateSpecialPages.phpManual:updateSpecialPages.php maintenance script.

Fields[edit]

qc_type[edit]

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

qc_value[edit]

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

qc_namespace[edit]

Target namespace. Used in conjunction with gc_title.

qc_title[edit]

Target title. Used in conjunction with gc_namespace.

Schema summary[edit]

MediaWiki version: 1.11

DESCRIBE querycache;

+--------------+---------------------+------+-----+---------+-------+
| Field        | Type                | Null | Key | Default | Extra |
+--------------+---------------------+------+-----+---------+-------+
| qc_type      | varbinary(32)       | NO   | MUL | NULL    |       |
| qc_value     | int(10) unsigned    | NO   |     | 0       |       |
| qc_namespace | int(11)             | NO   |     | 0       |       |
| qc_title     | varchar(255) binary | NO   |     | NULL    |       |
+--------------+---------------------+------+-----+---------+-------+


MediaWiki version: 1.10

DESCRIBE querycache;

+--------------+---------------------+------+-----+---------+-------+
| Field        | Type                | Null | Key | Default | Extra |
+--------------+---------------------+------+-----+---------+-------+
| qc_type      | varbinary(32)       | NO   | MUL | NULL    |       |
| qc_value     | int(10) unsigned    | NO   |     | 0       |       |
| qc_namespace | int(11)             | NO   |     | 0       |       |
| qc_title     | char(255) binary    | NO   |     | NULL    |       |
+--------------+---------------------+------+-----+---------+-------+


MediaWiki versions: 1.5 – 1.9

DESCRIBE querycache;

+--------------+---------------------+------+-----+---------+-------+
| Field        | Type                | Null | Key | Default | Extra |
+--------------+---------------------+------+-----+---------+-------+
| qc_type      | char(32)            | NO   | MUL | NULL    |       |
| qc_value     | int(5) unsigned     | NO   |     | 0       |       |
| qc_namespace | int(11)             | NO   |     | 0       |       |
| qc_title     | char(255) binary    | NO   |     | NULL    |       |
+--------------+---------------------+------+-----+---------+-------+


MediaWiki versions: 1.3 – 1.4

DESCRIBE querycache;

+--------------+---------------------+------+-----+---------+-------+
| Field        | Type                | Null | Key | Default | Extra |
+--------------+---------------------+------+-----+---------+-------+
| qc_type      | char(32)            | NO   | MUL | NULL    |       |
| qc_value     | int(5) unsigned     | NO   |     | 0       |       |
| qc_namespace | tinyint(2) unsigned | NO   |     | 0       |       |
| qc_title     | char(255) binary    | NO   |     | NULL    |       |
+--------------+---------------------+------+-----+---------+-------+
DatabasesManual:Database layout Engines: MySQL/MariaDBManual:MySQLOracleManual:OraclePostgreSQLManual:PostgreSQLSQLiteManual:SQLiteSQL ServerManual:Microsoft SQL Server

Technical documentation: SchemaManual:Database layout (tablesCategory:MediaWiki database tables) – API property associationsAPI:Database field and API property associationsField prefixesDatabase field prefixesPrimary key storage in other fieldsManual:Primary key storage in other fieldsWikimedia extension tablesCategory:Wikimedia extension database tables
Configuration: SettingsManual:Configuration_settings#Database_settingsSharingManual:Shared database
Development: AccessManual:Database accessOptimizationDatabase optimizationPolicyDevelopment policy#Database_patchesUpdaterManual:DatabaseUpdater.phpExtension schema updatesManual:Hooks/LoadExtensionSchemaUpdatesPatch fileManual:SQL patch file

Core tables: archivebot_passwordscategorycategorylinkschange_tagconfigexternallinksfilearchivehitcounterimageimagelinksinterwikiiwlinksipblocksjobl10n_cachelanglinkslogginglog_searchmsg_resourcemsg_resource_linksmodule_depsobjectcacheoldimagepagepagelinkspage_propspage_restrictionsprotected_titlesquerycachequerycachetwoquerycache_inforecentchangesredirectrevisionsearchindexsitessite_identifiers - site_statstag_summarytemplatelinkstexttranscacheupdateloguploadstashuseruser_former_groupsuser_groupsuser_newtalkuser_propertiestag_summaryvalid_tagwatchlist