Mysql caches: Difference between revisions

From wikinotes
 
(2 intermediate revisions by the same user not shown)
Line 11: 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
|-
 
| InnoDB: Buffer Pool || https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool.html
|-
| InnoDB: MemcacheD Plugin || https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached.html
|-
|}
|}
</blockquote><!-- Documentation -->
</blockquote><!-- Documentation -->
Line 29: Line 25:
|}
|}


== The OS Cache ==
<blockquote>
{{ TODO |
research. Apparently most prominent in MyISAM tables? }}
</blockquote><!-- The OS Cache -->
== Table Cache ==
<blockquote>
Used differently by different storage engines.
</blockquote><!-- Table Cache -->
</blockquote><!-- General -->
</blockquote><!-- General -->



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