Documentation Home
MySQL 5.7 参考手册

21.6.15.42 ndbinfo 线程表

该threads表提供有关在NDB内核中运行的线程的信息。

该threads表包含以下列：

  • node_id

    运行线程的节点ID

  • thr_no

    线程 ID（特定于此节点）

  • thread_name

    线程名称（线程类型）

  • thread_description

    线程（类型）说明

笔记

来自 2 节点示例集群的示例输出（包括线程描述）如下所示： 

Press CTRL+C to copy
 
mysql> SELECT * FROM threads;
+---------+--------+-------------+------------------------------------------------------------------+
| node_id | thr_no | thread_name | thread_description                                               |
+---------+--------+-------------+------------------------------------------------------------------+
|       5 |      0 | main        | main thread, schema and distribution handling                    |
|       5 |      1 | rep         | rep thread, asynch replication and proxy block handling          |
|       5 |      2 | ldm         | ldm thread, handling a set of data partitions                    |
|       5 |      3 | recv        | receive thread, performing receive and polling for new receives |
|       6 |      0 | main        | main thread, schema and distribution handling                    |
|       6 |      1 | rep         | rep thread, asynch replication and proxy block handling          |
|       6 |      2 | ldm         | ldm thread, handling a set of data partitions                    |
|       6 |      3 | recv        | receive thread, performing receive and polling for new receives |
+---------+--------+-------------+------------------------------------------------------------------+
8 rows in set (0.01 sec)

此表是在 NDB 7.5.2 中添加的。