CODEWITHSUNDEEP
mysqlprocesslist
Suresh Kamrushi
Suresh Kamrushi

Reputation: 16086

what is mysql binlog dump in show processlist

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?

Upvotes: 6

Views: 20457

Answers (2)

bileckme
bileckme

Reputation: 104

Its a process that constantly runs on the master server needed for replication. You should generally ignore this process, it should be harmless.

Upvotes: 2

Suresh Kamrushi
Suresh Kamrushi

Reputation: 16086

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

Upvotes: 8

Related Questions