SELECT * FROM `threads`
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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | thread/sql/main | BACKGROUND | NULL | NULL | NULL | NULL | NULL | 646041 | System lock | INTERNAL DDL LOG RECOVER IN PROGRESS | NULL | NULL | YES | |
2 | thread/innodb/io_handler_thread | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | YES | |
3 | thread/innodb/io_handler_thread | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | YES | |
4 | thread/innodb/io_handler_thread | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | YES | |
5 | thread/innodb/io_handler_thread | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | YES | |
6 | thread/innodb/io_handler_thread | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | YES | |
7 | thread/innodb/io_handler_thread | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | YES | |
8 | thread/innodb/io_handler_thread | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | YES | |
9 | thread/innodb/io_handler_thread | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | YES | |
10 | thread/innodb/io_handler_thread | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | YES | |
11 | thread/innodb/io_handler_thread | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | YES | |
13 | thread/innodb/srv_lock_timeout_thread | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | YES | |
14 | thread/innodb/srv_error_monitor_thread | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | YES | |
15 | thread/innodb/srv_monitor_thread | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | YES | |
16 | thread/innodb/srv_master_thread | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | YES | |
17 | thread/innodb/srv_purge_thread | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | YES | |
18 | thread/innodb/page_cleaner_thread | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | YES | |
19 | thread/sql/shutdown | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | YES | |
20 | thread/sql/con_sockets | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | YES | |
363008 | thread/sql/one_connection | FOREGROUND | 362988 | root | localhost | performance_schema | Query | 0 | Opening tables | SELECT (COUNT(`SCHEMA_NAME`) DIV 250) * 250 FROM `... | NULL | NULL | YES | |
363010 | thread/sql/one_connection | FOREGROUND | 362990 | root | localhost | NULL | Query | 1 | Opening tables | SELECT *, `TABLE_SCHEMA` ... | NULL | NULL | YES | |
363015 | thread/sql/one_connection | FOREGROUND | 362995 | root | localhost | test | Query | 1 | Opening tables | SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPUL... | NULL | NULL | YES | |
363017 | thread/sql/one_connection | FOREGROUND | 362997 | root | localhost | mysql | Query | 1 | Opening tables | SHOW TABLES LIKE 'columns_priv' | NULL | NULL | YES | |
363018 | thread/sql/one_connection | FOREGROUND | 362998 | root | localhost | NULL | Query | 0 | Opening tables | SHOW VARIABLES LIKE 'character_set_results' | NULL | NULL | YES | |
363019 | thread/sql/one_connection | FOREGROUND | 362999 | root | localhost | performance_schema | Query | 0 | Sending data | SELECT * FROM `threads` LIMIT 0, 25 | NULL | NULL | YES |