How to Fix MySQL High CPU Usage?
- Views:
- 472
- Visibility:
- Public
- Votes:
- 0
- Category:
- snapcenter
- Specialty:
- snapx
- Last Updated:
- 8/20/2021, 8:07:51 PM
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