Manual:Transcache table

---

↑ Manual:Contents

MediaWiki database layout

transcache table

MediaWiki version:

≥ 1.8

The transcache table is used to cache content that has been transcluded from other MediaWiki installations. See the interwiki table docs and the $wgEnableScaryTranscluding configuration variable for details on the feature.

Fields

tc_url

URL of cached content.

tc_contents

Contents of cache.

tc_time

Timestamp of cache.

Versions

MediaWiki version:

1.19

mysql> describe transcache;
+-------------+----------------+------+-----+---------+-------+
| Field       | Type           | Null | Key | Default | Extra |
+-------------+----------------+------+-----+---------+-------+
| tc_url      | varbinary(255) | NO   | PRI | NULL    |       |
| tc_contents | blob           | YES  |     | NULL    |       |
| tc_time     | binary(14)     | YES  |     | NULL    |       |
+-------------+----------------+------+-----+---------+-------+

MediaWiki version:

1.18

"DESCRIBE transcache" in MediaWiki 1.18+ returns the following:

+-------------+----------------+------+-----+---------+-------+
| Field       | Type           | Null | Key | Default | Extra |
+-------------+----------------+------+-----+---------+-------+
| tc_url      | varbinary(255) | NO   | PRI | NULL    |       |
| tc_contents | blob           | YES  |     | NULL    |       |
| tc_time     | int(11)        | NO   |     | NULL    |       |
+-------------+----------------+------+-----+---------+-------+

MediaWiki version:

1.8

"DESCRIBE transcache" in MediaWiki 1.8+ returns the following:

+-------------+--------------+------+-----+---------+-------+
| Field       | Type         | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| tc_url      | varchar(255) | NO   | PRI | NULL    |       |
| tc_contents | text         | YES  |     | NULL    |       |
| tc_time     | int(11)      | NO   |     | NULL    |       |
+-------------+--------------+------+-----+---------+-------+

Databases

Engines: MySQL – Oracle – PostgreSQL – SQLite Technical documentation: Schema (tables) – API property associations – Field prefixes – Primary key storage in other fields – Wikimedia extension tables Configuration: Settings – Sharing Development: Access – Optimization – Policy – Updater – Extension schema updates – 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