Manual:objectcache table
Jump to navigation
Jump to search
↑ 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.
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 (in seconds), and therefore removed.
Schema summary[edit]
MediaWiki version: | ≥ 1.36 Gerrit change 636049 |
DESCRIBE objectcache;
+---------+----------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+----------------+------+-----+---------+-------+ | keyname | varbinary(255) | NO | PRI | | | | value | mediumblob | YES | | NULL | | | exptime | binary(14) | NO | MUL | NULL | | +---------+----------------+------+-----+---------+-------+
MediaWiki versions: | 1.10 – 1.35 |
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 | | +---------+------------------+------+-----+---------+-------+