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 ?

Options: ReplyQuote

Written By
June 17, 2017 06:09AM
June 17, 2017 10:41AM
June 18, 2017 01:05AM
Re: Range Partition
June 18, 2017 10:52AM

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.