Jump to content

Manual:Objectcache table/es: Difference between revisions

From mediawiki.org
Content deleted Content added
FuzzyBot (talk | contribs)
Updating to match new version of source page
FuzzyBot (talk | contribs)
Updating to match new version of source page
Line 1: Line 1:
<languages/>
<languages/>
{{TNT|Database layout}}
{{Database layout}}
{{TOCright}}
{{TOCright}}
{{MW 1.3|and after}}
The '''objectcache''' table is used for a few generic cache operations if not using {{ll|Memcached}}.
The '''objectcache''' table is used for a few generic cache operations if not using {{ll|Memcached}}.
Its content can be deleted and excluded from backups as it will be regenerated when needed.
Its content can be deleted and excluded from backups as it will be regenerated when needed.
Line 18: Line 19:
==Schema summary==
==Schema summary==


{{TNT|MW version|version=1.10|comment=and after}}
{{MW version|version=1.10|comment=and after}}<!--as of 1.32-->
<code>'''DESCRIBE''' objectcache;</code>
<code>'''DESCRIBE''' objectcache;</code>
<pre>
<pre>
+---------+------------------+------+-----+---------+-------+
+---------+----------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
| Field | Type | Null | Key | Default | Extra |
+---------+------------------+------+-----+---------+-------+
+---------+----------------+------+-----+---------+-------+
| keyname | varbinary(255) | NO | PRI | NULL | |
| keyname | varbinary(255) | NO | PRI | | |
| value | mediumblob | YES | | NULL | |
| value | mediumblob | YES | | NULL | |
| exptime | datetime | YES | MUL | NULL | |
| exptime | datetime | YES | MUL | NULL | |
+---------+------------------+------+-----+---------+-------+
+---------+----------------+------+-----+---------+-------+
</pre>
</pre>


{{TNT|MW version|version=1.3|version2=1.9}}
{{MW version|version=1.3|version2=1.9}}
<code>'''DESCRIBE''' objectcache;</code>
<code>'''DESCRIBE''' objectcache;</code>
<pre>
<pre>
Line 42: Line 43:
</pre>
</pre>


{{TNT|databases}}
{{databases}}


[[Category:MediaWiki database tables{{#translation:}}|Objectcache table]]
[[Category:MediaWiki database tables{{#translation:}}|Objectcache table]]

Revision as of 04:32, 10 February 2019

Versión de MediaWiki:
1.3

The objectcache table is used for a few generic cache operations if not using Memcached . Its content can be deleted and excluded from backups as it will be regenerated when needed.

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, and therefore removed.

Schema summary

Versión de MediaWiki:
1.10

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    |       |
+---------+------------------+------+-----+---------+-------+