Manual:msg_resource table

The msg_resource table was a table used to cache JSON message blobs for the resource loader. Its content can be deleted and excluded from backups as it will be regenerated when needed. See also Manual:Msg resource links table .

Resource name.

Language code.

JSON blob.

Timestamp of last update.

DESCRIBEmsg_resource;

+--------------+----------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+----------------+------+-----+---------+-------+
| mr_resource | varbinary(255) | NO | PRI | NULL | |
| mr_lang | varbinary(32) | NO | PRI | NULL | |
| mr_blob | mediumblob | NO | | NULL | |
| mr_timestamp | binary(14) | NO | | NULL | |
+--------------+----------------+------+-----+---------+-------+

SHOWINDEXINmsg_resource;

+--------------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+--------------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| msg_resource | 0 | mr_resource_lang | 1 | mr_resource | A | 0 | NULL | NULL | | BTREE | | |
| msg_resource | 0 | mr_resource_lang | 2 | mr_lang | A | 0 | NULL | NULL | | BTREE | | |
+--------------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

• MediaWiki database tables