• 首页
  • vue
  • TypeScript
  • JavaScript
  • scss
  • css3
  • html5
  • php
  • MySQL
  • redis
  • jQuery
  • ndb_print_frag_file —打印NDB片段列表文件的内容

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

    用法

    ndb_print_frag_file file_name
    

    file_name是群集片段列表文件的名称,与pattern匹配,其中是一个数字,范围在2-9之间(含2-9),可以在具有节点ID的数据节点的数据节点文件系统中的名为的目录中找到,其中是或。每个片段文件都包含属于每个表的片段的记录。有关群集片段文件的更多信息,请参见 NDB群集数据节点文件系统目录文件。SX.FragListXnodeidndb_nodeid_fs/DN/DBDIH/N12NDB

    ndb_print_backup_filendb_print_sys_filendb_print_schema_file一样(与大多数其他NDB打算在管理服务器主机上运行或连接到管理服务器的其他实用程序不同),ndb_print_frag_file必须在群集数据节点上运行,因为它访问数据节点文件系统直接。因为它不使用管理服务器,所以即使管理服务器未运行,甚至在群集已完全关闭的情况下,也可以使用此实用程序。

    附加选项

    没有。

    样本输出

    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