Movatterモバイル変換

ndb_print_frag_file obtains information from a cluster fragment list file. It is intended for use in helping to diagnose issues with data node restarts.

Usage

ndb_print_frag_filefile_name

file_name is the name of a cluster fragment list file, which matches the patternSX.FragList, whereX is a digit in the range 2-9 inclusive, and are found in the data node file system of the data node having the node IDnodeid, in directories namedndb_nodeid_fs/DN/DBDIH/, whereN is1 or2. Each fragment file contains records of the fragments belonging to eachNDB table. For more information about cluster fragment files, seeNDB Cluster Data Node File System Directory.

Likendb_print_backup_file,ndb_print_sys_file, andndb_print_schema_file (and unlike most of the otherNDB utilities that are intended to be run on a management server host or to connect to a management server),ndb_print_frag_file must be run on a cluster data node, since it accesses the data node file system directly. Because it does not make use of the management server, this utility can be used when the management server is not running, and even when the cluster has been completely shut down.

Additional Options

None.

Sample Output

$> ndb_print_frag_file /usr/local/mysqld/data/ndb_3_fs/D1/DBDIH/S2.FragListFilename: /usr/local/mysqld/data/ndb_3_fs/D1/DBDIH/S2.FragList with size 8192noOfPages = 1 noOfWords = 182Table Data----------Num Frags: 2 NoOfReplicas: 2 hashpointer: 4294967040kvalue: 6 mask: 0x00000000 method: HashMapStorage 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 = 1LcpNo[0]: maxGciCompleted: 1 maxGciStarted: 2 lcpId: 1 lcpStatus: validLcpNo[1]: maxGciCompleted: 0 maxGciStarted: 0 lcpId: 0 lcpStatus: invalid-------Stored Replica----------Replica node is: 3 initialGci: 2 numCrashedReplicas = 0 nextLcpNo = 1LcpNo[0]: maxGciCompleted: 1 maxGciStarted: 2 lcpId: 1 lcpStatus: validLcpNo[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 = 1LcpNo[0]: maxGciCompleted: 1 maxGciStarted: 2 lcpId: 1 lcpStatus: validLcpNo[1]: maxGciCompleted: 0 maxGciStarted: 0 lcpId: 0 lcpStatus: invalid-------Stored Replica----------Replica node is: 2 initialGci: 2 numCrashedReplicas = 0 nextLcpNo = 1LcpNo[0]: maxGciCompleted: 1 maxGciStarted: 2 lcpId: 1 lcpStatus: validLcpNo[1]: maxGciCompleted: 0 maxGciStarted: 0 lcpId: 0 lcpStatus: invalid