[MDEV-4571] CLOSE - Query cache like features Created: 2013-05-24 Updated: 2015-01-21 Resolved: 2013-06-18 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Trivial |
| Reporter: | roberto spadim | Assignee: | Unassigned |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | querycache | ||
| Issue Links: |
|
||||||||||||||||||||
| Description |
|
Hi guys, very nice job with query_cache_information plugin!!! -------- with this we can: d)'insert method' => 'SQL_CACHE' or 'ALL' e)hits ok here we will lose some memory per entry (ulong hits) -------- the problem is the table string, that can be 'x' or 'x, y' or 'y, x' or 'y, x, z' ... i don't know if a table string is the better option, or maybe a subquery could do the job... and execute: since query cache must remove a query that have some table when we do insert / update / delete -------- -------- maybe via two options... ------- |
| Comments |
| Comment by roberto spadim [ 2013-05-24 ] |
|
more somethings, that the end of my brain strom about query cache, and i will sleep =] 1)add "query_time" and "rows_examined" to query entry b)if query time > 30 second or rows_examined>=1000000, it's a bad idea exclude this query, only if it have hits<xxxx we should remove it (maybe not), but this values are nice to know 2)add a new status value about query cache (maybe... it's cost cpu time to get this values) we need to get all query cache values to know the biggest value, maybe a cache of this values can help, but... 3)maybe in future a dynamic query cache "clean" option: with biggests values we could know what's the best query entry to delete: well end |
| Comment by roberto spadim [ 2013-05-26 ] |
|
please close this MDEV, |
| Comment by roberto spadim [ 2013-06-05 ] |
|
please close this MDEV, MDEV-4584 and |