Manual:objectcache table

This page is a translated version of the page Manual:Objectcache table and the translation is 25% complete.
Other languages:
Manual:Contenido MediaWiki database layout objectcache table
Versión de MediaWiki:
1.3

The objectcache table is the default backend for the Main Stash service, and is also used by a small number of high-impact cache operations as fallback when no other cache backend is configured (e.g. Memcached ). Its content can be safely deleted and excluded from backups as it will be regenerated when needed.

See Manual:Cache de objetos for how this cache is used and how it can be configured.

Campos

keyname

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

value

Cached object.

exptime

Date the cache entry should be expired (in seconds), and therefore removed.

modtoken

Versión de MediaWiki:
1.37

?

flags

Versión de MediaWiki:
1.37

?

Schema summary

Versión de MediaWiki:
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              |       |
+----------+------------------+------+-----+-------------------+-------+
Versión de MediaWiki:
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    |       |
+---------+----------------+------+-----+---------+-------+
Versiones de MediaWiki:
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    |       |
+---------+----------------+------+-----+---------+-------+
Versiones de MediaWiki:
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    |       |
+---------+------------------+------+-----+---------+-------+