MySQL Forums
Forum List  »  MySQL Workbench

Re: Slow Data Import Wizard
Posted by: Peter Brawley
Date: December 15, 2020 11:27AM

Is this CSV or JSON? Even before 8.0, MySQL routinely imports a million rows in a couple of secs from a CSV file with Load Data Infile.

Others have reported too that WB Data Import is slow. What's the rate in the mysql client program?

And if it's an InnoDB table, what's the setting of innodb_buffer_pool_size?

Options: ReplyQuote


Subject
Views
Written By
Posted
137
December 11, 2020 10:19AM
Re: Slow Data Import Wizard
53
December 15, 2020 11:27AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.