Manual:objectcache table

↑ Manual:Contents

MediaWiki database layout

objectcache table

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

mysql> describe mw_objectcache;
+---------+------------+------+-----+---------+-------+
| Field   | Type       | Null | Key | Default | Extra |
+---------+------------+------+-----+---------+-------+
| keyname | char(255)  | NO   | PRI | NULL    |       |
| value   | mediumblob | YES  |     | NULL    |       |
| exptime | datetime   | YES  | MUL | NULL    |       |
+---------+------------+------+-----+---------+-------+
3 rows in set (0.01 sec)