An event report reported in the event logs has the following format:
09:19:30 2005-07-24 [NDB] INFO -- Node 4 Start phase 4 completed
This section discusses all reportable events, ordered by category and severity level within each category.
In the event descriptions, GCP and LCP mean “Global Checkpoint” and “Local Checkpoint”, respectively.
These events are associated with connections between Cluster nodes.
|data nodes connected||8||Data nodes connected|
|data nodes disconnected||8||Data nodes disconnected|
|Communication closed||8||SQL node or data node connection closed|
|Communication opened||8||SQL node or data node connection opened|
The logging messages shown here are associated with checkpoints.
|LCP stopped in calc keep GCI||0||LCP stopped|
|Local checkpoint fragment completed||11||LCP on a fragment has been completed|
|Global checkpoint completed||10||GCP finished|
|Global checkpoint started||9||Start of GCP: REDO log is written to disk|
|Local checkpoint completed||8||LCP completed normally|
|Local checkpoint started||7||Start of LCP: data written to disk|
|Report undo log blocked||7||UNDO logging blocked; buffer near overflow|
The following events are generated in response to the startup of a node or of the cluster and of its success or failure. They also provide information relating to the progress of the startup process, including information concerning logging activities.
|Internal start signal received STTORRY||15||Blocks received after completion of restart|
|Undo records executed||15|
|New REDO log started||10||GCI keep |
|New log started||10||Log part |
|Node has been refused for inclusion in the cluster||8||Node cannot be included in cluster due to misconfiguration, inability to establish communication, or other problem|
|data node neighbors||8||Shows neighboring data nodes|
|data node start phase ||4||A data node start phase has been completed|
|Node has been successfully included into the cluster||3||Displays the node, managing node, and dynamic ID|
|data node start phases initiated||1||NDB Cluster nodes starting|
|data node all start phases completed||1||NDB Cluster nodes started|
|data node shutdown initiated||1||Shutdown of data node has commenced|
|data node shutdown aborted||1||Unable to shut down data node normally|
The following events are generated when restarting a node and relate to the success or failure of the node restart process.
|Node failure phase completed||8||Reports completion of node failure phases|
|Node has failed, node state was ||8||Reports that a node has failed|
|Report arbitrator results||2||There are eight different possible results for arbitration attempts:
|Completed copying a fragment||10|
|Completed copying of dictionary information||8|
|Completed copying distribution information||8|
|Starting to copy fragments||8|
|Completed copying all fragments||8|
|GCP takeover started||7|
|GCP takeover completed||7|
|LCP takeover started||7|
|LCP takeover completed (state = ||7|
|Report whether an arbitrator is found or not||6||There are seven different possible outcomes when seeking an arbitrator:
The following events are of a statistical nature. They provide information such as numbers of transactions and other operations, amount of data sent or received by individual nodes, and memory usage.
|Report job scheduling statistics||9||Mean internal job scheduling statistics|
|Sent number of bytes||9||Mean number of bytes sent to node |
|Received # of bytes||9||Mean number of bytes received from node |
|Report transaction statistics||8||Numbers of: transactions, commits, reads, simple reads, writes, concurrent operations, attribute information, and aborts|
|Report operations||8||Number of operations|
|Report table create||7|
|Memory usage||5||Data and index memory usage (80%, 90%, and 100%)|
These events relate to Cluster errors and warnings. The presence of one or more of these generally indicates that a major malfunction or failure has occurred.
|Dead due to missed heartbeat||8||Node |
|Missed heartbeats||8||Node |
|General warning events||2|
These events provide general information about the state of the cluster and activities associated with Cluster maintenance, such as logging and heartbeat transmission.
|Sent heartbeat||12||Heartbeat sent to node |
|Create log bytes||11||Log part, log file, MB|
|General information events||2|
Sent heartbeat events are available only if MySQL Cluster was