Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 38.1Mb
PDF (A4) - 38.1Mb
PDF (RPM) - 37.3Mb
HTML Download (TGZ) - 10.2Mb
HTML Download (Zip) - 10.3Mb
HTML Download (RPM) - 8.9Mb
Man Pages (TGZ) - 217.0Kb
Man Pages (Zip) - 329.9Kb
Info (Gzip) - 3.5Mb
Info (Zip) - 3.5Mb
Excerpts from this Manual 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.