34 lines
2.6 KiB
Plaintext
34 lines
2.6 KiB
Plaintext
SELECT name, type, processlist_user, processlist_host, processlist_db,
|
|
processlist_command, processlist_state, processlist_info,
|
|
parent_thread_id, `role`, instrumented
|
|
FROM performance_schema.threads
|
|
WHERE name LIKE 'thread/innodb/%'
|
|
AND name NOT LIKE 'thread/innodb/trx\_recovery\_rollback\_thread'
|
|
GROUP BY name;
|
|
name type processlist_user processlist_host processlist_db processlist_command processlist_state processlist_info parent_thread_id role instrumented
|
|
thread/innodb/buf_dump_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES
|
|
thread/innodb/buf_resize_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES
|
|
thread/innodb/clone_gtid_thread BACKGROUND NULL NULL NULL NULL waiting for handler commit NULL NULL NULL YES
|
|
thread/innodb/dict_stats_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES
|
|
thread/innodb/fts_optimize_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES
|
|
thread/innodb/io_ibuf_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES
|
|
thread/innodb/io_log_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES
|
|
thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES
|
|
thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES
|
|
thread/innodb/log_checkpointer_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES
|
|
thread/innodb/log_closer_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES
|
|
thread/innodb/log_flush_notifier_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES
|
|
thread/innodb/log_flusher_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES
|
|
thread/innodb/log_write_notifier_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES
|
|
thread/innodb/log_writer_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES
|
|
thread/innodb/page_flush_coordinator_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES
|
|
thread/innodb/scn_history_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES
|
|
thread/innodb/srv_error_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES
|
|
thread/innodb/srv_file_purge_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES
|
|
thread/innodb/srv_gp_wait_timeout_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES
|
|
thread/innodb/srv_lock_timeout_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES
|
|
thread/innodb/srv_master_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES
|
|
thread/innodb/srv_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES
|
|
thread/innodb/srv_purge_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES
|
|
thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL YES
|