How to Fix MySQL High CPU Usage?
Applies to
- MySQL 5.7.x
- SnapCenter Server 4.x
Description
Several factors can cause an increase in CPU utilization:
- user-initiated heavy workloads
- analytic queries
- prolonged deadlocks and lock waits
- multiple concurrent transactions
- long-running transactions
- other processes that utilize CPU resources