MySQL Forums
Forum List  »  InnoDB

Super slow load data infile with index
Posted by: Jim Van Overschelde
Date: June 17, 2014 12:04PM

I am loading tab delimited data from numerous files into a newly created table. If I use three non-unique value indexes then load times increase almost exponentially. Without index, loads times are almost linear with number of records.

File Records Time w/index Time w/o index
1 981,775 94.6 60.6s
2 938,626 116.6 55.6
3 993,750 158.1 56.5

What can I do to speed up the loading with indexing?

Options: ReplyQuote


Subject
Views
Written By
Posted
Super slow load data infile with index
1150
June 17, 2014 12:04PM


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.