MySQL 8.4 Release Notes
25.5.19 NDB 片段列表文件内容打印 — ndb_ print_frag_file
ndb_print_frag_file 从 NDB 片段列表文件中获取信息。它旨在帮助诊断数据节点重启问题。
ndb_print_frag_file file_name
file_name
是一个 NDB 片段列表文件的名称,该文件名匹配模式为 S
,其中 X
.FragListX
是 2-9 之间的数字,并且在数据节点文件系统中找到,位于具有节点 ID nodeid
的数据节点中,目录名为 ndb_
,其中 nodeid
_fs/DN
/DBDIH/N
是 1
或 2
。每个片段文件包含了每个 NDB 表的片段记录。关于 NDB 集群文件系统目录的更多信息,请参见NDB 集群数据节点文件系统目录。
类似于ndb_print_backup_file、ndb_print_sys_file和ndb_print_schema_file(与大多数其他NDB
实用工具不同,这些实用工具旨在在管理服务器主机上运行或连接到管理服务器),ndb_print_frag_file必须在集群数据节点上运行,因为它直接访问数据节点文件系统。由于它不使用管理服务器,因此该实用工具可以在管理服务器未运行时使用,即使整个集群已经完全关闭。
无。
$> 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