MySQL Forums
Forum List  »  InnoDB

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 ?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Mysql8.0 event 'committing alter table to storage engine' hangs During DDL after high traffic load
508
December 08, 2022 08:50AM


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.