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?
> " 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
> ... SQL import statements ...
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)