mysql 5.1 - innodb - query_cache_size - 9,418,108 queries have been removed from the query cache due to lack of memory
- by Tom C
Currently running on a 16GB system - Ubuntu 64 bit.
INnodb Buffer Pool is set to 10GB.
tuning-primer shows the following:
QUERY CACHE
Query cache is enabled
Current query_cache_size = 512 M
Current query_cache_used = 501 M
Current query_cache_limit = 4 M
Current Query cache Memory fill ratio = 97.87 %
Current query_cache_min_res_unit = 4 K
However, 9418108 queries have been removed from the query cache due to lack of memory
Perhaps you should raise query_cache_size
That is over 9million queries removed. System uptime is 8 days.
Should I remove the Query Cache altogether?
Our db is always under heavy I/O.
tia