Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.0Mb
PDF (A4) - 35.1Mb
Man Pages (TGZ) - 255.4Kb
Man Pages (Zip) - 360.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

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_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

Notes

The table_fragments table was added in NDB 7.5.4.