List:General Discussion« Previous MessageNext Message »
From:Krishna Chandra Prajapati Date:April 30 2008 4:40am
Subject:mysql variables
View as plain text  
Hi,

Key_blocks_unused                  952405
Key_blocks_used                      395539

Key_blocks_used  is increasing day by day and Key_blocks_unused is
decreasing day by day. Ater a month Key_blocks_unused will reach to 0. Does
it mean that i need to increase the key_buffer_size. Already
key_buffer_size=1G.

While going through forums and lists , i found that when key_blocks_unused
is less. then select query will become slow.
So whats the right solution.


Thanks,
-- 
Krishna Chandra Prajapati

Thread
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