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