Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home > Database > Mysql Tutorial > 关于之前mysql5.6.13中查询缓存疑问的解决方法_MySQL

关于之前mysql5.6.13中查询缓存疑问的解决方法_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release： 2016-06-01 13:29:08
Original
892 people have browsed it

bitsCN.com

关于之前mysql5.6.13中查询缓存疑问的解决方法

 

之前发博提出了个问题

是相同的配置，不同的版本关于qcache的问题

 

这两天正在阅读《高性能mysql（第二版）》，今天晚上又查看了下，终于发现了原因。

原来，mysql5.6.13没有默认开启qcache，需要在my.ini中显式的启用查询缓存

 

query_cache_type=1

 

这样才能真正的开启查询缓存。

 

不过mysql5.6.13默认情况下只启用了1M的缓存空间，需要根据需要调整了

 

query_cache_size=1M

 

这是默认的设置

bitsCN.com
Related labels：
mysql
source：php.cn
Previous article：MySQL查询语句执行过程及性能优化-基本概念和EXPLAIN语句简介_MySQL Next article：mysql子查询命令_MySQL
Statement of this Website
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
Latest Articles by Author
Latest Issues
The problem that mysql service cannot be restarted after mysql upgrade
From 1970-01-01 08:00:00
0
0
0
MySQL stops process
From 1970-01-01 08:00:00
0
0
0
Error when installing mysql on linux
From 1970-01-01 08:00:00
0
0
0
php - In wamp, how to use mysql installed by myself instead of wamp integrated mysql?
From 1970-01-01 08:00:00
0
0
0
phpstudy cannot start mysql?
From 1970-01-01 08:00:00
0
0
0
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template