Manual:L10n cache table: Difference between revisions
Content deleted Content added
Marked this version for translation |
m new tvar syntax |
||
| Line 3: | Line 3: | ||
{{MW 1.16|and after}} |
{{MW 1.16|and after}} |
||
{{TOCright}} |
{{TOCright}} |
||
<translate><!--T:1--> The <tvar |
<translate><!--T:1--> The <tvar name=1>'''l10n_cache'''</tvar> table.</translate> |
||
<translate><!--T:2--> Its content can be deleted and excluded from backups as it will be regenerated when needed.</translate> |
<translate><!--T:2--> Its content can be deleted and excluded from backups as it will be regenerated when needed.</translate> |
||
<translate><!--T:3--> <tvar |
<translate><!--T:3--> <tvar name=LocalisationCache>{{ll|Manual:LocalisationCache.php|LocalisationCache.php}}</tvar>'s <tvar name=LCStore>[[gerrit:plugins/gitiles/mediawiki/core/+/master/includes/cache/localisation/LCStoreDB.php|LCStoreDB]]</tvar> class's public function get() looks up the <code>lc_value</code> by the <code>lc_lang</code> and <code>lc_key</code>.</translate> |
||
<translate> |
<translate> |
||
Revision as of 01:55, 5 February 2022
| 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
lc_lang
Language code.
lc_key
Cache key.
lc_value
Value, stored as a serialized string.
Schema summary
| MediaWiki 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
| MediaWiki 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 | | | +------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+