MySQL Forums
Forum List  »  Partitioning

Re: Range Partition
Posted by: Peter Brawley
Date: June 18, 2017 10:52AM

> INDEX IND_fname(fname ),
> INDEX IND_lname(lname ),

Remember, MySQL can use one index per ref in a query, and each index slows down inserts & updates; why not index(lname,fname)?

> we are creating .sql file of insert statments of .1million rows

.1 million, or 1 million?

Did you try different chunk sizes?

All one statement per file, multiple statements and if so how big are the chunks, or single-insert statements?

Anything you haven't tried in the list of optimisations under "Bulk Inserts and Load Data Infile" at https://www.artfulsoftware.com/infotree/mysqltips.php ?

Options: ReplyQuote


Subject
Views
Written By
Posted
99
June 17, 2017 06:09AM
45
June 17, 2017 10:41AM
37
June 18, 2017 01:05AM
Re: Range Partition
41
June 18, 2017 10:52AM


Sorry, only registered users may post in this forum.

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.