Manual:objectcache table

↑ Manual:Contents

MediaWiki database layout

objectcache table

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

keyname

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

value

Cached object.

exptime

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

Versions

MediaWiki versions:

1.19 – 1.20

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

MediaWiki version:

1.18

describe objectcache;

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

MediaWiki version:

1.8

DESCRIBE objectcache; in MediaWiki 1.8 gives the following:

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

MediaWiki version:

1.9

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

MediaWiki version:

1.11

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

MediaWiki version:

1.12

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

Databases

Engines: MySQL – Oracle – PostgreSQL – SQLite Technical documentation: Schema (tables) – API property associations – Field prefixes – Primary key storage in other fields – Wikimedia extension tables Configuration: Settings – Sharing Development: Access – Optimization – Policy – Updater – Extension schema updates – Patch file Core tables: archive – category – categorylinks – change_tag – config – externallinks – filearchive – hitcounter – image – imagelinks – interwiki – iwlinks – ipblocks – job – l10n_cache – langlinks – logging – log_search – msg_resource – msg_resource_links – module_deps – objectcache – oldimage – page – pagelinks – page_props – page_restrictions – protected_titles – querycache – querycachetwo – querycache_info – recentchanges – redirect – revision – searchindex – sites – site_stats – tag_summary – templatelinks – text – transcache – updatelog – uploadstash – user – user_former_groups – user_groups – user_newtalk – user_properties – valid_tag – watchlist

Language:	English  • 日本語