Advisor: Suboptimal caching method VS The query cache is not enabled
#17,667 创建于 2022年7月30日
仓库指标
- 星标
- (6,886 个星标)
- PR 合并指标
- (平均合并 2天 17小时) (30 天内合并 11 个 PR)
描述
phpMyAdmin 5.2.0
In the "Advisor", I'm getting this issue:
Suboptimal caching method.
It says:
You are using the MySQL Query cache with a fairly high traffic database. It might be worth considering to use memcached instead of the MySQL Query cache, especially if you have multiple replicas.
However, when I look at the Variables,
query_cache_type = OFF query_cache_size = 0
(these are the live variables)
In the same "Advisor", I also get this "issue" (expected):
The query cache is not enabled.
which does mean that phpMyAdmin understands that query_cache_type == 'OFF' || query_cache_type == '0'
--
So, it looks like Suboptimal caching method. is misleading. I don't understand what's triggering it and what I really should be doing about it.
Thanks!