21.4.20 ndb_print_frag_file —打印 NDB 片段列 table 文件的内容

ndb_print_frag_file从群集片段列 table 文件中获取信息。它旨在用于帮助诊断数据节点重新启动的问题。

Usage

ndb_print_frag_file file_name

• file_name 是群集片段列 table 文件的名称，与模式SX.FragList匹配，其中 X *是 2-9(包括 2-9)范围内的数字，位于具有该节点的数据节点的数据节点文件系统中 ID * nodeid ，位于名为ndb_nodeid_fs/DN/DBDIH/的目录中，其中 N *是1或2。每个片段文件都包含属于每个NDBtable 的片段的记录。有关群集片段文件的更多信息，请参见NDB 群集数据节点文件系统目录。

像ndb_print_backup_file，ndb_print_sys_file和ndb_print_schema_file一样(并且不同于大多数其他NDBUtil 要在 Management 服务器主机上运行或连接到 Management 服务器)，ndb_print_frag_file必须在群集数据节点上运行，因为它访问数据节点文件系统直接。因为它不使用 Management 服务器，所以即使 Management 服务器未运行，甚至已完全关闭群集，也可以使用此 Util。

Additional Options

None.

Sample Output

shell> ndb_print_frag_file /usr/local/mysqld/data/ndb_3_fs/D1/DBDIH/S2.FragList
Filename: /usr/local/mysqld/data/ndb_3_fs/D1/DBDIH/S2.FragList with size 8192
noOfPages = 1 noOfWords = 182
Table Data
----------
Num Frags: 2 NoOfReplicas: 2 hashpointer: 4294967040
kvalue: 6 mask: 0x00000000 method: HashMap
Storage is on Logged and checkpointed, survives SR
------ Fragment with FragId: 0 --------
Preferred Primary: 2 numStoredReplicas: 2 numOldStoredReplicas: 0 distKey: 0 LogPartId: 0
-------Stored Replica----------
Replica node is: 2 initialGci: 2 numCrashedReplicas = 0 nextLcpNo = 1
LcpNo[0]: maxGciCompleted: 1 maxGciStarted: 2 lcpId: 1 lcpStatus: valid
LcpNo[1]: maxGciCompleted: 0 maxGciStarted: 0 lcpId: 0 lcpStatus: invalid
-------Stored Replica----------
Replica node is: 3 initialGci: 2 numCrashedReplicas = 0 nextLcpNo = 1
LcpNo[0]: maxGciCompleted: 1 maxGciStarted: 2 lcpId: 1 lcpStatus: valid
LcpNo[1]: maxGciCompleted: 0 maxGciStarted: 0 lcpId: 0 lcpStatus: invalid
------ Fragment with FragId: 1 --------
Preferred Primary: 3 numStoredReplicas: 2 numOldStoredReplicas: 0 distKey: 0 LogPartId: 1
-------Stored Replica----------
Replica node is: 3 initialGci: 2 numCrashedReplicas = 0 nextLcpNo = 1
LcpNo[0]: maxGciCompleted: 1 maxGciStarted: 2 lcpId: 1 lcpStatus: valid
LcpNo[1]: maxGciCompleted: 0 maxGciStarted: 0 lcpId: 0 lcpStatus: invalid
-------Stored Replica----------
Replica node is: 2 initialGci: 2 numCrashedReplicas = 0 nextLcpNo = 1
LcpNo[0]: maxGciCompleted: 1 maxGciStarted: 2 lcpId: 1 lcpStatus: valid
LcpNo[1]: maxGciCompleted: 0 maxGciStarted: 0 lcpId: 0 lcpStatus: invalid