Better diagnostics when starting ndb nodes?

Question

I have an ubuntu linux server that uses mysql cluster 7.2.5 x64.

Whenever I start an ndb node and check with ndb_mgm -e show, it stays in "starting" state for a long time. When I use top to check the process it takes 70-90% CPU which means it's doing something.

Is there a way to check what it's doing and estimate when it's going to finish?

Answer 1

You can view what is going on with "ndb_mgm -e 'N report eventlog'" where N is the data node's nodeid. This won't necessarily give you an estimate of when it will be finished but it can be used to verify that stuff is indeed going on and that the ndbd isn't just spinning indefinitely.

"ndb_mgm -e 'all status'" is also useful, as it will show you the current phase your data nodes are in. You can read more about phases here: http://dev.mysql.com/doc/refman/5.5/en/mysql-cluster-start-phases.html