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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php