Thread: mysql variables
View Single Post

   
  #4 (permalink)  
Old 05-02-2008, 05:04 AM
Sebastian Mendel
 
Posts: n/a
Default Re: mysql variables

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
Reply With Quote