Mysql caches: Difference between revisions
From wikinotes
Line 35: | Line 35: | ||
</blockquote><!-- The OS Cache --> | </blockquote><!-- The OS Cache --> | ||
</blockquote><!-- General --> | </blockquote><!-- General --> | ||
Revision as of 04:21, 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 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
General
mysql query cache mysql os cache The OS Cache
TODO:
research. Apparently most prominent in MyISAM tables?
Engine Specific
mysql innodb caches mysql myisam caches