Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 39.4Mb
PDF (A4) - 39.4Mb
PDF (RPM) - 38.7Mb
HTML Download (TGZ) - 11.1Mb
HTML Download (Zip) - 11.1Mb
HTML Download (RPM) - 9.8Mb
Man Pages (TGZ) - 213.4Kb
Man Pages (Zip) - 322.6Kb
Info (Gzip) - 3.6Mb
Info (Zip) - 3.6Mb
Excerpts from this Manual

21.5.10.32 The ndbinfo restart_info Table

The restart_info table contains information about node restart operations. Each entry in the table corresponds to a node restart status report in real time from a data node with the given node ID. Only the most recent report for any given node is shown.

The following table provides information about the columns in the restart_info table. For each column, the table shows the name, data type, and a brief description. Additional information can be found in the notes following the table.

Table 21.402 Columns of the restart_info table

Column Name Type Description
node_id integer Node ID in the cluster
node_restart_status VARCHAR(256) Node status; see text for values. Each of these corresponds to a possible value of node_restart_status_int.
node_restart_status_int integer Node status code; see text for values.
secs_to_complete_node_failure integer Time in seconds to complete node failure handling
secs_to_allocate_node_id integer Time in seconds from node failure completion to allocation of node ID
secs_to_include_in_heartbeat_protocol integer Time in seconds from allocation of node ID to inclusion in heartbeat protocol
secs_until_wait_for_ndbcntr_master integer Time in seconds from being included in heartbeat protocol until waiting for NDBCNTR master began
secs_wait_for_ndbcntr_master integer Time in seconds spent waiting to be accepted by NDBCNTR master for starting
secs_to_get_start_permitted integer Time in seconds elapsed from receiving of permission for start from master until all nodes have accepted start of this node
secs_to_wait_for_lcp_for_copy_meta_data integer Time in seconds spent waiting for LCP completion before copying meta data
secs_to_copy_meta_data integer Time in seconds required to copy metadata from master to newly starting node
secs_to_include_node integer Time in seconds waited for GCP and inclusion of all nodes into protocols
secs_starting_node_to_request_local_recovery integer Time in seconds that the node just starting spent waiting to request local recovery
secs_for_local_recovery integer Time in seconds required for local recovery by node just starting
secs_restore_fragments integer Time in seconds required to restore fragments from LCP files
secs_undo_disk_data integer Time in seconds required to execute undo log on disk data part of records
secs_exec_redo_log integer Time in seconds required to execute redo log on all restored fragments
secs_index_rebuild integer Time in seconds required to rebuild indexes on restored fragments
secs_to_synchronize_starting_node integer Time in seconds required to synchronize starting node from live nodes
secs_wait_lcp_for_restart integer Time in seconds required for LCP start and completion before restart was completed
secs_wait_subscription_handover integer Time in seconds spent waiting for handover of replication subscriptions
total_restart_secs integer Total number of seconds from node failure until node is started again

Defined values for node_restart_status_int and corresponding status names and messages (node_restart_status) are shown in the following table:

Table 21.403 Status codes and messages used in the restart_info table

Column Name Type Description
0 ALLOCATED_NODE_ID Allocated node id
1 INCLUDED_IN_HB_PROTOCOL Included in heartbeat protocol
2 NDBCNTR_START_WAIT Wait for NDBCNTR master to permit us to start
3 NDBCNTR_STARTED NDBCNTR master permitted us to start
4 START_PERMITTED All nodes permitted us to start
5 WAIT_LCP_TO_COPY_DICT Wait for LCP completion to start copying metadata
6 COPY_DICT_TO_STARTING_NODE Copying metadata to starting node
7 INCLUDE_NODE_IN_LCP_AND_GCP Include node in LCP and GCP protocols
8 LOCAL_RECOVERY_STARTED Restore fragments ongoing
9 COPY_FRAGMENTS_STARTED Synchronizing starting node with live nodes
10 WAIT_LCP_FOR_RESTART Wait for LCP to ensure durability
11 WAIT_SUMA_HANDOVER Wait for handover of subscriptions
12 RESTART_COMPLETED Restart completed
13 NODE_FAILED Node failed, failure handling in progress
14 NODE_FAILURE_COMPLETED Node failure handling completed
15 NODE_GETTING_PERMIT All nodes permitted us to start
16 NODE_GETTING_INCLUDED Include node in LCP and GCP protocols
17 NODE_GETTING_SYNCHED Synchronizing starting node with live nodes
18 NODE_GETTING_LCP_WAITED [none]
19 NODE_ACTIVE Restart completed
20 NOT_DEFINED_IN_CLUSTER [none]
21 NODE_NOT_RESTARTED_YET Initial state

Status numbers 0 through 12 apply on master nodes only; the remainder of those shown in the table apply to all restarting data nodes. Status numbers 13 and 14 define node failure states; 20 and 21 occur when no information about the restart of a given node is available.

See also Section 21.5.1, “Summary of NDB Cluster Start Phases”.


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.