List:General Discussion« Previous MessageNext Message »
From:Victoria Reznichenko Date:August 30 2002 12:58pm
Subject:Re: RE: performance tunning 4.x
View as plain text  
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



Thread
performance tunning 4.xSean Hager28 Aug
  • Re: performance tunning 4.xIikka Meriläinen28 Aug
    • RE: performance tunning 4.xSean Hager28 Aug
      • RE: performance tunning 4.xIikka Meriläinen28 Aug
        • RE: performance tunning 4.xmos29 Aug
          • Installing mysql 4.0.3 with linux threads on freebsdVarshavchick Alexander29 Aug
            • Re: Installing mysql 4.0.3 with linux threads on freebsdDan Nelson29 Aug
              • Re: Installing mysql 4.0.3 with linux threads on freebsdVarshavchick Alexander30 Aug
            • limiting the userSoheil Shaghaghi30 Aug
              • limiting the userSoheil Shaghaghi1 Sep
                • RE: limiting the userDean Harding1 Sep
          • RE: performance tunning 4.xIikka Meriläinen29 Aug
          • Re: RE: performance tunning 4.xVictoria Reznichenko30 Aug
            • Re: RE: performance tunning 4.xmos30 Aug
              • Re: RE: performance tunning 4.xPaul DuBois30 Aug
              • Re: Re: RE: performance tunning 4.xVictoria Reznichenko31 Aug