Manual:objectcache table

From MediaWiki.org
Jump to navigation Jump to search

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


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.

Fields[edit]

keyname[edit]

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

value[edit]

Cached object.

exptime[edit]

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

Schema summary[edit]

MediaWiki version: 1.10

DESCRIBE objectcache;

+---------+------------------+------+-----+---------+-------+
| Field   | Type             | Null | Key | Default | Extra |
+---------+------------------+------+-----+---------+-------+
| keyname | varbinary(255)   | NO   | PRI | NULL    |       |
| 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    |       |
+---------+------------------+------+-----+---------+-------+