Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 36.3Mb
PDF (A4) - 36.3Mb
PDF (RPM) - 36.2Mb
HTML Download (TGZ) - 10.4Mb
HTML Download (Zip) - 10.4Mb
HTML Download (RPM) - 9.2Mb
Man Pages (TGZ) - 224.6Kb
Man Pages (Zip) - 332.7Kb
Info (Gzip) - 3.3Mb
Info (Zip) - 3.3Mb
Excerpts from this Manual

20.5.14.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.