MySQL 5.0 Reference Manual  /  ...  /  ndb_desc — Describe NDB Tables

17.4.7 ndb_desc — Describe NDB Tables

ndb_desc provides a detailed description of one or more NDB tables.

Usage

ndb_desc -c connection_string tbl_name -d db_name [options]

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(11) NOT NULL AUTO_INCREMENT,
    name VARCHAR(20),

    PRIMARY KEY pk (id),
    UNIQUE KEY uk (name)
) ENGINE=NDBCLUSTER;

INSERT INTO fish VALUES
    ('','guppy'), ('','tuna'), ('','shark'),
    ('','manta ray'), ('','grouper'), ('','puffer');

Output from ndb_desc:

shell> ./ndb_desc -c localhost fish -d test -p
-- fish --
Version: 16777221
Fragment type: 5
K Value: 6
Min load factor: 78
Max load factor: 80
Temporary table: no
Number of attributes: 2
Number of primary keys: 1
Length of frm data: 268
Row Checksum: 1
Row GCI: 1
TableStatus: Retrieved
-- Attributes --
id Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
name Varchar(20;latin1_swedish_ci) NULL AT=SHORT_VAR ST=MEMORY

-- Indexes --
PRIMARY KEY(id) - UniqueHashIndex
uk(name) - OrderedIndex
PRIMARY(id) - OrderedIndex
uk$unique(name) - UniqueHashIndex

-- Per partition info --
Partition  Row count  Commit count  Frag fixed memory  Frag varsized memory
2          2          2             65536              327680
1          2          2             65536              327680
3          2          2             65536              327680

NDBT_ProgramExit: 0 - OK

Information about multiple tables can be obtained in a single invocation of ndb_desc by using their names, separated by spaces. All of the tables must be in the same database.

The Version column in the output contains the table's schema object version. For information about interpreting this value, see NDB Schema Object Versions.

The following table includes options that are specific to ndb_desc. Additional descriptions follow the table. For options common to most MySQL Cluster programs (including ndb_desc), see Section 17.4.20, “Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs”.

Table 17.32 This table describes command-line options for the ndb_desc program

Format Description Added or Removed

--database=dbname,

-d

Name of database containing table

All MySQL 5.0 based releases

--extra-partition-info,

-p

Display information about partitions

All MySQL 5.0 based releases

--retries=#,

-r

Number of times to retry the connection (once per second)

All MySQL 5.0 based releases

--unqualified,

-u

Use unqualified table names

All MySQL 5.0 based releases


  • --database=db_name, -d

    Specify the database in which the table should be found.

  • --extra-partition-info, -p

    Print additional information about the table's partitions.

  • --retries=#, -r

    Try to connect this many times before giving up. One connect attempt is made per second.

  • --unqualified, -u

    Use unqualified table names.


User Comments
Sign Up Login You must be logged in to post a comment.