Mysql caches: Difference between revisions
From wikinotes
(22 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
= | There are some general MySQL caches, but increasingly they are engine specific. | ||
{{ TODO | | |||
split up this page per database engine, it's hard to read }} | |||
= Documentation = | |||
<blockquote> | <blockquote> | ||
{ | {| class="wikitable" | ||
|- | |||
https://dev.mysql.com/ | | MySQL: Query Cache || https://dev.mysql.com/doc/refman/5.7/en/query-cache.html | ||
|- | |||
| MyISAM: Key Cache || https://dev.mysql.com/doc/refman/5.7/en/myisam-key-cache.html | |||
|} | |||
</blockquote><!-- Documentation --> | |||
= General = | |||
< | <blockquote> | ||
{| class="wikitable" | |||
|- | |||
| [[mysql query cache]] | |||
|- | |||
| [[mysql os cache]] | |||
|- | |||
|} | |||
</blockquote><!-- General --> | |||
</ | |||
= Engine Specific = | |||
<blockquote> | |||
{| class="wikitable" | |||
|- | |||
| [[mysql innodb caches]] | |||
|- | |||
| [[mysql myisam caches]] | |||
|- | |||
|} | |||
</blockquote><!-- Engine Specific --> | |||
</blockquote><!-- |
Latest revision as of 04:25, 8 September 2022
There are some general MySQL caches, but increasingly they are engine specific.
TODO:
split up this page per database engine, it's hard to read
Documentation
MySQL: Query Cache https://dev.mysql.com/doc/refman/5.7/en/query-cache.html MyISAM: Key Cache https://dev.mysql.com/doc/refman/5.7/en/myisam-key-cache.html
General
mysql query cache mysql os cache
Engine Specific
mysql innodb caches mysql myisam caches