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

MySQL & MariaDB Other MySQL® Questions
1

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)?

thanks

2

Hi,
You should read about MySQL cache to have better understanding. Good start are at [URL]http://dev.mysql.com/doc/mysql/en/Query_Cache.html[/URL] and http://dev.mysql.com/tech-resources/articles/mysql-query-cac 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.

Regards.