OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: WTA Increasing InnoDB Speed

From: Krishna Chandra Prajapati (prajapatikcgmail.com)
Date: Sat Oct 23 2010 - 03:46:22 CDT


Hi Willy,

Try percona server. It gives better performance than mysql.

Krishna

On Sat, Oct 23, 2010 at 3:37 AM, Willy Mularto <sangprabvgmail.com> wrote:

> Dear List,
> I have MySQL 5.14 installed on Dell R710 32GB RAM 600GB SAS HDD with Ubuntu
> 10.04 64 Bit. I deploy InnoDB as my default engine. The server is a high
> load server. On a fresh install and empty table it can insert around 5
> millions new records per day average. But when the table getting fat the
> performance starting to drop around 5% per day. It forces me to re create an
> empty table each month. So how to keep my server has a stable performance?
> Many thanks for the tips.
>
>
>
>
> sangprabv
> sangprabvgmail.com
> http://www.petitiononline.com/froyo/
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=prajapatikcgmail.com
>
>