Re: slow performance with InnoDB
If you are running in autocommit mode (the default), InnoDB will issue an fsync() call to the operating system which will cause the filesystem buffer to be written out to disk, that is: Atleast one disk i/o will occur and that's why InnoDB is slow compared with MyISAM which doesn't fsync() at all.
For bulk inserts you could group your inserts into a transaction like
BEGIN
INSERT ...
INSERT ...
INSERT ...
COMMIT WORK
This will avoid the individual fsyncs here and are likely to get an overall performance very close to MyISAM.
Subject
Views
Written By
Posted
2825
July 23, 2008 07:01AM
1786
July 23, 2008 01:06PM
1815
July 26, 2008 10:06PM
1856
July 28, 2008 06:24AM
Re: slow performance with InnoDB
1745
August 28, 2008 08:31AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.