ndbinfo线程表

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

下表提供有关表中各列的信息threads。该表为每一列显示名称，数据类型和简要说明。可以在表格后面的注释中找到其他信息。

线程表的列

栏名	类型	描述
node_id	整数	运行线程的节点的ID
thr_no	整数	线程ID（特定于此节点）
thread_name	string	线程名称（线程类型）
thread_description	string	线程（类型）描述

此处显示了一个2节点示例集群的示例输出，包括线程描述：

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)