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.

Column NameTypeDescription
node_idintegerID of the node from which data is fetched (DIH master)
table_idintegerTable ID
fragment_idintegerFragment ID
initial_gciintegerInitial GCI for table
replica_node_idintegerID of node where replica is stored
is_lcp_ongoingintegerIs 1 if LCP is ongoing on this fragment, 0 otherwise
num_crashed_replicasintegerNumber of crashed replica instances
last_max_gci_startedintegerHighest GCI started in most recent LCP
last_max_gci_completedintegerHighest GCI completed in most recent LCP
last_lcp_idintegerID of most recent LCP
prev_lcp_idintegerID of previous LCP
prev_max_gci_startedintegerHighest GCI started in previous LCP
prev_max_gci_completedintegerHighest GCI completed in previous LCP
last_create_gciintegerLast Create GCI of last crashed replica instance
last_replica_gciintegerLast GCI of last crashed replica instance
is_replica_aliveinteger1 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.