MySQL Forums
Forum List  »  InnoDB

Re: Very slow performance when inserting, updating, deleting and changing schema
Posted by: Alejandro Alvarez
Date: May 21, 2021 12:11PM

Hi ! I'm having the same issue.

Similar setup:
- Windows 10 with WSL2 installed.
- Ubuntu on WSL2 and MySQL 8 installed on Ubuntu.

I have a Rails app that I use to read a CSV file and insert data into the MySQL.

The problem is that it insers 500 rows per minute when it should insert about 8500 per minute in normal conditions.

Anybody knows how can I make MySQL to insert data faster when running on WSL?

Thanks!

Options: ReplyQuote




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.