Mysql caches
From wikinotes
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?
Table Cache
Used differently by different storage engines.
Engine Specific
mysql innodb caches mysql myisam caches