Debian Codegraph @

mysql-test/suite/perfschema/r/threads_innodb.result

raw
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