User:RichMorin/mw objectcache

For a few generic cache operations, if not using Memcached.


Inter-table Relationships

edit

NA

MySQL Table Description

edit
mysql> desc mw_objectcache;
+---------+--------------+------+-----+---------+-------+
| Field   | Type         | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| keyname | varchar(255) |      | PRI |         |       |
| value   | mediumblob   | YES  |     | NULL    |       |
| exptime | datetime     | YES  | MUL | NULL    |       |
+---------+--------------+------+-----+---------+-------+
3 rows in set


Annotated Table Creation Code

edit
-- For a few generic cache operations,
-- if not using Memcached

CREATE TABLE /*$wgDBprefix*/objectcache (

  -- key, value, and expiration time
  -- for each cache entry

  keyname             char(255)      binary       NOT NULL  default '',
  value               mediumblob,
  exptime             datetime,
  
UNIQUE KEY            (keyname),
KEY                   (exptime)

) ENGINE=InnoDB;