Manual:Querycache info table

---

↑ Manual:ContentsManual:Contents

MediaWiki database layoutManual:Database layout

querycache_info table

querycache_info table contains details of updates to cached special pages.

Fields

qci_type

Corresponds to a qc_typeManual:Querycache_table#qc_type value

qci_timestamp

Timestamp of last update

Versions

MediaWiki version:

≥ 1.18

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

MediaWiki version:

1.12

+---------------+-------------+------+-----+----------------+-------+
| Field         | Type        | Null | Key | Default        | Extra |
+---------------+-------------+------+-----+----------------+-------+
| qci_type      | varchar(32) | NO   | PRI | NULL           |       |
| qci_timestamp | char(14)    | NO   |     | 19700101000000 |       |
+---------------+-------------+------+-----+----------------+-------+

MediaWiki version:

1.11

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

MediaWiki version:

1.9

+---------------+-------------+------+-----+----------------+-------+
| Field         | Type        | Null | Key | Default        | Extra |
+---------------+-------------+------+-----+----------------+-------+
| qci_type      | varchar(32) | NO   | PRI | NULL           |       |
| qci_timestamp | char(14)    | NO   |     | 19700101000000 |       |
+---------------+-------------+------+-----+----------------+-------+

MediaWiki version:

1.8

DESCRIBE querycache_info; in MediaWiki 1.8 gives the following:

+---------------+-------------+------+-----+----------------+-------+
| Field         | Type        | Null | Key | Default        | Extra |
+---------------+-------------+------+-----+----------------+-------+
| qci_type      | varchar(32) | NO   | PRI | NULL           |       |
| qci_timestamp | char(14)    | NO   |     | 19700101000000 |       |
+---------------+-------------+------+-----+----------------+-------+

DatabasesManual:Database layout

Engines: MySQLManual:MySQL – OracleManual:Oracle – PostgreSQLManual:PostgreSQL – SQLiteManual:SQLite Technical documentation: SchemaManual:Database layout (tablesCategory:MediaWiki database tables) – API property associationsAPI:Database field and API property associations – Field prefixesDatabase field prefixes – Primary key storage in other fieldsManual:Primary key storage in other fields – Wikimedia extension tablesCategory:Wikimedia extension database tables Configuration: SettingsManual:Configuration_settings#Database_settings – SharingManual:Shared database Development: AccessManual:Database access – OptimizationDatabase optimization – PolicyDevelopment policy#Database_patches – UpdaterManual:DatabaseUpdater.php – Extension schema updatesManual:Hooks/LoadExtensionSchemaUpdates – Patch fileManual:SQL patch file Core tables: archive – category – categorylinks – change_tag – config – externallinks – filearchive – hitcounter – image – imagelinks – interwiki – iwlinks – ipblocks – job – l10n_cache – langlinks – logging – log_search – msg_resource – msg_resource_links – module_deps – objectcache – oldimage – page – pagelinks – page_props – page_restrictions – protected_titles – querycache – querycachetwo – querycache_info – recentchanges – redirect – revision – searchindex – sites – site_stats – tag_summary – templatelinks – text – transcache – updatelog – uploadstash – user – user_former_groups – user_groups – user_newtalk – user_properties – valid_tag – watchlist