MySQL Forums
Forum List  »  InnoDB

Re: Database hangs during large inserts or load data infile on innodb table
Posted by: Marko Mäkelä
Date: December 19, 2006 06:58AM

Ramam,

I would guess that there are quite a few secondary indexes on the table. At first, the insert buffer would sequentialize the inserts to the secondary indexes. Then, the insert buffer would have to be merged, which causes random disk I/O. You should be able to confirm this by examining the output of SHOW ENGINE INNODB STATUS in various phases of the operation.

Fast index creation is work in progress. Currently, InnoDB inserts the records in each index one at a time. Even worse, CREATE INDEX, DROP INDEX, and ALTER TABLE are implemented by copying the table one record at a time to a temporary table. So, it is no use to create indexes after loading the data.

With apologies,
Marko Mäkelä
Innobase Oy/Oracle Corp.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Database hangs during large inserts or load data infile on innodb table
3314
December 19, 2006 06:58AM


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.