如何在MySQL中查询OS线程id（LWP）？  

---

---

[root@LHRDB ~]# ps -Lf 16833  
UID        PID  PPID   LWP  C NLWP STIME TTY      STAT   TIME CMD  
mysql    16833 16666 16833  0   38 06:05 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 16834  0   38 06:05 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 16836  0   38 06:05 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 16837  0   38 06:05 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 16838  0   38 06:05 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 16839  0   38 06:05 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 16840  0   38 06:05 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 16841  0   38 06:05 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 16842  0   38 06:05 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 16843  0   38 06:05 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 16844  0   38 06:05 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 16845  0   38 06:05 ?        Sl     0:01 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 16846  0   38 06:05 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 16848  0   38 06:05 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 16849  0   38 06:05 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 16850  0   38 06:05 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 16851  0   38 06:05 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 16852  0   38 06:05 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 16853  0   38 06:05 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 16854  0   38 06:05 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 16855  0   38 06:05 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 16856  0   38 06:05 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 16857  0   38 06:05 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 16858  0   38 06:05 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 16859  0   38 06:05 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 16860  0   38 06:05 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 16861  0   38 06:05 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 18619  0   38 07:59 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 19060  0   38 09:56 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 19136  0   38 10:05 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 19193  0   38 10:33 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 19218  0   38 10:47 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 19219  0   38 10:47 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 19221  0   38 10:47 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 19222  0   38 10:47 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 19223  0   38 10:47 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 19230  0   38 10:49 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  
mysql    16833 16666 19231  0   38 10:49 ?        Sl     0:00 /var/lib/mysql57/mysql5719/bin/mysqld --basedir=/var/lib/mysql57/mysql5719 --datadir=/var/lib/mysql57/mysql5719/data --plugin-dir=/var/lib/mysql57/m  

mysql> SELECT a.THREAD_ID,
    -> a.NAME,
    -> a.TYPE,
    -> a.PROCESSLIST_ID,
    -> a.PROCESSLIST_USER,
    -> a.PROCESSLIST_HOST,
    -> a.PROCESSLIST_DB,
    -> a.PROCESSLIST_COMMAND,
    -> a.PROCESSLIST_TIME,
    -> a.CONNECTION_TYPE,
    -> a.THREAD_OS_ID
    -> FROM performance_schema.threads a
    -> where a.TYPE='FOREGROUND';
+-----------+--------------------------------+------------+----------------+------------------+------------------+--------------------+---------------------+------------------+-----------------+--------------+
| THREAD_ID | NAME                           | TYPE       | PROCESSLIST_ID | PROCESSLIST_USER | PROCESSLIST_HOST | PROCESSLIST_DB     | PROCESSLIST_COMMAND | PROCESSLIST_TIME | CONNECTION_TYPE | THREAD_OS_ID |
+-----------+--------------------------------+------------+----------------+------------------+------------------+--------------------+---------------------+------------------+-----------------+--------------+
|        27 | thread/sql/compress_gtid_table | FOREGROUND |              1 | NULL             | NULL             | NULL               | Daemon              |           154158 | NULL            |        16861 |
|        32 | thread/sql/one_connection      | FOREGROUND |              7 | root             | localhost        | NULL               | Sleep               |             1929 | Socket          |        19060 |
|        33 | thread/sql/one_connection      | FOREGROUND |              8 | root             | 192.168.59.1     | NULL               | Query               |                0 | TCP/IP          |        18619 |
|        35 | thread/sql/one_connection      | FOREGROUND |             10 | root             | 192.168.59.1     | NULL               | Sleep               |             4503 | TCP/IP          |        19218 |
|        36 | thread/sql/one_connection      | FOREGROUND |             11 | root             | 192.168.59.1     | sys                | Sleep               |             3962 | TCP/IP          |        19219 |
|        37 | thread/sql/one_connection      | FOREGROUND |             12 | root             | 192.168.59.1     | sys                | Sleep               |             4494 | TCP/IP          |        19221 |
|        38 | thread/sql/one_connection      | FOREGROUND |             13 | root             | 192.168.59.1     | sys                | Sleep               |             4476 | TCP/IP          |        19222 |
|        39 | thread/sql/one_connection      | FOREGROUND |             14 | root             | 192.168.59.1     | sys                | Sleep               |             4469 | TCP/IP          |        19223 |
|        40 | thread/sql/one_connection      | FOREGROUND |             15 | root             | 192.168.59.1     | sys                | Sleep               |             4370 | TCP/IP          |        19230 |
|        41 | thread/sql/one_connection      | FOREGROUND |             16 | root             | 192.168.59.1     | sys                | Sleep               |             4095 | TCP/IP          |        19231 |
|        42 | thread/sql/one_connection      | FOREGROUND |             17 | root             | 192.168.59.1     | sys                | Sleep               |             4004 | TCP/IP          |        19243 |
|        43 | thread/sql/one_connection      | FOREGROUND |             18 | root             | 192.168.59.1     | sys                | Sleep               |             3962 | TCP/IP          |        19246 |
|        44 | thread/sql/one_connection      | FOREGROUND |             19 | root             | 192.168.59.1     | performance_schema | Sleep               |             3914 | TCP/IP          |        19247 |
|        45 | thread/sql/one_connection      | FOREGROUND |             20 | root             | 192.168.59.1     | performance_schema | Sleep               |             3924 | TCP/IP          |        19248 |
|        46 | thread/sql/one_connection      | FOREGROUND |             21 | root             | 192.168.59.1     | performance_schema | Sleep               |             3921 | TCP/IP          |        19249 |
|        47 | thread/sql/one_connection      | FOREGROUND |             22 | root             | 192.168.59.1     | performance_schema | Sleep               |             3914 | TCP/IP          |        19252 |
|        48 | thread/sql/one_connection      | FOREGROUND |             23 | root             | 192.168.59.1     | performance_schema | Sleep               |             2237 | TCP/IP          |        19293 |
|        49 | thread/sql/one_connection      | FOREGROUND |             24 | root             | 192.168.59.1     | performance_schema | Sleep               |             2221 | TCP/IP          |        19295 |
|        50 | thread/sql/one_connection      | FOREGROUND |             25 | root             | 192.168.59.1     | sys                | Sleep               |               20 | TCP/IP          |        19304 |
|        51 | thread/sql/one_connection      | FOREGROUND |             26 | root             | 192.168.59.1     | sys                | Sleep               |               20 | TCP/IP          |        19305 |
+-----------+--------------------------------+------------+----------------+------------------+------------------+--------------------+---------------------+------------------+-----------------+--------------+
20 rows in set (0.00 sec)


