The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
25 views

MySQL Query Cache - what type of queue is used?

I am wondering what type of queue is MySQL Query Cache using. When there is new query and cache is full which query is deleted? Oldest one? One with fewer number of hits? Or maybe there is some ...
0
votes
1answer
59 views

MariaDB not caching any queries

I tested several simple queries like such: SELECT COUNT(*) FROM Users WHERE courses='a'; But none are being cached. The following are the cache related variables: show variables like "%cache%"; ...
0
votes
0answers
23 views

pgpool caching normal behavior or bug?

I've activated shmem memory caching in pgpool and I'm getting a strange problem. I have an insert query like: INSERT INTO gps_comments (gcunit,gccomment,gcst,gcwho,gcexception, ...
0
votes
1answer
46 views

mysql's query cache behaviour on LIMIT

Is it accurate to assume that MySQL's query cache gets checked on subsequent execution of queries in the form SELECT ... WHERE ... LIMIT x, y where the the only varying paramaters in the query are x ...
1
vote
1answer
178 views

query cache hit value is not changing in my database

The query cache hit value is not changing in my database only for some queries.If I write select * from drugs_info limit 1000; the query cache hit has changed, but if I execute the following ...
4
votes
1answer
1k views

Qcache_free_memory not full yet I get alot of Qcache_lowmem_prunes

I just started dabbling with query cache for our CMS. Can anyone tell me why (or at least a good guess) I get alot of Qcache_lowmem_prunes when more than half of Qcache_free_memory is free? ...