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