MySQL 5.7发行说明
这线程
表提供有关运行中的线程的信息NDB.
核心。
这线程
表包含以下列:
node_id.
线程运行的节点的id
thr_no.
线程ID(特定于此节点)
thread_name.
线程名称(线程类型)
thread_description.
线程(类型)描述
笔记
这里显示了来自2节点示例群集的示例输出,包括线程描述,如下所示:
mysql>从线程中选择*;+ --------- + -------- + --------------------------------------------------------------------------------------------+ |node_id |thr_no |thread_name |thread_description |+ --------- + -------- + --------------------------------------------------------------------------------------------+ |5 |0 |主要| 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中。