mysql> select * from performance_schema.threads where PROCESSLIST_STATE is not null or PROCESSLIST_ID=2163878 order by thread_id; +-----------+---------------------------------+------------+----------------+------------------+-----------------------+----------------+---------------------+------------------+-----------------------------------+---------------------------------------------------------------------------------------------------------------------------+------------------+------+--------------+---------+-----------------+--------------+----------------+------------------+-------------------+-----------------------+--------------+------------------+ | THREAD_ID | NAME | TYPE | PROCESSLIST_ID | PROCESSLIST_USER | PROCESSLIST_HOST | PROCESSLIST_DB | PROCESSLIST_COMMAND | PROCESSLIST_TIME | PROCESSLIST_STATE | PROCESSLIST_INFO | PARENT_THREAD_ID | ROLE | INSTRUMENTED | HISTORY | CONNECTION_TYPE | THREAD_OS_ID | RESOURCE_GROUP | EXECUTION_ENGINE | CONTROLLED_MEMORY | MAX_CONTROLLED_MEMORY | TOTAL_MEMORY | MAX_TOTAL_MEMORY | +-----------+---------------------------------+------------+----------------+------------------+-----------------------+----------------+---------------------+------------------+-----------------------------------+---------------------------------------------------------------------------------------------------------------------------+------------------+------+--------------+---------+-----------------+--------------+----------------+------------------+-------------------+-----------------------+--------------+------------------+ | 42 | thread/innodb/clone_gtid_thread | BACKGROUND | NULL | NULL | NULL | NULL | NULL | 514258 | waiting for handler commit | NULL | NULL | NULL | YES | YES | NULL | 2382179 | SYS_default | PRIMARY | 54465848 | 54465848 | 61785934 | 61789222 | | 47 | thread/sql/replica_sql | FOREGROUND | 6 | NULL | NULL | NULL | Query | 2606 | Waiting for replica mutex on exit | NULL | 1 | NULL | YES | YES | NULL | 2382187 | SYS_default | PRIMARY | 18720 | 39296 | 293982619282 | 293982661730 | | 48 | thread/sql/replica_io | FOREGROUND | 5 | NULL | NULL | NULL | Connect | 514257 | Waiting for source to send event | NULL | 1 | NULL | YES | YES | NULL | 2382186 | SYS_default | PRIMARY | 8480 | 8480 | 8419534 | 16446605 | | 50 | thread/sql/event_scheduler | FOREGROUND | 8 | event_scheduler | localhost | NULL | Daemon | 514257 | Waiting on empty queue | NULL | 1 | NULL | YES | YES | NULL | 2382189 | SYS_default | PRIMARY | 0 | 0 | 16665 | 16665 | | 57 | thread/sql/compress_gtid_table | FOREGROUND | 13 | NULL | NULL | NULL | Daemon | 514257 | Suspending | NULL | 1 | NULL | YES | YES | NULL | 2382196 | SYS_default | PRIMARY | 20576 | 20576 | 28372 | 29860 | | 2164016 | thread/sql/one_connection | FOREGROUND | 2163878 | NULL | NULL | NULL | Sleep | NULL | NULL | NULL | NULL | NULL | YES | YES | NULL | 2382353 | USR_default | PRIMARY | 8240 | 8240 | 98048 | 98048 | | 2169781 | thread/sql/one_connection | FOREGROUND | 2169643 | root | s7.[removed].com | NULL | Query | 2763 | init | show full processlist | NULL | NULL | YES | YES | SSL/TLS | 2382198 | USR_default | PRIMARY | 16480 | 16480 | 80379 | 112003 | | 2170115 | thread/sql/one_connection | FOREGROUND | 2169977 | root | localhost | NULL | Query | 2683 | init | show processlist | NULL | NULL | YES | YES | SSL/TLS | 3182179 | USR_default | PRIMARY | 8240 | 16480 | 73442 | 110862 | | 2170235 | thread/sql/one_connection | FOREGROUND | 2170097 | root | localhost | NULL | Query | 1195 | starting | kill connection 2163878 | NULL | NULL | YES | YES | SSL/TLS | 3182276 | USR_default | PRIMARY | 1067088 | 1098928 | 1159962 | 1191762 | | 2170254 | thread/sql/one_connection | FOREGROUND | 2170116 | root | localhost | NULL | Query | 0 | executing | select * from performance_schema.threads where PROCESSLIST_STATE is not null or PROCESSLIST_ID=2163878 order by thread_id | NULL | NULL | YES | YES | SSL/TLS | 3182348 | USR_default | PRIMARY | 39468 | 79312 | 248456 | 281256 | | 2170467 | thread/sql/one_connection | FOREGROUND | 2170329 | root | localhost | NULL | Query | 2606 | Killing replica | stop replica | NULL | NULL | YES | YES | SSL/TLS | 3182465 | USR_default | PRIMARY | 8240 | 16480 | 73442 | 110862 | +-----------+---------------------------------+------------+----------------+------------------+-----------------------+----------------+---------------------+------------------+-----------------------------------+---------------------------------------------------------------------------------------------------------------------------+------------------+------+--------------+---------+-----------------+--------------+----------------+------------------+-------------------+-----------------------+--------------+------------------+ 11 rows in set (0.00 sec)