Slow Database, High Cpu Usage, and Many InnoDB Semaphore Waits With All Performance Schema Instruments Enabled; MySQL Workbench Performance Reports
(Doc ID 1682627.1)
Last updated on FEBRUARY 26, 2020
Applies to:
MySQL Server - Version 5.6 and laterMySQL Workbench - Version 6.1 and later
Information in this document applies to any platform.
Symptoms
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.
Changes
The Performance Schema instruments have all been enabled.
One way this can happen is when you go to see one of the Performance Reports in MySQL Workbench 6.1 or later. This requires enabling all of the Performance Schema instruments and most of the consumers.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |