MySQL Forums
Forum List  »  InnoDB

MySQL 8.0.20+: insert speed drop
Posted by: Andras Janurik
Date: August 12, 2020 02:18AM

Hi,

After upgrading from MySQL 8.0.19 to 8.0.20 I noticed a significant speed drop with large inserts.
For example inserting 1 million records takes twice as long now.
Then I upgraded to 8.0.21 but it is the same as 8.0.20.

I even submitted a bug report (#100285) but they said they cannot repeat.
The conclusion was that maybe my.ini has a setting that is causing this behaviour.
I read through the change log but could not spot anything.
If I post my config here could somebody maybe help me find the problem?

Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL 8.0.20+: insert speed drop
175
August 12, 2020 02:18AM


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.