mysql> SELECT a.THREAD_ID,
    -> a.NAME,
    -> a.TYPE,
    -> a.PROCESSLIST_ID,
    -> a.PROCESSLIST_USER,
    -> a.PROCESSLIST_HOST,
    -> a.PROCESSLIST_DB,
    -> a.PROCESSLIST_COMMAND,
    -> a.PROCESSLIST_TIME,
    -> a.CONNECTION_TYPE,
    -> a.THREAD_OS_ID
    -> FROM performance_schema.threads a
    -> where a.TYPE='FOREGROUND'
    -> and a.THREAD_OS_ID=19231;
+-----------+---------------------------+------------+----------------+------------------+------------------+----------------+---------------------+------------------+-----------------+--------------+
| THREAD_ID | NAME                      | TYPE       | PROCESSLIST_ID | PROCESSLIST_USER | PROCESSLIST_HOST | PROCESSLIST_DB | PROCESSLIST_COMMAND | PROCESSLIST_TIME | CONNECTION_TYPE | THREAD_OS_ID |
+-----------+---------------------------+------------+----------------+------------------+------------------+----------------+---------------------+------------------+-----------------+--------------+
|        41 | thread/sql/one_connection | FOREGROUND |             16 | root             | 192.168.59.1     | sys            | Sleep               |             4143 | TCP/IP          |        19231 |
+-----------+---------------------------+------------+----------------+------------------+------------------+----------------+---------------------+------------------+-----------------+--------------+
1 row in set (0.00 sec)


mysql>
   


mysql> select @@version;  
+-----------+  
| @@version |  
+-----------+  
| 5.7.19    |  
+-----------+  
 
    

©著作权归作者所有：来自51CTO博客作者小麦苗DB宝的原创作品，如需转载，请注明出处，否则将追究法律责任

更多相关文章

1. 如何让普通用户可以对DBA_SOURCE视图进行闪回查询？
2. 【故障|监听】TNS-12545、TNS-12560、TNS-00515和Linux Error: 1
3. 【MOS】Limitations of the Oracle Cost Based Optimizer (文档
4. 【MOS】Redundant Interconnect ora.cluster_interconnect.haip
5. 【MOS】Index Rebuild Is Hanging Or Taking Too Long (文档 ID
6. 小麦苗数据库巡检脚本，支持Oracle、MySQL、SQL Server和PG等数据
7. Redis 6.0 稳定版发布，支持多线程 IO
8. 多线程安全-iOS开发要注意咯!
9. 大数据成神之路-Java高级特性增强(锁)

随机推荐

1. Linux----------zabbix监控-应用实例
2. LINUX下搭建简单临时的WWW服务器
3. 转：——Windows和Linux进程间通信区别
4. Linux Socket 网络编程 (IBM网站)
5. centos系统安装redis4.0（单机）
6. 对linux字符设备的理解（整体架构）
7. 【嵌入式Linux学习七步曲之第五篇 Linux
8. 如何查看最近安装的rpms？
9. Uncompressing Linux... done, booting t
10. 小米随身WiFi，Linux下AP热点驱动（开源）