Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 37.9Mb
PDF (A4) - 37.9Mb
PDF (RPM) - 36.6Mb
HTML Download (TGZ) - 9.8Mb
HTML Download (Zip) - 9.9Mb
HTML Download (RPM) - 8.6Mb
Man Pages (TGZ) - 209.3Kb
Man Pages (Zip) - 318.6Kb
Info (Gzip) - 3.5Mb
Info (Zip) - 3.5Mb
Excerpts from this Manual

20.5.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 20.401 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.