Jump to content

Cache timing question


RopeADope

Recommended Posts

Are you talking about the query cache?

 

Probably?  I'm not familiar with the caching abilities of MySQL so I read through some documentation and user posts about it, but I'm still confused.  I think because of the way the question was asked of me, I figured there was an actual time setting somewhere.  Does the query cache has an actual time setting or is the time based on the number of queries ahead of the query in question?

So it would be the settings dictating the cache size that determines how long the record stays in cache?

Indirectly -- all things being equal, a larger cache will tend to keep more cache records, and assuming a random distribution (never true) of updates and inserts, they would persist longer.

 

But who cares how long they stay? They remain as long as they're valid.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.