RopeADope Posted February 10, 2012 Share Posted February 10, 2012 Hi all. What setting dictates the time that a record will stay in the cache? Quote Link to comment Share on other sites More sharing options...
fenway Posted February 10, 2012 Share Posted February 10, 2012 Are you talking about the query cache? Quote Link to comment Share on other sites More sharing options...
RopeADope Posted February 10, 2012 Author Share Posted February 10, 2012 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? Quote Link to comment Share on other sites More sharing options...
fenway Posted February 10, 2012 Share Posted February 10, 2012 You're going to have to ask us the underlying question, because "time" makes no sense. Quote Link to comment Share on other sites More sharing options...
RopeADope Posted February 10, 2012 Author Share Posted February 10, 2012 My original post was the question that was asked of me. Would it have anything to do with these settings? http://www.debianhelp.co.uk/mysqlperformance.htm Quote Link to comment Share on other sites More sharing options...
digibucc Posted February 10, 2012 Share Posted February 10, 2012 well then what was the context - was it theoretical or specific to a database you work with? Quote Link to comment Share on other sites More sharing options...
RopeADope Posted February 10, 2012 Author Share Posted February 10, 2012 well then what was the context - was it theoretical or specific to a database you work with? Theoretical. Quote Link to comment Share on other sites More sharing options...
fenway Posted February 12, 2012 Share Posted February 12, 2012 The query cache will persist until something that relates to it is updated -- or a newer entries bumps it out (FIFO). Quote Link to comment Share on other sites More sharing options...
RopeADope Posted February 13, 2012 Author Share Posted February 13, 2012 So it would be the settings dictating the cache size that determines how long the record stays in cache? Quote Link to comment Share on other sites More sharing options...
fenway Posted February 13, 2012 Share Posted February 13, 2012 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.