How can I speed up data import

Hello,

I have been using MySQL Workbench in an attempt to import 5.5 million records from a CSV file into an empty table that has no indexes or foreign keys. When I run the procedure, the data loads, but it takes almost 4 seconds per row to load. The table has 36 columns and is a list of names and addresses, nothing special. I am not worried about data validation; I just need to get it loaded without missing rows and not take two weeks to do it. Any suggestions would be greatly appreciated.

Thank you,
Gary

Sounds like an autocommit issue. Try to SET autocommit=0; before importing the data.

1 Like