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

21.6.15.39 The ndbinfo table_replicas Table

Thetable_replicas table provides information about the copying, distribution, and checkpointing ofNDB table fragments and fragment replicas.

Thetable_replicas table contains the following columns:

  • node_id

    ID of the node from which data is fetched (DIH master)

  • table_id

    Table ID

  • fragment_id

    Fragment ID

  • initial_gci

    Initial GCI for table

  • replica_node_id

    ID of node where fragment replica is stored

  • is_lcp_ongoing

    Is 1 if LCP is ongoing on this fragment, 0 otherwise

  • num_crashed_replicas

    Number of crashed fragment replica instances

  • last_max_gci_started

    Highest GCI started in most recent LCP

  • last_max_gci_completed

    Highest GCI completed in most recent LCP

  • last_lcp_id

    ID of most recent LCP

  • prev_lcp_id

    ID of previous LCP

  • prev_max_gci_started

    Highest GCI started in previous LCP

  • prev_max_gci_completed

    Highest GCI completed in previous LCP

  • last_create_gci

    Last Create GCI of last crashed fragment replica instance

  • last_replica_gci

    Last GCI of last crashed fragment replica instance

  • is_replica_alive

    1 if this fragment replica is alive, 0 otherwise

Notes

Thetable_replicas table was added in NDB 7.5.4.