ndb_desc provides a detailed description of one or more NDB tables.
Usage
ndb_desc -c connection_string tbl_name -d db_name [option]
ndb_desc -c connection_string index_name -d db_name -t tbl_name
Example
mantonik@mplclnode1 ~]$ ndb_desc -p -c mplclmgm1c:1186,mplclmgm2c:1186 -d masprod p_events
— p_events —
Version: 1
Fragment type: HashMapPartition
K Value: 6
Min load factor: 78
Max load factor: 80
Temporary table: no
Number of attributes: 8
Number of primary keys: 1
Length of frm data: 421
Row Checksum: 1
Row GCI: 1
SingleUserMode: 0
ForceVarPart: 1
FragmentCount: 2
ExtraRowGciBits: 0
ExtraRowAuthorBits: 0
TableStatus: Retrieved
HashMap: DEFAULT-HASHMAP-3840-2
— Attributes —
ID Decimal(22,0) PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
EV_TYPE Varchar(50;latin1_swedish_ci) NULL AT=SHORT_VAR ST=MEMORY
EV_DATE Datetime2(0) NULL AT=FIXED ST=MEMORY
EV_REF_1 Varchar(255;latin1_swedish_ci) NULL AT=SHORT_VAR ST=MEMORY
EV_REF_2 Varchar(255;latin1_swedish_ci) NULL AT=SHORT_VAR ST=MEMORY
EV_REF_3 Varchar(255;latin1_swedish_ci) NULL AT=SHORT_VAR ST=MEMORY
EV_REF_4 Varchar(255;latin1_swedish_ci) NULL AT=SHORT_VAR ST=MEMORY
CREATION_DATE Datetime2(0) NULL AT=FIXED ST=MEMORY
— Indexes —
PRIMARY KEY(ID) – UniqueHashIndex
idx_creatdate(CREATION_DATE) – OrderedIndex
PRIMARY(ID) – OrderedIndex
— Per partition info —
Partition Row count Commit count Frag fixed memory Frag varsized memory Extent_space Free extent_space
0 12560514 37383227 889389056 873791488 0 0
1 12495778 37433985 889192448 873824256 0 0
NDBT_ProgramExit: 0 – OK