Open main menu

Manual:objectcache table


Other languages:
English • ‎español • ‎français • ‎中文 • ‎日本語
Manual:Contents MediaWiki database layout objectcache table


MediaWiki version: 1.3

The objectcache table is used for a few generic cache operations if not using Memcached . Its content can be deleted and excluded from backups as it will be regenerated when needed.

FieldsEdit

keynameEdit

Unique identifier of the cached object. e.g. <instance>:user:id:<userid>

valueEdit

Cached object.

exptimeEdit

Date the cache entry should be expired, and therefore removed.

Schema summaryEdit

MediaWiki version: 1.10

DESCRIBE objectcache;

+---------+----------------+------+-----+---------+-------+
| Field   | Type           | Null | Key | Default | Extra |
+---------+----------------+------+-----+---------+-------+
| keyname | varbinary(255) | NO   | PRI |         |       |
| value   | mediumblob     | YES  |     | NULL    |       |
| exptime | datetime       | YES  | MUL | NULL    |       |
+---------+----------------+------+-----+---------+-------+
MediaWiki versions: 1.3 – 1.9

DESCRIBE objectcache;

+---------+------------------+------+-----+---------+-------+
| Field   | Type             | Null | Key | Default | Extra |
+---------+------------------+------+-----+---------+-------+
| keyname | char(255) binary | NO   | PRI | NULL    |       |
| value   | mediumblob       | YES  |     | NULL    |       |
| exptime | datetime         | YES  | MUL | NULL    |       |
+---------+------------------+------+-----+---------+-------+