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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] >