phpmyadmin/phpmyadmin

Advisor: Suboptimal caching method VS The query cache is not enabled

开放

#17,667 创建于 2022年7月30日

 (2 条评论) (0 个反应) (0 位负责人)PHP (3,454 个派生)batch import
Bughelp wanted

仓库指标

星标
 (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!

贡献者指南