Home >Database >Mysql Tutorial >为什么mysql明明开启了缓存但无法使用？
为什么mysql明明开启了缓存但无法使用？
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-06 09:45:371027browse
mysql缓存
第一步： SHOW VARIABLES LIKE '%cache%';
结果： have_query_cache YES
第二步： SELECT SQL_CACHE cr_name FROM t_course t WHERE t.course_id = 365;
第三步： SHOW STATUS LIKE '%Qcache%';
Qcache_free_blocks 0
Qcache_free_memory 0
Qcache_hits 0
Qcache_inserts 0
Qcache_lowmem_prunes 0
Qcache_not_cached 0
Qcache_queries_in_cache 0
Qcache_total_blocks 0
求解，谢谢！
实在是找不出哪里有禁用缓存的地方
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql-MySql 与其他数据库 数据同步Next article：mysql排序问题的sql语句