Manual:objectcache table

From mediawiki.org
Jump to navigation Jump to search
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.

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.

modtoken[edit]

MediaWiki version:
1.37

?

flags[edit]

MediaWiki version:
1.37

?

Schema summary[edit]

MediaWiki version:
1.37

Gerrit change 666780

DESCRIBE objectcache;

+----------+------------------+------+-----+-------------------+-------+
| Field    | Type             | Null | Key | Default           | Extra |
+----------+------------------+------+-----+-------------------+-------+
| keyname  | varbinary(255)   | NO   | PRI |                   |       |
| value    | mediumblob       | YES  |     | NULL              |       |
| exptime  | binary(14)       | NO   | MUL | NULL              |       |
| modtoken | varbinary(17)    | NO   |     | 00000000000000000 |       |
| flags    | int(10) unsigned | YES  |     | NULL              |       |
+----------+------------------+------+-----+-------------------+-------+
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    |       |
+---------+------------------+------+-----+---------+-------+