MySQL Forums
Forum List  »  InnoDB

Re: slow performance with InnoDB
Posted by: Horst Pralow
Date: August 28, 2008 08:31AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
2825
July 23, 2008 07:01AM
1786
July 23, 2008 01:06PM
1815
July 26, 2008 10:06PM
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.