[MDEV-4671] QUERY CACHE - black list Created: 2013-06-17 Updated: 2015-11-17 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Minor |
| Reporter: | roberto spadim | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 1 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Description |
|
We could implement a black list to query cache
an idea is a "mysql.query_cache_deny_tables" table with four columns:
we could check if table being cache is inside this table with 2 queries:
2) type="LIKE"
if this query return any rows we discart the query cache obvious more rows inside this table = slower query cache, must check what's fast, a "table "LIKE field, or a hash table with many "=" conditions and no "like" condition maybe we could add two others types: "!=" and "NOT LIKE" |