Fastest way to insert data into mysql from csv
I would normally use the following statement:

LOAD DATA LOW_PRIORITY LOCAL INFILE 'C:\\Users\\Desktop\\nameoffile.csv' REPLACE INTO TABLE `tmp_table` CHARACTER SET latin1 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n';


You should take a look at this page too.
http://derwiki.tumblr.com/post/24490758395/loading-half-a-billion-rows-into-mysql