Home  >  Article  >  Database  >  mysql 无法启动缓存的问题

mysql 无法启动缓存的问题

WBOY
WBOYOriginal
2016-06-06 09:36:551382browse

mysql缓存

mysql 版本:5.6.25
系统:OS X 10.10.5

尝试了两种方法:
1、命令行:
mysql > set session query_cache_type=ON;
提示:
ERROR 1651 (HY000): Query cache is disabled; restart the server with query_cache_type=1 to enable it
2、在 my.cnf 最后添加
query_cache_type = 1
query_cache_size = 600000
重新启动mysql,结果还是不行
mysql> select @@query_cache_type;
+--------------------+
| @@query_cache_type |
+--------------------+
| OFF |
+--------------------+
PS:重启了电脑还是不行。

不知道有没有小伙伴遇到过这个问题!!!

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