Home / server / Questions / 1074797
In Process
Set Kyar Wa Lar
Asked: 2021-08-18 02:14:22 +0800 CST

MySQL RDS Performance Insight got stuck

  • 772

We are using AWS MySQL RDS. Quite recently, we are saw MySQL RDS Performance Insight got stuck with

SET `@slave_uuid` = ?

Like the following image

Top SQL from RDS Performance Insights

The second one that follows the above is

Use `db_name`

As I check from the cloud watch monitoring. All the CPU/IOPS are pretty normal.

enter image description here

enter image description here

enter image description here

Is there any way to trace/solve this issue?

performance-monitoring amazon-web-services amazon-rds

1 Answers

  1. This is a known bug in MySQL Performance Schema affecting these MySQL versions:

    • >= 5.6.46
    • >= 5.7.28
    • >= 8.0.18

    https://forums.aws.amazon.com/thread.jspa?messageID=961243

    It's been over a year, no fix yet: https://bugs.mysql.com/bug.php?id=99039

    • 0