List:General Discussion« Previous MessageNext Message »
From:Nico Sabbi Date:April 9 2008 9:43pm
Subject:Re: Help needed to tune Innodb on ZFS (on Solaris)
View as plain text  
Il Wednesday 09 April 2008 19:40:32 Rob Wultsch ha scritto:
> On Wed, Apr 9, 2008 at 5:51 AM, Nico Sabbi <Nicola.Sabbi@stripped> wrote:
> > The problem I have is that importing the same 7 MB sql dump
> > takes 9 seconds if engine=Myisam and 98 when engine is Innodb.
> >
> 
> Is autocommit turned off?
> 
> http://dev.mysql.com/doc/refman/5.0/en/innodb-tuning.html
> 
> " When importing data into InnoDB, make sure that MySQL does not have
> autocommit mode enabled because that requires a log flush to disk for
> every insert. To disable autocommit during your import operation,
> surround it with SET AUTOCOMMIT and COMMIT statements: SET
> AUTOCOMMIT=0;
> ... SQL import statements ...
> COMMIT;
> "

yes, autocommit is off

> 
> There is also a note in there about forcedirectio and certain solaris setups.

I read it, but directio seems to be unavailable on ZFS (as fas as I can tell)


Thread
Help needed to tune Innodb on ZFS (on Solaris)Nico Sabbi9 Apr
  • Re: Help needed to tune Innodb on ZFS (on Solaris)Rob Wultsch9 Apr
    • Re: Help needed to tune Innodb on ZFS (on Solaris)Nico Sabbi9 Apr
Re: Help needed to tune Innodb on ZFS (on Solaris)Rodolphe JOUANNET10 Apr