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!

貢獻者指南