Additional options that can be used with ndb_desc  are listed later in this section. 

## Sample Output 

MySQL table creation and population statements: 

USE test; CREATE TABLE fish ( id INT NOT NULL AUTO_INCREMENT, name VARCHAR(20) NOT NULL, length_mm INT NOT NULL, weight_gm INT NOT NULL, PRIMARY KEY pk (id), UNIQUE KEY uk (name) ) ENGINE=NDB; INSERT INTO fish VALUES (NULL, ’guppy’, 35, 2), (NULL, ’tuna’, 2500, 150000), (NULL, ’shark’, 3000, 110000), (NULL, ’manta ray’, 1500, 50000), (NULL, ’grouper’, 900, 125000), (NULL ,’puffer’, 250, 2500); 

Output from ndb_desc : 

shell> ./ndb_desc -c localhost fish -d test -p -- fish -- Version: 2 Fragment type: HashMapPartition K Value: 6 Min load factor: 78 Max load factor: 80 Temporary table: no Number of attributes: 4 Number of primary keys: 1 Length of frm data: 337 Max Rows: 0 Row Checksum: 1 Row GCI: 1 SingleUserMode: 0 ForceVarPart: 1 PartitionCount: 2 FragmentCount: 2 PartitionBalance: FOR_RP_BY_LDM ExtraRowGciBits: 0 ExtraRowAuthorBits: 0 TableStatus: Retrieved Table options: HashMap: DEFAULT-HASHMAP-3840-2 -- Attributes -- id Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY AUTO_INCR name Varchar(20;latin1_swedish_ci) NOT NULL AT=SHORT_VAR ST=MEMORY DYNAMIC length_mm Int NOT NULL AT=FIXED ST=MEMORY DYNAMIC weight_gm Int NOT NULL AT=FIXED ST=MEMORY DYNAMIC -- Indexes -- PRIMARY KEY(id) - UniqueHashIndex PRIMARY(id) - OrderedIndex uk(name) - OrderedIndex uk$unique(name) - UniqueHashIndex -- Per partition info -- Partition Row count Commit count Frag fixed memory Frag varsized memory Extent_space 0 2 2 32768 32768 0 1 4 4 32768 32768 0 NDBT_ProgramExit: 0 - OK 

