1、操作系统进程ID
MySQL是一个单进程多线程的服务程序，其进程ID使用ps命令即可看到

ps aux | grep mysqld

2、操作系统线程ID与MySQL线程ID

mysql -uroot -p123456  #假设通过show processlist查到该用户连接ID为25
+----+------+-----------+-------+---------+------+-------+------------------+-----------+---------------+
| Id | User | Host      | db    | Command | Time | State | Info             | Rows_sent | Rows_examined |
+----+------+-----------+-------+---------+------+-------+------------------+-----------+---------------+
| 25 | root | localhost | mymgr | Query   |    0 | init  | show processlist |         0 |             0 |
+----+------+-----------+-------+---------+------+-------+------------------+-----------+---------------+

begin; select *,sleep(1000) from t1 for update;   #这个SQL会运行很长时间，方便观察

3、通过performance_schema.threads查看THREAD_OS_ID（MySQL 5.7之前没有该字段），该列记录了MySQL内部线程所对应的操作系统线程ID

SELECT * FROM threads WHERE PROCESSLIST_ID=25\G                   # 通过用户线程查询具体操作

*************************** 1. row ***************************
          THREAD_ID: 65                                           # MySQL内部线程ID
               NAME: thread/sql/one_connection
               TYPE: FOREGROUND
     PROCESSLIST_ID: 25  <-- MySQL连接ID
   PROCESSLIST_USER: root
   PROCESSLIST_HOST: localhost
     PROCESSLIST_DB: mymgr
PROCESSLIST_COMMAND: Query
   PROCESSLIST_TIME: 246
  PROCESSLIST_STATE: User sleep
   PROCESSLIST_INFO: select *,sleep(1000) from t1 for update      # 正在运行的SQL
   PARENT_THREAD_ID: NULL
               ROLE: NULL
       INSTRUMENTED: YES
            HISTORY: YES
    CONNECTION_TYPE: Socket
       THREAD_OS_ID: 58412                                        # 对应操作系统的线程ID
     RESOURCE_GROUP: USR_default

4、查看对应的系统线程

ps -Lef | grep 58412 
mysql    38801     1 58412  0   40 14:46 ?        00:00:00 /usr/local/GreatSQL-8.0.22/bin/mysqld --defaults-file=/mysql/data06/my.cnf

本站所有文章均为原创，转载请注明出处！小站维护不易，如果对您有所帮助，希望能点击一下站内广告，谢谢！