Manual:l10n_cache table
(Redirected from L10n cache)
↑ Manual:Contents | MediaWiki database layout | l10n_cache table |
MediaWiki version: | ≥ 1.16 |
The l10n_cache table.
Its content can be deleted and excluded from backups as it will be regenerated when needed.
LocalisationCache.php 's LCStoreDB class's public function get() looks up the lc_value
by the lc_lang
and lc_key
.
Fields
editlc_lang
editLanguage code.
lc_key
editCache key.
lc_value
editValue, stored as a serialized string.
Schema summary
editMediaWiki version: | ≥ 1.35 Gerrit change 597664 |
DESCRIBE l10n_cache;
+----------+----------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+----------------+------+-----+---------+-------+ | lc_lang | varbinary(35) | NO | PRI | NULL | | | lc_key | varbinary(255) | NO | PRI | NULL | | | lc_value | mediumblob | NO | | NULL | | +----------+----------------+------+-----+---------+-------+
MediaWiki versions: | 1.30 – 1.34 Gerrit change 318553 |
DESCRIBE l10n_cache;
+----------+----------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+----------------+------+-----+---------+-------+ | lc_lang | varbinary(32) | NO | PRI | NULL | | | lc_key | varbinary(255) | NO | PRI | NULL | | | lc_value | mediumblob | NO | | NULL | | +----------+----------------+------+-----+---------+-------+
MediaWiki versions: | 1.16 – 1.29 |
DESCRIBE l10n_cache;
+----------+----------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+----------------+------+-----+---------+-------+ | lc_lang | varbinary(32) | NO | MUL | NULL | | | lc_key | varbinary(255) | NO | | NULL | | | lc_value | mediumblob | NO | | NULL | | +----------+----------------+------+-----+---------+-------+
Indexes
editMediaWiki version: | ≥ 1.30 |
SHOW INDEX IN l10n_cache;
+------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | l10n_cache | 0 | PRIMARY | 1 | lc_lang | A | 0 | NULL | NULL | | BTREE | | | | l10n_cache | 0 | PRIMARY | 2 | lc_key | A | 0 | NULL | NULL | | BTREE | | | +------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+