Documentation Home
MySQL NDB Cluster 7.5
Related Documentation Download this Excerpt

7.10.39 The ndbinfo table_replicas Table

The table_replicas table provides information about the copying, distribution, and checkpointing of NDB table fragments and fragment replicas.

The following table provides information about the columns in table_replicas. For each column, the table shows the name, data type, and a brief description.

Table 7.55 Columns of the table_replicas table

Column Name Type Description
node_id integer ID of the node from which data is fetched (DIH master)
table_id integer Table ID
fragment_id integer Fragment ID
initial_gci integer Initial GCI for table
replica_node_id integer ID of node where replica is stored
is_lcp_ongoing integer Is 1 if LCP is ongoing on this fragment, 0 otherwise
num_crashed_replicas integer Number of crashed replica instances
last_max_gci_started integer Highest GCI started in most recent LCP
last_max_gci_completed integer Highest GCI completed in most recent LCP
last_lcp_id integer ID of most recent LCP
prev_lcp_id integer ID of previous LCP
prev_max_gci_started integer Highest GCI started in previous LCP
prev_max_gci_completed integer Highest GCI completed in previous LCP
last_create_gci integer Last Create GCI of last crashed replica instance
last_replica_gci integer Last GCI of last crashed replica instance
is_replica_alive integer 1 if this replica is alive, 0 otherwise

The table_replicas table was added in NDB 7.5.4.


User Comments
Sign Up Login You must be logged in to post a comment.