Mysql caches: Difference between revisions
From wikinotes
No edit summary |
|||
(17 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 = | = Documentation = | ||
<blockquote> | <blockquote> | ||
Line 6: | Line 11: | ||
|- | |- | ||
| MyISAM: Key Cache || https://dev.mysql.com/doc/refman/5.7/en/myisam-key-cache.html | | MyISAM: Key Cache || https://dev.mysql.com/doc/refman/5.7/en/myisam-key-cache.html | ||
|} | |} | ||
</blockquote><!-- Documentation --> | </blockquote><!-- Documentation --> | ||
Line 14: | Line 17: | ||
= General = | = General = | ||
<blockquote> | <blockquote> | ||
= | {| class="wikitable" | ||
|- | |||
| [[mysql query cache]] | |||
|- | |||
| [[mysql os cache]] | |||
|- | |||
|} | |||
</blockquote><!-- General --> | </blockquote><!-- General --> | ||
= Engine Specific = | = Engine Specific = | ||
<blockquote> | <blockquote> | ||
= | {| class="wikitable" | ||
|- | |||
| [[mysql innodb caches]] | |||
|- | |||
| [[mysql myisam caches]] | |||
|- | |||
|} | |||
</blockquote><!-- Engine Specific --> | </blockquote><!-- Engine Specific --> |
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