ndbinfo: The NDB Cluster Information Database • operation_type • state • tableid • fragmentid • client_node_id • client_block_ref • tc_node_id • tc_block_no • tc_block_instance Operation type (see text for possible values) Operation state (see text for possible values) Table ID Fragment ID Client node ID Client block reference Transaction coordinator node ID Transaction coordinator block number Transaction coordinator block instance The transaction ID is a unique 64-bit number which can be obtained using the NDB API’s getTransactionId()  method. (Currently, the MySQL Server does not expose the NDB API transaction ID of an ongoing transaction.) The  operation_type  column can take any one of the values  READ ,  READ-SH ,  READ-EX ,  INSERT , UPDATE ,  DELETE ,  WRITE ,  UNLOCK ,  REFRESH ,  SCAN ,  SCAN-SH ,  SCAN-EX , or  <unknown> . The  state  column can have any one of the values  ABORT_QUEUED ,  ABORT_STOPPED , COMMITTED ,  COMMIT_QUEUED ,  COMMIT_STOPPED ,  COPY_CLOSE_STOPPED , COPY_FIRST_STOPPED ,  COPY_STOPPED ,  COPY_TUPKEY ,  IDLE ,  LOG_ABORT_QUEUED , LOG_COMMIT_QUEUED ,  LOG_COMMIT_QUEUED_WAIT_SIGNAL ,  LOG_COMMIT_WRITTEN , LOG_COMMIT_WRITTEN_WAIT_SIGNAL ,  LOG_QUEUED ,  PREPARED ,  PREPARED_RECEIVED_COMMIT , SCAN_CHECK_STOPPED ,  SCAN_CLOSE_STOPPED ,  SCAN_FIRST_STOPPED ,  SCAN_RELEASE_STOPPED , SCAN_STATE_USED ,  SCAN_STOPPED ,  SCAN_TUPKEY ,  STOPPED ,  TC_NOT_CONNECTED ,  WAIT_ACC , WAIT_ACC_ABORT ,  WAIT_AI_AFTER_ABORT ,  WAIT_ATTR ,  WAIT_SCAN_AI ,  WAIT_TUP , WAIT_TUPKEYINFO ,  WAIT_TUP_COMMIT , or  WAIT_TUP_TO_ABORT . (If the MySQL Server is running with  ndbinfo_show_hidden  enabled, you can view this list of states by selecting from the  ndb $dblqh_tcconnect_state  table, which is normally hidden.) You can obtain the name of an  NDB  table from its table ID by checking the output of  ndb_show_tables . 4529 Notes