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
745
Andras Janurik
August 12, 2020 02:18AM
Re: MySQL 8.0.20+: insert speed drop
341
Peter Brawley
August 12, 2020 07:54AM
Re: MySQL 8.0.20+: insert speed drop
316
Andras Janurik
August 13, 2020 04:14AM
Re: MySQL 8.0.20+: insert speed drop
285
Edwin Desouza
August 12, 2020 11:05AM
Re: MySQL 8.0.20+: insert speed drop
319
Peter Brawley
August 12, 2020 11:35AM


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.