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)