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