List:General Discussion« Previous MessageNext Message »
From:Sebastian Mendel Date:April 30 2008 6:09am
Subject:Re: mysql variables
View as plain text  
Krishna Chandra Prajapati schrieb:
> Hi Dan,
> I am worried about Key_blocks_unused. when Key_blocks_unused reach to 0.
> There will be no free blocks then how insert query will work.

it is like any other cache system, if the cache is not usable (full, not 
accessible or whatever) the cache will be omitted, and writes/reads go 
directly to the disk and not the RAM (cache)

you do not need to worry about loosing data caused by a full cache

Sebastian Mendel
mysql variablesKrishna Chandra Prajapati30 Apr
  • Re: mysql variablesDan Nelson30 Apr
    • Re: mysql variablesKrishna Chandra Prajapati30 Apr
      • Re: mysql variablesSebastian Mendel30 Apr
      • Re: mysql variablesDan Nelson30 Apr