What is it?
i need a query to calculate this : Qcache_hits / (QCache_hits + Com_select)
Simply Turn this query cache off... It is not needed
Yes your formula is correct But the query_cache parameter is now removed from mysql 8.0 it would have been easy to calculate the hit ratio previously. You can run SHOW VARIABLES LIKE '%query%'; and check the available parameters in newer mysql version.
Обсуждают сегодня