Documentation Home
MySQL NDB Cluster 7.5
Related Documentation Download this Excerpt

7.10.42 The ndbinfo threads Table

The threads table provides information about threads running in the NDB kernel.

The following table provides information about the columns in the threads table. For each column, the table shows the name, data type, and a brief description. Additional information can be found in the notes following the table.

Table 7.58 Columns of the threads table

Column Name Type Description
node_id integer ID of the node where the thread is running
thr_no integer Thread ID (specific to this node)
thread_name string Thread name (type of thread)
thread_description string Thread (type) description

Sample output from a 2-node example cluster, including thread descriptions, is shown here:

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)

This table was added in NDB 7.5.2.


User Comments
Sign Up Login You must be logged in to post a comment.