Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 37.4Mb
PDF (A4) - 37.4Mb
PDF (RPM) - 37.0Mb
EPUB - 10.6Mb
HTML Download (TGZ) - 10.3Mb
HTML Download (Zip) - 10.4Mb
HTML Download (RPM) - 9.0Mb
Eclipse Doc Plugin (TGZ) - 11.2Mb
Eclipse Doc Plugin (Zip) - 13.4Mb
Man Pages (TGZ) - 204.7Kb
Man Pages (Zip) - 311.8Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

20.5.10.34 The ndbinfo table_fragments Table

The table_fragments table provides information about the fragmentation, partitioning, distribution, and (internal) replication of NDB tables.

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

Column NameTypeDescription
node_idintegerNode ID (DIH master)
table_idintegerTable ID
partition_idintegerPartition ID
fragment_idintegerFragment ID (same as partition ID unless table is fully replicated)
partition_orderintegerOrder of fragment in partition
log_part_idintegerLog part ID of fragment
no_of_replicasintegerNumber of replicas
current_primaryintegerCurrent primary node ID
preferred_primaryintegerPreferred primary node ID
current_first_backupintegerCurrent first backup node ID
current_second_backupintegerCurrent second backup node ID
current_third_backupintegerCurrent third backup node ID
num_alive_replicasintegerCurrent number of live replicas
num_dead_replicasintegerCurrent number of dead replicas
num_lcp_replicasintegerNumber of replicas remaining to be checkpointed

The table_fragments table was added in NDB 7.5.4.


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