+--------+-------------+-----------------+------+-------------+--------+-----------------------------------------------------------------------+----------------------------------------------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +--------+-------------+-----------------+------+-------------+--------+-----------------------------------------------------------------------+----------------------------------------------------------+----------+ | 3 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 | | 1 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 | | 4 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 | | 2 | system user | | NULL | Daemon | NULL | InnoDB purge coordinator | NULL | 0.000 | | 5 | system user | | NULL | Daemon | NULL | InnoDB shutdown handler | NULL | 0.000 | | 10 | system user | | NULL | Slave_IO | 434844 | Waiting for master to send event | NULL | 0.000 | | 11 | system user | | db | Slave_SQL | 86098 | init | UPDATE `Table1` SET `a` = 'b', `c` = 'd' ... | 0.000 | | 773358 | root | localhost | db | Query | 16547 | Waiting for table metadata lock | LOCK TABLES `Table2` READ /*!32311 LOCAL */,`Table3` ... | 0.000 | | 773612 | user | localhost:36206 | db | Execute | 15255 | Waiting for table metadata lock | DELETE FROM `Table4` WHERE (`a`='b') | 0.000 | | 774375 | user | localhost:38238 | db | Execute | 11656 | Waiting for table metadata lock | DELETE FROM `Table4` WHERE (`a`='b') | 0.000 | | 775526 | user | localhost:41664 | db | Execute | 8053 | Waiting for table metadata lock | DELETE FROM `Table4` WHERE (`a`='b') | 0.000 | | 777224 | user | localhost:47378 | db | Execute | 4452 | Waiting for table metadata lock | DELETE FROM `Table4` WHERE (`a`='b') | 0.000 | | 779565 | user | localhost:54906 | db | Execute | 846 | Waiting for table metadata lock | DELETE FROM `Table4` WHERE (`a`='b') | 0.000 | | 779766 | root | localhost | NULL | Query | 0 | init | show processlist | 0.000 | | 779772 | repl | server2:49472 | NULL | Binlog Dump | 31 | Master has sent all binlog to slave; waiting for binlog to be updated | NULL | 0.000 | | 779771 | repl | server3:60002 | NULL | Binlog Dump | 31 | Master has sent all binlog to slave; waiting for binlog to be updated | NULL | 0.000 | | 779773 | repl | server4:46324 | NULL | Binlog Dump | 31 | Master has sent all binlog to slave; waiting for binlog to be updated | NULL | 0.000 | +--------+-------------+-----------------+------+-------------+--------+-----------------------------------------------------------------------+----------------------------------------------------------+----------+