[wp-trac] [WordPress Trac] #53845: Add some more MySQL information to the Debug section in Site Health

[WordPress Trac]

#53845: Add some more MySQL information to the Debug section in Site Health
-------------------------+-----------------------------
 Reporter:  zodiac1978   |       Owner:  SergeyBiryukov
     Type:  enhancement  |      Status:  reopened
 Priority:  normal       |   Milestone:  5.9
Component:  Site Health  |     Version:
 Severity:  normal       |  Resolution:
 Keywords:  needs-patch  |     Focuses:
-------------------------+-----------------------------

Comment (by zodiac1978):

 Replying to [comment:9 johnbillion]:
 > Any `query_cache_*` variable lookups need to be excluded when the MySQL
 version is 5.7.20 or higher as the query cache is deprecated. Details:
 https://github.com/johnbillion/query-monitor/pull/313.

 Deprecation does not mean it is not used, or not? This setting is not
 removed until MySQL 8, so we could add a check for MySQL 8 to show it or
 not.

 The docs (https://dev.mysql.com/doc/refman/5.7/en/query-cache-
 configuration.html) are also mentioning a second value `query_cache_type`.
 If this is set to 0 or OFF the cache is not used.

 So we could just show it for MySQL < 8 and query_cache_type set to ON/1 or
 2/DEMAND.

 Or we remove this third value completely and just go with max. connections
 and max. allowed packet size.

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/53845#comment:12>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform