mysql> select * from information_schema.processlist as p where p.command = 'Binlog Dump';
或
mysql> show slave hosts;(此方法需要在从服务启动时指定--report-host=HOSTNAME选项,此处HOSTNAME为任意名称。)
这个红色的黄海没有测试到,可能不好使,也可能是我们的配置不对。
MariaDB [(none)]> select * from information_schema.processlist as p where p.command = 'Binlog Dump'; +-------+------+-----------------+------+-------------+------+----------------+------+------------+-------+-----------+----------+-------------+---------------+----------+-------------+-------+ | ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO | TIME_MS | STAGE | MAX_STAGE | PROGRESS | MEMORY_USED | EXAMINED_ROWS | QUERY_ID | INFO_BINARY | TID | +-------+------+-----------------+------+-------------+------+-----------