How Investigating High CPU Usage By using Percona

MySQL & MariaDB Other MySQL® Questions
,
1

Hi Everyone,

With a multitude of schemas in my database, CPU usage often spikes. Is it possible to use Percona to analyze this situation, specifically by detecting slow queries when the CPU usage is at its peak?"

This information would be highly valuable and helpful to me.

2

@Rajesh_Gandhavarapu I will highly recommend configuring percona PMM to check why your CPU is high, you can look into this blog A Simple Approach to Troubleshooting High CPU in MySQL if you have queries which are causing the CPU spikes. Mostly it’s the queries and bad indexing.