How can I speed up data import

SQL
1

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

2

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

1 Like
3

@SAM how do you? Please where can he set the autocommit for the system to recognize the command?

4

Just use it like you use other SQL commands.