+--------+-------------+-----------------+------+-------------+--------+-----------------------------------------------------------------------+----------------------------------------------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +--------+-------------+-----------------+------+-------------+--------+-----------------------------------------------------------------------+----------------------------------------------------------+----------+ | 1 | system user | | NULL | Daemon | NULL | InnoDB purge coordinator | NULL | 0.000 | | 2 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 | | 3 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 | | 4 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 | | 5 | system user | | NULL | Daemon | NULL | InnoDB shutdown handler | NULL | 0.000 | | 10 | system user | | NULL | Slave_IO | 249706 | Waiting for master to send event | NULL | 0.000 | | 11 | system user | | db | Slave_SQL | 63261 | Unlocking tables | UPDATE `Table1` SET `a` = 'b', `c` = 'd' ... | 0.000 | | 460889 | root | localhost | db | Query | 13501 | Waiting for table metadata lock | LOCK TABLES `Table2` READ /*!32311 LOCAL */,`Table3` ... | 0.000 | | 461075 | user | localhost:56162 | db | Execute | 12208 | Waiting for table metadata lock | DELETE FROM `Table3` WHERE (`a`='b') | 0.000 | | 465261 | repl | server2:37154 | NULL | Binlog Dump | 226 | Master has sent all binlog to slave; waiting for binlog to be updated | NULL | 0.000 | | 465262 | repl | server3:41614 | NULL | Binlog Dump | 226 | Master has sent all binlog to slave; waiting for binlog to be updated | NULL | 0.000 | | 465264 | repl | server4:42702 | NULL | Binlog Dump | 225 | Master has sent all binlog to slave; waiting for binlog to be updated | NULL | 0.000 | | ... | ... | ... | db | Execute | 22 | Waiting for table metadata lock | ... | 0.000 | +--------+-------------+-----------------+------+-------------+--------+-----------------------------------------------------------------------+----------------------------------------------------------+----------+