Mysql-server high cpu due to Binlog Dump

0

One of our production MySQL-server getting high CPU due to the below process in the master DB node.

mysql> SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST where time > 1 and COMMAND <>'Sleep' limit 3000;
+---------+------------+-------------------+------+-------------+---------+---------------------------------------------------------------+------+
| ID      | USER       | HOST              | DB   | COMMAND     | TIME    | STATE                                                         | INFO |
+---------+------------+-------------------+------+-------------+---------+---------------------------------------------------------------+------+
| 1486421 | slave_user | x.x.xx.xxx:xxxxx | NULL | Binlog Dump | 4625516 | Master has sent all binlog to slave; waiting for more updates | NULL |
+---------+------------+-------------------+------+-------------+---------+---------------------------------------------------------------+------+
1 row in set (0.00 sec)

IN the Slave node we observe below process

mysql> SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST where time > 1 and COMMAND <>'Sleep' limit 3000;
+-------+-------------+------+------+---------+---------+----------------------------------+------+
| ID    | USER        | HOST | DB   | COMMAND | TIME    | STATE                            | INFO |
+-------+-------------+------+------+---------+---------+----------------------------------+------+
| 37717 | system user |      | NULL | Connect | 4626149 | Waiting for master to send event | NULL |
+-------+-------------+------+------+---------+---------+----------------------------------+------+
1 row in set (0.00 sec)

Master-Slave status is working fine. Does anyone know what is the reason for this behavior, really appreciate your inputs on this?

Thank you

Rajith K

Posted 2019-05-19T07:29:20.920

Reputation: 1

No answers