Re: Help needed to tune Innodb on ZFS (on Solaris)

[Nico Sabbi <Nicola.Sabbi@xxxxxxxx>]

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@xxxxxxxx> 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)



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx