Bug #24469 server side variable "query_cache_min_limit"

• Submitted: 21 Nov 2006 11:22
• Modified: 7 Jul 2017 9:13
• Reporter: Yahoo Serious (Silver Quality Contributor)
• Status: Won't fix
• Category: MySQL Server: Query Cache
• Severity: S4 (Feature request)
• Version: 5.0.27, 4.1.21
• OS: Any (all)
• CPU Architecture: Any

[21 Nov 2006 11:22] Yahoo Serious

Description:
Besides the variable "query_cache_limit", defining the maximum result size,
I would like to have an opponent variable "query_cache_min_limit", defining the minimum result size.  

This way I can prevent infrequent individual record queries from caching on the server side.  

I would like that server side, so the application does not need proprietary(?) SQL, like SQL_CACHE/SQL_NO_CACHE.

How to repeat:
[feature request]

Suggested fix:
[feature request]

[26 Nov 2006 12:40] Valeriy Kravchuk

Thank you for a reasonable feature request.

[27 Nov 2006 9:28] Yahoo Serious

BTW, to prevent confusion one may then also want to rename some variables:
 - query_cache_min_res_unit  -->  query_cache_min_size_per_block
 - (new)              -->  query_cache_min_size_per_result
 - query_cache_limit  -->  query_cache_max_size_per_result
 - query_cache_size   -->  query_cache_max_size_total

[7 Jul 2017 9:13] Erlend Dahl

MySQL will no longer invest in the query cache, see:

http://mysqlserverteam.com/mysql-8-0-retiring-support-for-the-query-cache/