Details
-
Type:
Task
-
Status: Open
-
Priority:
Trivial
-
Resolution: Unresolved
-
Fix Version/s: None
-
Component/s: Query Cache
-
Labels:
Description
MAX QUERIES IN CACHE per table/database
some schemas/tables are log schemas, i don't need query cache there
1) a per database solution using alter table or 'black_list' variable per schema
add a black list per schema, maybe a variable could do this job:
SET GLOBAL query_cache_no_cache_db=xxxx,yyyy,zzzz
ALTER DATABASE xxxx
QUERY_CACHE_MAX_QUERIES=0 (maybe -1 or NULL = infinity?),
QUERY_CACHE_FULL=REMOVE/CANT_CACHE
2) a per table solution, maybe using alter table, or a global variable
SET GLOBAL query_cache_max_queries_per_table=0 - 9999999999999999 (maybe -1 or NULL = infity?)
ALTER TABLE all_tables_in_schema_xxx
QUERY_CACHE_MAX_QUERIES=0 - 999999999999999 (maybe -1 or NULL = infinity?),
QUERY_CACHE_FULL=REMOVE/CANT_CACHE
QUERY_CACHE_FULL
REMOVE works like table cache (remove old table and add new one),
CANT_CACHE return "can't cache" and don't cache query
Gliffy Diagrams
Attachments
Issue Links
- relates to
-
-
- Open
-
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
