Is there a way to control query expiration time in cache?

I am not quite sure when the query got to be expired in query cache.

Does mysql tick out the least recently used query when the cache is full?

my question is:
can I let a query exist in the cache for a specific time(a day for example)?


You should read about MySQL cache to have better understanding. Good start are at and he.html

I guess what you’re looking for is just a cache layer in between your application and (mysql) database server.

Please consider of using memcached for this type of caching.