Objectcache table

From MediaWiki.org

↑ Manual:Contents

MediaWiki database layout

Objectcache table

Objectcache table is used for a few generic cache operations if not using Memcached.

describe objectcache;

+---------+---------------------+------+-----+---------+-------+
| Field   | Type                | Null | Key | Default | Extra |
+---------+---------------------+------+-----+---------+-------+
| keyname | varchar(255) binary |      | 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    |       |
+---------+------------+------+-----+---------+-------+