MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

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!

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
MySQL 8.0.20+: insert speed drop
116
Andras Janurik
August 12, 2020 02:18AM
Re: MySQL 8.0.20+: insert speed drop
28
Peter Brawley
August 12, 2020 07:54AM
Re: MySQL 8.0.20+: insert speed drop
23
Andras Janurik
August 13, 2020 04:14AM
Re: MySQL 8.0.20+: insert speed drop
31
Edwin Desouza
August 12, 2020 11:05AM
Re: MySQL 8.0.20+: insert speed drop
31
Peter Brawley
August 12, 2020 11:35AM


Sorry, only registered users may post in this forum.
Click here to login

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.