Currently i am running mysql server in centos running in VM with the below specs,
cpu : 16 cores
ram: 66 GB , disk - intel ssd
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?