I am experiencing trouble with a database, I am pretty sure there are some troublesome queries created by the programmers, but I need to find the culprit. So usually I dont have a problem with the database, but when we get up to a point everything seems to slow down. I am using mysql database in AWS, not aurora. I actived performace insight. This is how it looks when we are having problems enter image description here

This is a closer look at the biggest bar in the graph:

enter image description here

So it seems like some queries are locking the table but have troubling finishin and it takes a while to unlock the table right?? This is weird for me when I look at the Top SQL enter image description here Why is use showing like one of the TOP SQL

  • Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking.
    – Community Bot
    Oct 18 '21 at 11:57
  • 1
    Posting TEXT results of SHOW FULL PROCESSLIST; when experiencing the high load would be most helpful in identifying the querie(s) responsible. Oct 21 '21 at 14:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.