mos,
Thursday, August 29, 2002, 5:45:05 PM, you wrote:
>>Start by looking at the MySQL documentation:
>>http://www.mysql.com/doc/en/Query_Cache.html
>>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'
[skip]
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
table.
--
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
<___/ www.mysql.com
