Details
-
Task
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
-
None
Description
It would be a useful feature to have a configurable ignore list for the Query Cache. Much like the replication ignore list, one could specify a series of database/table that are not involved in caching. If a given query involves any such of the database/tables in the list, its results will not be cached.
I have several tables that have pretty static data, but one table with lots of updates/inserts (cache invalidation). It would be ideal if the queries that involve that table always skip the cache. I can obviously do this with hints, but I would like have this feature to make it seamless.