21.5.14.42 ndbinfo 线程 table
threads
table 提供有关在NDB
内核中运行的线程的信息。
threads
table 包含以下列:
node_id
运行线程的节点的 ID
thr_no
线程 ID(特定于此节点)
thread_name
线程名称(线程类型)
thread_description
线程(类型)描述
Notes
此处显示了一个 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)
该 table 是在 NDB 7.5.2 中添加的。