Manual:transcache table

<translate> MediaWiki database layout</translate>

<translate> <tvar name=1>transcache</tvar> table</translate>

<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.31</tvar> is unsupported version</translate>">

1.8 – 1.31

<translate> MediaWiki versions:</translate>

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. <translate> (removed in <tvar name=2>1.32</tvar>)</translate>

Fields

tc_url

URL of cached content.

tc_contents

Contents of cache.

tc_time

Timestamp of cache.

Schema summary

<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.31</tvar> is unsupported version</translate>">

1.16 – 1.31

<translate> MediaWiki versions:</translate>

DESCRIBE transcache;

+-------------+----------------+------+-----+---------+-------+
| Field       | Type           | Null | Key | Default | Extra |
+-------------+----------------+------+-----+---------+-------+
| tc_url      | varbinary(255) | NO   | PRI | NULL    |       |
| tc_contents | text           | YES  |     | NULL    |       |
| tc_time     | binary(14)     | NO   |     | NULL    |       |
+-------------+----------------+------+-----+---------+-------+

<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.15</tvar> is unsupported version</translate>">

1.10 – 1.15

<translate> MediaWiki versions:</translate>

DESCRIBE transcache;

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

<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.9</tvar> is unsupported version</translate>">

1.5 – 1.9

<translate> MediaWiki versions:</translate>

DESCRIBE transcache;

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

Indexes

<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.31</tvar> is unsupported version</translate>">

1.30 – 1.31

<translate> MediaWiki versions:</translate>

SHOW INDEX IN transcache;

+------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table      | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| transcache |          0 | PRIMARY  |            1 | tc_url      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
+------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+