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
2172
December 11, 2020 10:19AM
Re: Slow Data Import Wizard
1357
December 15, 2020 11:27AM


Sorry, you can't reply to this topic. It has been closed.

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.