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

[Message index]

Read Message Is there a way to control query expiration time in cache?
By: hairroot on Wed, 16 April 2008 02:29

Re: Is there a way to control query expiration time in cache?
By: safari on Wed, 16 April 2008 03:24

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 00:41:45 EDT 2009

Total time taken to generate the page: 0.02088 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.