Loading Large Flat Files Into MySQL With LOAD DATA INFILE and Pt-fifo-split

(Ike Walker) It’s easy to load multiple rows of data from a file into a MySQL table with a single LOAD DATA INFILE command, but if the file is over a certain size you may want to load it in multiple chunks. When I have a file with millions of lines I typically use pt-fifo-split to separate the file

Read More - Register for Free Membership