Hi,

I am using myisam engine and there is 25 GB of data. The data is keep on
growing. How should i know that when to increase the key_buffer_size.
currently it is 2G.

Thanks

--
Krishna Chandra Prajapati
MySQL DBA,
Ed Ventures e-Learning Pvt.Ltd.
1-8-303/48/15, Sindhi Colony
P.G.Road, Secunderabad.
Pin Code: 500003
Office Number: 040-66489771
Mob: 9912924044
URL: ed-ventures-online.com
Email-id: prajapatikc@gmail.com

Hi,
Keep your key_buffer_size to 25% of your physical RAM.
This should be good.

regards
anandkl





On 4/21/08, Krishna Chandra Prajapati <prajapatikc@gmail.com> wrote:
>
> Hi,
>
> I am using myisam engine and there is 25 GB of data. The data is keep on
> growing. How should i know that when to increase the key_buffer_size.
> currently it is 2G.
>
> Thanks
>
> --
> Krishna Chandra Prajapati
> MySQL DBA,
> Ed Ventures e-Learning Pvt.Ltd.
> 1-8-303/48/15, Sindhi Colony
> P.G.Road, Secunderabad.
> Pin Code: 500003
> Office Number: 040-66489771
> Mob: 9912924044
> URL: ed-ventures-online.com
> Email-id: prajapatikc@gmail.com
>