threads 表格提供有關在 NDB 核心中執行的執行緒的資訊。

threads 表格包含下列欄位

注意事項

此處顯示來自 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)

也可以將 ThreadConfig 引數 main 或 rep 其中一個設定為 0，同時將另一個保持為 1，在此情況下，執行緒名稱為 main_rep，其描述為 main 和 rep 執行緒、結構描述、散佈、Proxy 區塊和非同步複寫處理。 您也可以將 main 和 rep 都設定為 0，在此情況下，產生的執行緒名稱在此表格中顯示為 main_rep_recv，其描述為 main、rep 和 recv 執行緒、結構描述、散佈、Proxy 區塊以及非同步複寫處理和處理接收及輪詢新接收。