3

I'm seeing a CPU spike every 5 minutes (though it's not FIXED on the 5 minutes, every so often it's 6 minutes between a spike, then 5, 5, 5 again). None of my code runs on a 5 minute interval (it either runs statements EVERY minute, or every few HOURS).

This is what the graph looks like: enter image description here

Is there any way I can analyze what is causing the CPU to spike like this? Seeing a list of queries is good, but seeing their CPU impact is more what I'm after; a direct "A is causing B" way to dig down.

Does it exist?

3
  • Any scheduler jobs running on the database? Or primary-backup sync up?
    – harshavmb
    May 22, 2017 at 7:45
  • Does the AWS RDS Dashboard show anything. Failing that can you see anything interesting from running SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX
    – Dave Poole
    Apr 11, 2018 at 15:18
  • Did you ever solve this issue? Do you remember whether you modified the default value for binlog_format?
    – KevBurnsJr
    Jun 8, 2018 at 17:31

1 Answer 1

0

See the slow query list in mysql. Using that you could track which one is the culprit and taking more time to respond.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.