Show slave status consuming lot of CPU in Percona MySQL 8.0.26-17

Hi Folks,
We are using MySQL 5.7 in prod. I setup a MySQL 8.0.26-17 slave for one of the masters to evaluate it.

I saw it was consuming lot more CPU than other 5.7 slaves of the same master.

Linux perf tool showed it is spending lot of time in show_slave_status_cmd.

I changed to use “show replica status” and CPU usage of 8.0 slave dropped a lot.

Is this a bug? Has anyone else seen this? One would think “show replica status” is just an alias for “show slave status”?

Thanks,
Vamsi

Looks like a known bug.

https://bugs.mysql.com/bug.php?id=105924

2 Likes