MySQL Forums
Forum List  »  InnoDB

Re: Need help to improve innodb performance
Posted by: Aftab Khan
Date: April 02, 2009 10:19AM

I can see one of your table has foreign key

InnoDB sets shared row-level locks on child or parent records it has to look at. InnoDB checks foreign key constraints immediately; the check is not deferred to transaction commit.

try to disable when you do a batch insert
mysql> SET foreign_key_checks = 0;
batch inserts...
mysql> SET foreign_key_checks = 1;

It speeds up the import operation. Setting foreign_key_checks to 0 can also be useful for ignoring foreign key constraints during LOAD DATA

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Need help to improve innodb performance
2606
April 02, 2009 10:19AM


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.