地方エンジニアの学習日記

興味ある技術の雑なメモだったりを書いてくブログ。たまに日記とガジェット紹介。

【MySQL】バックグラウンドスレッドを調べる

SELECT THREAD_ID,NAME FROM performance_schema.threads where TYPE = 'background';
+-----------+----------------------------------------+
| THREAD_ID | NAME                                   |
+-----------+----------------------------------------+
|         1 | thread/sql/main                        |
|         2 | thread/sql/thread_timer_notifier       |
|         3 | thread/innodb/io_ibuf_thread           |
|         4 | thread/innodb/io_log_thread            |
|         5 | thread/innodb/io_read_thread           |
|         6 | thread/innodb/io_read_thread           |
|         7 | thread/innodb/io_read_thread           |
|         8 | thread/innodb/io_read_thread           |
|         9 | thread/innodb/io_write_thread          |
|        10 | thread/innodb/io_write_thread          |
|        11 | thread/innodb/io_write_thread          |
|        12 | thread/innodb/io_write_thread          |
|        13 | thread/innodb/page_cleaner_thread      |
|        15 | thread/innodb/srv_lock_timeout_thread  |
|        16 | thread/innodb/srv_error_monitor_thread |
|        17 | thread/innodb/srv_monitor_thread       |
|        18 | thread/innodb/srv_master_thread        |
|        19 | thread/innodb/srv_purge_thread         |
|        20 | thread/innodb/buf_dump_thread          |
|        21 | thread/innodb/dict_stats_thread        |
|        22 | thread/sql/signal_handler              |
+-----------+----------------------------------------+