> For the complete documentation index, see [llms.txt](https://gitbook.wenzhihuai.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://gitbook.wenzhihuai.com/ba-mysql/shu-ju-ku-huan-cun.md).

# 8.1 mysql缓存.md

在MySQL 5.6开始，就已经默认禁用查询缓存了。在MySQL 8.0，就已经删除查询缓存功能了。

将select语句和语句的结果做[hash](https://so.csdn.net/so/search?q=hash\&spm=1001.2101.3001.7020)映射关系后保存在一定的内存区域内。

禁用原因：

1.命中率低

2.写时所有都失效

禁用了：<https://mp.weixin.qq.com/s/\\_EXXmciNdgXswSVzKyO4xg。>

查询缓存讲解：<https://blog.csdn.net/zzddada/article/details/124116182>