Slow InnoDB performance with many long semaphore waits in buf0buf.c
Last updated on MARCH 09, 2017
Applies to:MySQL Server - Version 4.1 and later
Information in this document applies to any platform.
- Slow InnoDb performance in highly concurrent environment.
- High CPU consumption.
- High value configured for innodb_buffer_pool_size. (On practice more than 32G).
- SHOW ENGINE INNODB STATUS shows many entries in SEMAPHORES section, waiting singe lock in buf0buf.c .
- Value of innodb_buffer_pool_instances is default.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms