I’m seeing more buf0buf
I have increased innodb_buffer_pool_instances from 1 to 3 will this help solve this issue.
–Thread 140197389825792 has waited at buf0buf.ic line 1256 for 0.0000 seconds the semaphore:
Mutex at 0x7f83655fc678 ‘&block->mutex’, lock var 0
waiters flag 0
–Thread 140197392221952 has waited at buf0buf.ic line 1256 for 0.0000 seconds the semaphore:
Mutex at 0x7f83655fc678 ‘&block->mutex’, lock var 0
waiters flag 0
–Thread 140197391156992 has waited at buf0buf.ic line 372 for 0.0000 seconds the semaphore:
Mutex at 0x7f83655fc678 ‘&block->mutex’, lock var 0
waiters flag 0
–Thread 140201749812992 has waited at buf0buf.ic line 372 for 0.0000 seconds the semaphore:
Mutex at 0x7f83655fc678 ‘&block->mutex’, lock var 0
waiters flag 0
–Thread 140211026294528 has waited at buf0buf.ic line 372 for 0.0000 seconds the semaphore:
Mutex at 0x7f83655fc678 ‘&block->mutex’, lock var 0
waiters flag 0
Mutex spin waits 920731983, rounds 3303841208, OS waits 1310995
RW-shared spins 4074733, rounds 23954032, OS waits 379441
RW-excl spins 876568, rounds 10258878, OS waits 77146
Spin rounds per wait: 3.59 mutex, 5.88 RW-shared, 11.70 RW-excl