Re: Range Partition

[Peter Brawley]

> 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 ?