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?

  • Any scheduler jobs running on the database? Or primary-backup sync up? – harshavmb May 22 '17 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 '18 at 15:18
  • Did you ever solve this issue? Do you remember whether you modified the default value for binlog_format? – KevBurnsJr Jun 8 '18 at 17:31
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, privacy policy and cookie policy

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