# Observing mysql slow inserts in the peak hours

**URL:** <https://forums.percona.com/t/observing-mysql-slow-inserts-in-the-peak-hours/14637>\
**Category:** MySQL & MariaDB\
**Tags:** mysql, closed-no-reply\
**Created:** [March 6, 2022, 1:06pm UTC](https://forums.percona.com/t/observing-mysql-slow-inserts-in-the-peak-hours/14637 "2022-03-06T13:06:17Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![dv\_reddy](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/dv_reddy/32/6003_2.png) [@dv\_reddy](https://forums.percona.com/u/dv_reddy)\
**Post date:** [March 6, 2022, 1:06pm UTC](https://forums.percona.com/t/observing-mysql-slow-inserts-in-the-peak-hours/14637/1 "2022-03-06T13:06:17Z")

</div>

Currently i am running mysql server in centos running in VM with the below specs,  
cpu : 16 cores  
ram: 66 GB , disk - intel ssd

–innodb-log-file-size=3221225472  
–innodb-buffer-pool-size=36G  
–innodb-buffer-pool-instances=8  
–innodb\_io\_capacity\_max=1500  
–innodb\_io\_capacity=800  
–innodb\_log\_buffer\_size=4294967296  
–max\_binlog\_size=11073741824

Normally, during peak hours, I can see the most recent row up to the time, but recently, there has been a gap between the most recent row and the time, and I haven’t been able to find anything in the full processlist or in innodb transactions to explain why one thread or one processlist is stopping the insert operation.

I need to know why it is happening and i can provide more details also if needed?