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

23.5.14.53 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 8.0.23介绍了设置任何一个的可能性threadconfig.争论主要的或者代表在为0时保持另一个,在这种情况下,线程名称是main_rep它的描述是主和代表线程、模式、分布、代理块和异步复制处理。也可以从NDB 8.0.23开始设置这两个参数主要的代表为0,在这种情况下,结果线程的名称在该表中显示为main_rep_recv,它的描述是主要,rep和recv线程,架构,分发,代理块和异步复制处理和处理接收和轮询以进行新接收