• 首页
  • css3教程
  • html5教程
  • jQuery手册
  • vue手册
  • php手册
  • MySQL手册
  • apache手册
  • redis手册
  • ndbinfo线程表

    threads表提供了有关NDB内核中运行的线程的信息。

    下表提供有关表中各列的信息threads。该表为每一列显示名称,数据类型和简要说明。可以在表格后面的注释中找到其他信息。

    线程表的列

    栏名类型描述
    node_id整数运行线程的节点的ID
    thr_no整数线程ID(特定于此节点)
    thread_namestring线程名称(线程类型)
    thread_descriptionstring线程(类型)描述

    此处显示了一个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)