MySQL 8.0 参考手册 / 第 23 章 MySQL NDB Cluster 8.0 / 23.6 NDB Cluster的管理 / 23.6.15 ndbinfo:NDB 集群信息数据库 /
21.6.15.42 ndbinfo 线程表
该threads
表提供有关在NDB
内核中运行的线程的信息。
该threads
表包含以下列:
node_id
运行线程的节点ID
thr_no
线程 ID(特定于此节点)
thread_name
线程名称(线程类型)
thread_description
线程(类型)说明
笔记
来自 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)
此表是在 NDB 7.5.2 中添加的。