MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: Mysql8.0 event 'committing alter table to storage engine' hangs During DDL after high traffic load
Posted by: Marek Kretkiewicz
Date: December 08, 2022 08:50AM

Hi
I have similar problem with my 8.0.26 mysql server and still have not solved it.

I would recommend you to check innodb_buffer_pool_size and compare it with your full data and indexes size.

What is interesting in our case probem has started, after we have increased the following parameters:

innodb_buffer_pool_instances: 5->20
innodb_buffer_pool_size: 10->20GB
innodb_log_file_size 1->2GB

Our DB is 40GB, so innodb_buffer_pool_size could be twice bigger, however I do not understand, why when before it was 10GB adding new partition on table with 10GB data and 10GB index was about 3s, after 13s and more.


IS there anybody who can help us ?

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


Subject
Views
Written By
Posted
Mysql8.0 event 'committing alter table to storage engine' hangs During DDL after high traffic load
1578
Amitz צור
September 05, 2022 06:25AM
Re: Mysql8.0 event 'committing alter table to storage engine' hangs During DDL after high traffic load
678
Marek Kretkiewicz
December 08, 2022 08:50AM
Re: Mysql8.0 event 'committing alter table to storage engine' hangs During DDL after high traffic load
487
Amit Zor
March 27, 2023 10:47PM


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.