•  

Announcement

Announcement Module
Collapse
No announcement yet.

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

Page Title Module
Move Remove Collapse
Conversation Detail Module
Collapse
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts

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

    #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
    Tags: None

  • #2
    Hi,
    You should read about MySQL cache to have better understanding. Good start are at http://dev.mysql.com/doc/mysql/en/Query_Cache.html 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.

    Comment

    Working...
    X