Thursday, August 29, 2002, 5:45:05 PM, you wrote:
>>Start by looking at the MySQL documentation:
>>Read the entire 6.9 section.
>>It offers quite a bit of information on how the cache operates, how
>>you should configure it and so on.
m> I read it too but I have a question about the cache, this sentence
m> in particular.
m> NOTE: The query cache does not return stale data. When data is modified,
m> any relevant entries in the query cache are flushed.
m> If I have a select statement like:
m> select col1, col2 from table1 where col1='A'
m> c) Or will any update to the table automatically flush the cache?
Yes, relevant entries in the query cache are flushed when any changes were made on the
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ Victoria.Reznichenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net