Manual:Objectcache table

---

↑ Manual:ContentsManual:Contents

MediaWiki database layoutManual:Database layout

objectcache table

The objectcache table is used for a few generic cache operations if not using MemcachedMemcached. 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    |       |
+---------+------------+------+-----+---------+-------+

DatabasesManual:Database layout

Engines: MySQLManual:MySQL – OracleManual:Oracle – PostgreSQLManual:PostgreSQL – SQLiteManual:SQLite Technical documentation: SchemaManual:Database layout (tablesCategory:MediaWiki database tables) – API property associationsAPI:Database field and API property associations – Field prefixesDatabase field prefixes – Primary key storage in other fieldsManual:Primary key storage in other fields – Wikimedia extension tablesCategory:Wikimedia extension database tables Configuration: SettingsManual:Configuration_settings#Database_settings – SharingManual:Shared database Development: AccessManual:Database access – OptimizationDatabase optimization – PolicyDevelopment policy#Database_patches – UpdaterManual:DatabaseUpdater.php – Extension schema updatesManual:Hooks/LoadExtensionSchemaUpdates – Patch fileManual:SQL 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