myisam

myisam

am 21.04.2008 15:53:34 von Krishna Chandra Prajapati

------=_Part_17635_27881915.1208786014386
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_17635_27881915.1208786014386--

Re: myisam

am 21.04.2008 16:15:48 von Ananda Kumar

------=_Part_12916_21742224.1208787348887
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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 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
>

------=_Part_12916_21742224.1208787348887--