Re: WTA Increasing InnoDB Speed

2010-10-25 Thread Johan De Meersman
On Mon, Oct 25, 2010 at 6:25 AM, mos mo...@fastmail.fm wrote: At 06:12 AM 10/24/2010, you wrote: Regardless of that, it would be nice to know what the parameters are that cause this slowdown - some people may be stuck with the default version - companies with a support contract come to mind.

Re: WTA Increasing InnoDB Speed

2010-10-24 Thread Johan De Meersman
Regardless of that, it would be nice to know what the parameters are that cause this slowdown - some people may be stuck with the default version - companies with a support contract come to mind. On Sat, Oct 23, 2010 at 10:46 AM, Krishna Chandra Prajapati prajapat...@gmail.com wrote: Hi Willy,

Re: WTA Increasing InnoDB Speed

2010-10-24 Thread mos
At 06:12 AM 10/24/2010, you wrote: Regardless of that, it would be nice to know what the parameters are that cause this slowdown - some people may be stuck with the default version - companies with a support contract come to mind. You didn't say whether the slowdown occurs when 1) adding new

Re: WTA Increasing InnoDB Speed

2010-10-23 Thread Krishna Chandra Prajapati
Hi Willy, Try percona server. It gives better performance than mysql. Krishna On Sat, Oct 23, 2010 at 3:37 AM, Willy Mularto sangpr...@gmail.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.

WTA Increasing InnoDB Speed

2010-10-22 Thread Willy Mularto
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