#############################

一：没有开启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

 

 

 

 

 

######################################