| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Krishna Chandra Prajapati | Date: | April 30 2008 6: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 variables | Krishna Chandra Prajapati | 30 Apr |
| • Re: mysql variables | Dan Nelson | 30 Apr |
| • Re: mysql variables | Krishna Chandra Prajapati | 30 Apr |
| • Re: mysql variables | Sebastian Mendel | 30 Apr |
| • Re: mysql variables | Dan Nelson | 30 Apr |
