Linux 查看MySQL 线程id

目录

• Linux 查看MySQL 线程id
  • ps -T -p <进程号>
    • • 查看MySQL的线程,证实了MySQL是一个单进程，多线程的服务

Linux 查看MySQL 线程id

ps -T -p <进程号>

查看MySQL的线程,证实了MySQL是一个单进程，多线程的服务

➜ bob@bob-pc  ~  ps -T -p  101740       
   PID    SPID TTY          TIME CMD
101740  101740 ?        00:00:01 mysqld
101740  101745 ?        00:00:00 mysqld
101740  101748 ?        00:00:02 mysqld
101740  101749 ?        00:00:02 mysqld
101740  101750 ?        00:00:02 mysqld
101740  101751 ?        00:00:02 mysqld
101740  101752 ?        00:00:02 mysqld
101740  101753 ?        00:00:02 mysqld
101740  101754 ?        00:00:02 mysqld
101740  101755 ?        00:00:02 mysqld
101740  101756 ?        00:00:02 mysqld
101740  101757 ?        00:00:02 mysqld
101740  101758 ?        00:00:02 mysqld
101740  101906 ?        00:00:01 mysqld
101740  101907 ?        00:00:04 mysqld
101740  101908 ?        00:00:00 mysqld
101740  101909 ?        00:00:02 mysqld
101740  101910 ?        00:00:01 mysqld
101740  101911 ?        00:00:00 mysqld
101740  101912 ?        00:00:00 mysqld
101740  101913 ?        00:00:00 mysqld
101740  101914 ?        00:00:00 mysqld
101740  101915 ?        00:00:00 mysqld
101740  101916 ?        00:00:00 mysqld
101740  101917 ?        00:00:00 mysqld
101740  101951 ?        00:00:00 mysqld
101740  101952 ?        00:00:00 mysqld
101740  103734 ?        00:00:00 mysqld
101740 2030593 ?        00:00:00 mysqld
101740 2030596 ?        00:00:00 mysqld
101740 2030597 ?        00:00:00 mysqld
101740 2076782 ?        00:00:00 mysqld
101740 2076788 ?        00:00:00 mysqld
101740 2076793 ?        00:00:00 mysqld
101740 2076997 ?        00:00:00 mysqld
101740 2076999 ?        00:00:00 mysqld
101740 2077001 ?        00:00:00 mysqld
101740 2077005 ?        00:00:00 mysqld
101740 2077006 ?        00:00:00 mysqld
101740 2077009 ?        00:00:00 mysqld
101740 2077070 ?        00:00:00 mysqld
101740 2077072 ?        00:00:00 mysqld
101740 2077075 ?        00:00:00 mysqld
101740 2077076 ?        00:00:00 mysqld

MySQL的线程可以和表里面对应上，在MySQL5.7 performance_schema库threads 里面,可以得到以下的信息

 select THREAD_ID,NAME ,PROCESSLIST_ID from performance_schema.threads;

+-----------+----------------------------------------+----------------+
| THREAD_ID | NAME                                   | PROCESSLIST_ID |
+-----------+----------------------------------------+----------------+
|         1 | thread/sql/main                        |           NULL |
|         2 | thread/sql/thread_timer_notifier       |           NULL |
|         3 | thread/innodb/io_log_thread            |           NULL |
|         4 | thread/innodb/io_read_thread           |           NULL |
|         5 | thread/innodb/io_read_thread           |           NULL |
|         6 | thread/innodb/io_read_thread           |           NULL |
|         7 | thread/innodb/io_ibuf_thread           |           NULL |
|         8 | thread/innodb/io_read_thread           |           NULL |
|         9 | thread/innodb/io_write_thread          |           NULL |
|        10 | thread/innodb/page_cleaner_thread      |           NULL |
|        11 | thread/innodb/io_write_thread          |           NULL |
|        12 | thread/innodb/io_write_thread          |           NULL |
|        13 | thread/innodb/io_write_thread          |           NULL |
|        16 | thread/innodb/srv_lock_timeout_thread  |           NULL |
|        17 | thread/innodb/srv_error_monitor_thread |           NULL |
|        18 | thread/innodb/srv_monitor_thread       |           NULL |
|        19 | thread/innodb/srv_purge_thread         |           NULL |
|        20 | thread/innodb/srv_worker_thread        |           NULL |
|        21 | thread/innodb/srv_worker_thread        |           NULL |
|        22 | thread/innodb/srv_worker_thread        |           NULL |
|        23 | thread/innodb/srv_master_thread        |           NULL |
|        24 | thread/innodb/dict_stats_thread        |           NULL |
|        25 | thread/innodb/buf_dump_thread          |           NULL |
|        26 | thread/sql/signal_handler              |           NULL |
|        27 | thread/sql/compress_gtid_table         |              1 |
|      5045 | thread/sql/one_connection              |           5019 |
|      5046 | thread/sql/one_connection              |           5020 |
|        39 | thread/sql/one_connection              |             13 |
|      2042 | thread/sql/one_connection              |           2016 |
|      2043 | thread/sql/one_connection              |           2017 |
|      2044 | thread/sql/one_connection              |           2018 |
+-----------+----------------------------------------+----------------+