Movatterモバイル変換

table_id

The table' unique ID

database_name

Name of the database containing the table

table_name

Name of the table

status

The table status; one ofNew,Changed,Retrieved,Invalid, orAltered. (SeeObject::Status, for more information about object status values.)

attributes

Number of table attributes

primary_key_cols

Number of columns in the table's primary key

primary_key

A comma-separated list of the columns in the table's primary key

storage

Type of storage used by the table; one ofmemory,disk, ordefault

logging

Whether logging is enabled for this table

dynamic

1 if the table is dynamic, otherwise0; the table is considered dynamic iftable->getForceVarPart() is true, or if at least one table column is dynamic

read_backup

1 if read from any replica (READ_BACKUP option is enabled for this table, otherwise0; seeSection 15.1.21.12, “Setting NDB Comment Options”)

fully_replicated

1 ifFULLY_REPLICATED is enabled for this table (each data node in the cluster has a complete copy of the table),0 if not; seeSection 15.1.21.12, “Setting NDB Comment Options”

checksum

If this table uses a checksum, the value in this column is1; if not, it is0

row_size

The amount of data, in bytes that can be stored in one row, not including any blob data stored separately in blob tables; seeTable::getRowSizeInBytes(), in the API documentation, for more information

min_rows

Minimum number of rows, as used for calculating partitions; seeTable::getMinRows(), in the API documentation, for more information

max_rows

Maximum number of rows, as used for calculating partitions; seeTable::getMaxRows(), in the API documentation, for more information

tablespace

ID of the tablespace to which the table belongs, if any; this is0, if the table does not use data on disk

fragment_type

The table's fragment type; one ofSingle,AllSmall,AllMedium,AllLarge,DistrKeyHash,DistrKeyLin,UserDefined,unused, orHashMapPartition; for more information, seeObject::FragmentType, in the NDB API documentation

hash_map

The hash map used by the table

fragments

Number of table fragments

partitions

Number of partitions used by the table

partition_balance

Type of partition balance used, if any; one ofFOR_RP_BY_NODE,FOR_RA_BY_NODE,FOR_RP_BY_LDM,FOR_RA_BY_LDM,FOR_RA_BY_LDM_X_2,FOR_RA_BY_LDM_X_3, orFOR_RA_BY_LDM_X_4; seeSection 15.1.21.12, “Setting NDB Comment Options”

contains_GCI

1 if the table includes a global checkpoint index, otherwise0

single_user_mode

Type of access allowed to the table when single user mode is in effect; one oflocked,read_only, orread_write; these are equivalent to the valuesSingleUserModeLocked,SingleUserModeReadOnly, andSingleUserModeReadWrite, respectively, of theTable::SingleUserMode type in the NDB API

force_var_part

This is1 iftable->getForceVarPart() is true for this table, and0 if it is not

GCI_bits

Used in testing

author_bits

Used in testing