21.6.15.37 The ndbinfo table_fragments Table
The table_fragments table provides information about the fragmentation, partitioning, distribution, and (internal) replication of NDB tables.
The table_fragments table contains the following columns:
-
node_idNode ID (
DIHmaster) -
table_idTable ID
-
partition_idPartition ID
-
fragment_idFragment ID (same as partition ID unless table is fully replicated)
-
partition_orderOrder of fragment in partition
-
log_part_idLog part ID of fragment
-
no_of_replicasNumber of fragment replicas
-
current_primaryCurrent primary node ID
-
preferred_primaryPreferred primary node ID
-
current_first_backupCurrent first backup node ID
-
current_second_backupCurrent second backup node ID
-
current_third_backupCurrent third backup node ID
-
num_alive_replicasCurrent number of live fragment replicas
-
num_dead_replicasCurrent number of dead fragment replicas
-
num_lcp_replicasNumber of fragment replicas remaining to be checkpointed
Notes
The table_fragments table was added in NDB 7.5.4.
© 2025 Oracle
Licensed under the GPLv2 License.