<span>Binlog Dump线程</span>
#############################
一：没有开启GTID的dump线程命令：Binlog Dump
root@xxx(information_schema) > select * from processlist where command='Binlog Dump'\G; *************************** 1. row *************************** ID: 1095759 USER: sync HOST: nnn:27826 DB: NULL COMMAND: Binlog Dump TIME: 2267423 STATE: Master has sent all binlog to slave; waiting for more updates INFO: NULL TIME_MS: 2267422977 ROWS_SENT: 0 ROWS_EXAMINED: 0 *************************** 2. row *************************** ID: 1095760 USER: sync HOST: zzz:30563 DB: NULL COMMAND: Binlog Dump TIME: 2267423 STATE: Master has sent all binlog to slave; waiting for more updates INFO: NULL TIME_MS: 2267422978 ROWS_SENT: 0 ROWS_EXAMINED: 0 *************************** 3. row *************************** ID: 1095761 USER: sync HOST: yyy:59281 DB: NULL COMMAND: Binlog Dump TIME: 2267423 STATE: Master has sent all binlog to slave; waiting for more updates INFO: NULL TIME_MS: 2267422980 ROWS_SENT: 0 ROWS_EXAMINED: 0 3 rows in set (0.01 sec) ERROR: No query specified Mon Dec 28 15:35:01 2020
二：开启GTID后的dump线程命令：Binlog Dump GTID
root@hhh(information_schema) > select * from processlist where command='Binlog Dump GTID'\G; *************************** 1. row *************************** ID: 41855 USER: sync HOST: rrr:39711 DB: NULL COMMAND: Binlog Dump GTID TIME: 452134 STATE: Master has sent all binlog to slave; waiting for more updates INFO: NULL TIME_MS: 452134692 ROWS_SENT: 0 ROWS_EXAMINED: 0 *************************** 2. row *************************** ID: 41868 USER: sync HOST: ggg:21249 DB: NULL COMMAND: Binlog Dump GTID TIME: 452100 STATE: Master has sent all binlog to slave; waiting for more updates INFO: NULL TIME_MS: 452099972 ROWS_SENT: 0 ROWS_EXAMINED: 0 6 rows in set (0.00 sec) ERROR: No query specified
######################################
