MySQL Performance: MySQL => Is there a way to control query expiration time in cache?

Members

Help

Home

Home » Performance » MySQL » Is there a way to control query expiration time in cache?

Show: Today's Messages :: Show Polls :: Message Navigator

Is there a way to control query expiration time in cache? [message #2962]

Wed, 16 April 2008 02:29

hairroot
Messages: 7
Registered: April 2008

Junior Member

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

Report message to a moderator

Re: Is there a way to control query expiration time in cache? [message #2963 is a reply to message #2962 ]

Wed, 16 April 2008 03:24

safari
Messages: 26
Registered: August 2006
Location: Vietnam

Junior Member

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.

Report message to a moderator

Previous Topic:	The Slowness of "WHERE something IN (SELECT....)"
Next Topic:	ORDER BY ..LIMIT using indexes still slow

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 10 01:27:17 EDT 2009

Total time taken to generate the page: 0.00525 seconds

.:: Contact :: Home ::.

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.