Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.3Mb
PDF (A4) - 40.4Mb
PDF (RPM) - 39.7Mb
HTML Download (TGZ) - 10.5Mb
HTML Download (Zip) - 10.5Mb
HTML Download (RPM) - 9.1Mb
Man Pages (TGZ) - 244.1Kb
Man Pages (Zip) - 349.3Kb
Info (Gzip) - 3.8Mb
Info (Zip) - 3.8Mb
Excerpts from this Manual

23.5.14.41 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_id

    Node ID (DIH master)

  • table_id

    Table ID

  • partition_id

    Partition ID

  • fragment_id

    Fragment ID (same as partition ID unless table is fully replicated)

  • partition_order

    Order of fragment in partition

  • log_part_id

    Log part ID of fragment

  • no_of_replicas

    Number of fragment replicas

  • current_primary

    Current primary node ID

  • preferred_primary

    Preferred primary node ID

  • current_first_backup

    Current first backup node ID

  • current_second_backup

    Current second backup node ID

  • current_third_backup

    Current third backup node ID

  • num_alive_replicas

    Current number of live fragment replicas

  • num_dead_replicas

    Current number of dead fragment replicas

  • num_lcp_replicas

    Number of fragment replicas remaining to be checkpointed