Manual:Objectcache table/en

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. ). Its content can be safely deleted and excluded from backups as it will be regenerated when needed.

See for how this cache is used and how it can be configured.

keyname
Unique identifier of the cached object. e.g. :user:id:

value
Cached object.

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

modtoken
?

flags
?

Schema summary
+--+--+--+-+---+---+ +--+--+--+-+---+---+ +--+--+--+-+---+---+
 * 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              |       |

+-++--+-+-+---+ +-++--+-+-+---+ +-++--+-+-+---+
 * Field  | Type           | Null | Key | Default | Extra |
 * keyname | varbinary(255) | NO  | PRI |         |       |
 * value  | mediumblob     | YES  |     | NULL    |       |
 * exptime | binary(14)    | NO   | MUL | NULL    |       |

+-++--+-+-+---+ +-++--+-+-+---+ +-++--+-+-+---+
 * Field  | Type           | Null | Key | Default | Extra |
 * keyname | varbinary(255) | NO  | PRI |         |       |
 * value  | mediumblob     | YES  |     | NULL    |       |
 * exptime | datetime      | YES  | MUL | NULL    |       |

+-+--+--+-+-+---+ +-+--+--+-+-+---+ +-+--+--+-+-+---+
 * Field  | Type             | Null | Key | Default | Extra |
 * keyname | char(255) binary | NO  | PRI | NULL    |       |
 * value  | mediumblob       | YES  |     | NULL    |       |
 * exptime | datetime        | YES  | MUL | NULL    |       |