what is mysql binlog dump in show processlist

mysql processlist
Suresh Kamrushi picture Suresh Kamrushi · Nov 8, 2013 · Viewed 14.8k times · Source

When I did show processlist in mysql I got list of process. One of the process with binlog dump running from quit long time.
What is binlog dump? do I need to kill this. what happen if i kill this process?

Answer

Suresh Kamrushi picture Suresh Kamrushi · Nov 8, 2013

Generally we are doing show process when we are getting error too many connections, but in my case Mysql is not responding intermittently. So i thought of looking into the processes if there is any long running query, so that I can kill it. I got binlog dump under Command column in process list.

Command shows the type of command the thread is currently executing.

binlog dump is a thread on a master server for sending binary log contents to a slave server.

If need more information on different values of Command you can refer to:

For show process

Related questions

How can I stop a running MySQL query?

I connect to mysql from my Linux shell. Every now and then I run a SELECT query that is too big. It prints and prints and I already know this is not what I meant. I would like to stop …

Read More
how to customize `show processlist` in mysql?

I want to order by Time,but seems no way to do that ? mysql> show processlist; +--------+-------------+--------------------+------+---------+--------+----------------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +--------+-------------+--------------------+------+---------+--------+----------------------------------+…

Read More
SHOW PROCESSLIST in MySQL command: sleep

When I run SHOW PROCESSLIST in MySQL database, I get this output: mysql> show full processlist; +--------+------+-----------+--------+---------+-------+-------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +--------+------+-----------+-------+---------+-------+-------+…

Read More