Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 37.4Mb
PDF (A4) - 37.4Mb
PDF (RPM) - 36.8Mb
HTML Download (TGZ) - 10.2Mb
HTML Download (Zip) - 10.2Mb
HTML Download (RPM) - 8.8Mb
Man Pages (TGZ) - 210.2Kb
Man Pages (Zip) - 318.3Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

20.5.10.37 The ndbinfo table_info Table

The table_info table provides information about logging, checkpointing, distribution, and storage options in effect for individual NDB tables.

The following table provides information about the columns in table_info. For each column, the table shows the name, data type, and a brief description.

Column NameTypeDescription
table_idintegerTable ID
logged_tableintegerWhether table is logged (1) or not (0)
row_contains_gciintegerWhether table rows contain GCI (1 true, 0 false)
row_contains_checksumintegerWhether table rows contain checksum (1 true, 0 false)
read_backupintegerIf backup replicas are read this is 1, otherwise 0
fully_replicatedintegerIf table is fully replicated this is 1, otherwise 0
storage_typestringTable storage type; one of MEMORY or DISK
hashmap_idintegerHashmap ID
partition_balancestringPartition balance (fragment count type) used for table; one of FOR_RP_BY_NODE, FOR_RA_BY_NODE, FOR_RP_BY_LDM, or FOR_RA_BY_LDM
create_gciintegerGCI in which table was created

The table_info table was added in NDB 7.5.4.


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