We have been fighting with an issue where when our database server is under what i would consider a small amount of stress the database gets “hung up” on simple queries leaving them in the state of “waiting for handler commit” for several minutes or more. An example of a time when we are seeing thi…

Hi again, innodb_log_file_size should be tuned to hold around 1 hour worth of write traffic at peak load as explained here: How to calculate a good InnoDB log file size - Percona Database Performance Blog depending on how big your ETL/data load size is, you might require a bigger than 1 GB redo lo…

Percona 8 statement "Hangs" with waiting for handler commit state

MySQL & MariaDB Percona Distribution for MySQL

RGK January 11, 2022, 4:47pm 7

Thanks for this information, it is very helpful!

1 Like

Topic		Replies	Views
Innodb Mutex Error?? Other MySQL® Questions	2	707	February 4, 2015
Semaphore wait timeouts Percona Server for MySQL 8.0	2	2050	July 13, 2022
Mysql hangs and crashes eventually Percona Server for MySQL 5.7	2	1144	December 17, 2021
MySQL hangs periodically Percona Server for MySQL 5.6	1	736	December 19, 2016
With high traffice,Percona Server had a slow response time. Other MySQL® Questions	0	544	November 8, 2012

Percona 8 statement "Hangs" with waiting for handler commit state

Related topics