Re: Need help to improve innodb performance

[Aftab Khan]

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