MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Database hangs during large inserts or load data infile on innodb table
7131
Ramam Pullella
December 13, 2006 09:55AM
Re: Database hangs during large inserts or load data infile on innodb table
2689
Ramam Pullella
December 13, 2006 10:08AM
Re: Database hangs during large inserts or load data infile on innodb table
3445
Marko Mäkelä
December 19, 2006 06:58AM
Re: Database hangs during large inserts or load data infile on innodb table
3116
James Day
December 20, 2006 05:59AM


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.