mysql LOAD DATA loads server

[Daffy_Duck]

Hi im trying to load a large file into mysql, it has over 60 million records. So I split it into 60 files of 1m records and im using this to load the files..

LOAD DATA LOCAL INFILE 'file.name' INTO TABLE dbname;

However its very slow taking upto an hour to insert 1m records and server loads go sky high.

How could I optimize mysql, is there anything I can put in my.cnf ?

Thanks