MySQL Master Long Running `set @slave_uuid = ?`

Probably related and what I'm currently investigating, the top wait is:

wait/synch/cond/sql/MYSQL_BIN_LOG::update_cond

Again, all related to master/slave, but still not sure what's causing this or how to clear it.

Greetings,

This may be related to a bug in MySQL Performance Schema [1] if you are using any of the following MySQL versions:
=>5.6.46
=>5.7.28
=>8.0.18

It's not really a long running query, just a misrepresentation on the PI dashboard as the query is not actually executing or consuming any resources. Since, Performance Insights is capturing thread information from "performance_schema.threads", the PI console displays this query "SET @slave_uuid= ?" as being executed and consuming resources on the instance.
It doesn't really affect instance performance and is safe to be ignored. If you wish to remove it, take logical dump of the database and restore it to an RDS MySQL version not mentioned in the above list.

[1] PSI thread info not getting updated after statement execution - https://bugs.mysql.com/bug.php?id=99039

Hope this helps!

• Dhanraj

Edited by: DhanrajAtAWS on Oct 23, 2020 10:47 AM