Home » Performance » MySQL » Is there a way to control query expiration time in cache?
Is there a way to control query expiration time in cache? [message #2962] Wed, 16 April 2008 02:29 Go to previous message
hairroot  is currently offline 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

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

  



Current Time: Thu Nov 20 19:14:08 EST 2008

Total time taken to generate the page: 0.10526 seconds
.:: Contact :: Home :: MySQL Support by Percona.com ::.

Powered by: FUDforum 2.7.5.
Copyright ©2001-2006 FUD Forum Bulletin Board Software

MySQL Performance | Forum authority Badge