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:15PM

Hey, I just ran this query and I got these results:

+--------+----------+---------+----------+
| engine | data | indexes | total |
+--------+----------+---------+----------+
| InnoDB | 49.09 GB | 0.00 GB | 49.09 GB |
| CSV | 0.00 GB | 0.00 GB | 0.00 GB |
| TOTALS | 49.09 GB | 0.00 GB | 49.09 GB |
+--------+----------+---------+----------+

Do they look good?

My setup is:
- Windows 10 with WSL2 installed
- Ubuntu running on WSL2 and MySQL installed there

It inserts about 500 rows per minute when in normal conditions it should insert aprox 8500 rows.

Thanks for your help

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.