| 1 |
SELECT name, type, processlist_user, processlist_host, processlist_db, |
| 2 |
processlist_command, processlist_state, processlist_info, |
| 3 |
parent_thread_id, `role`, instrumented |
| 4 |
FROM performance_schema.threads |
| 5 |
WHERE name LIKE 'thread/innodb/%' |
| 6 |
AND name NOT LIKE 'thread/innodb/trx\_recovery\_rollback\_thread' |
| 7 |
AND name NOT LIKE 'thread/innodb/clone_gtid_thread' |
| 8 |
GROUP BY name; |
| 9 |
name type processlist_user processlist_host processlist_db processlist_command processlist_state processlist_info parent_thread_id role instrumented |
| 10 |
thread/innodb/buf_dump_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES |
| 11 |
thread/innodb/buf_resize_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES |
| 12 |
thread/innodb/dict_stats_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES |
| 13 |
thread/innodb/fts_optimize_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES |
| 14 |
thread/innodb/io_ibuf_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES |
| 15 |
thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES |
| 16 |
thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES |
| 17 |
thread/innodb/log_checkpointer_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES |
| 18 |
thread/innodb/log_files_governor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES |
| 19 |
thread/innodb/log_flush_notifier_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES |
| 20 |
thread/innodb/log_flusher_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES |
| 21 |
thread/innodb/log_write_notifier_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES |
| 22 |
thread/innodb/log_writer_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES |
| 23 |
thread/innodb/page_flush_coordinator_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES |
| 24 |
thread/innodb/srv_error_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES |
| 25 |
thread/innodb/srv_lock_timeout_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES |
| 26 |
thread/innodb/srv_master_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES |
| 27 |
thread/innodb/srv_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES |
| 28 |
thread/innodb/srv_purge_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES |
| 29 |
thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES |