10bet网址
MySQL 5.7参考手册
相关文件10bet官方网站 下载本手册 从本手册中摘录

21.5.14.42 ndbinfo线程表

线程表提供有关运行中的线程的信息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中。