Slow Database, High Cpu Usage, and Many InnoDB Semaphore Waits With All Performance Schema Instruments Enabled; MySQL Workbench Performance Reports
Last updated on MARCH 10, 2017
Applies to:MySQL Server - Version 5.6 and later
MySQL Workbench - Version 6.1 and later
Information in this document applies to any platform.
After enabling all the Performance Schema instruments, one or more of the following symptoms are observed:
- The performance of MySQL is slow.
- The CPU usage is higher than normal.
- The number of InnoDB semaphore waits are higher than normal, although SHOW ENGINE INNODB STATUS does not necessarily show any semaphore waits.
The Performance Schema instruments have all been enabled.
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