Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 39.2Mb
PDF (A4) - 39.3Mb
PDF (RPM) - 38.5Mb
HTML Download (TGZ) - 10.9Mb
HTML Download (Zip) - 11.0Mb
HTML Download (RPM) - 9.6Mb
Man Pages (TGZ) - 223.4Kb
Man Pages (Zip) - 332.3Kb
Info (Gzip) - 3.6Mb
Info (Zip) - 3.6Mb
Excerpts from this Manual 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.

Table 21.316 Columns of the table_fragments table

Column Name Type Description
node_id integer Node ID (DIH master)
table_id integer Table ID
partition_id integer Partition ID
fragment_id integer Fragment ID (same as partition ID unless table is fully replicated)
partition_order integer Order of fragment in partition
log_part_id integer Log part ID of fragment
no_of_replicas integer Number of replicas
current_primary integer Current primary node ID
preferred_primary integer Preferred primary node ID
current_first_backup integer Current first backup node ID
current_second_backup integer Current second backup node ID
current_third_backup integer Current third backup node ID
num_alive_replicas integer Current number of live replicas
num_dead_replicas integer Current number of dead replicas
num_lcp_replicas integer Number of replicas remaining to be checkpointed

The table_fragments table was added in NDB 7.5.4.