List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:November 16 1999 1:01pm
Subject:auto-flushing of tables
View as plain text  
>>>>> "Tomas" == Tomas Karlsson <tomas.karlsson@stripped> writes:

Tomas> Hi,
Tomas> I read somewhere that mySQL automatically flushes the cache of the
Tomas> tables every once in a while. I was just curious how often this happens.
Tomas> I am wondering because everytime I look at the Not_flushed_key_blocks
Tomas> variable it's always 0.

Tomas> Tomas Karlsson

Hi!

MySQL flushes the data between each SQL statement and the key cache
every time the lock type changes.

Regards,
Monty
Thread
auto-flushing of tablesTomas Karlsson28 Oct
  • auto-flushing of tablesMichael Widenius18 Nov