Code | Symbol | Kernel Block(s) |
data_node_id 2550
transaction_filter + |
--- |
--- |
Description.
Dumps all transaction from data node
data_node_id
meeting the
conditions established by the transaction filter or filters
specified.
Sample Output. Dump all transactions on node 2 which have been inactive for 30 seconds or longer:
ndb_mgm> 2 DUMP 2550 4 30
2006-10-09 13:16:49 [MgmSrvr] INFO -- Node 2: Starting dump of transactions
2006-10-09 13:16:49 [MgmSrvr] INFO -- Node 2: TRX[123]: API: 5(0x8035) transid: 0x31c 0x3500500 inactive: 42s state:
2006-10-09 13:16:49 [MgmSrvr] INFO -- Node 2: End of transaction dump
Additional Information. The following values may be used for transaction filters. The filter value must be followed by one or more node IDs or, in the case of the last entry in the table, by the time in seconds that transactions have been inactive:
Value | Filter |
---|---|
1 | API node ID |
2 | 2 transaction IDs, defining a range of transactions |
4 | time transactions inactive (seconds) |
This command was added in MySQL Cluster NDB 6.1.12 and MySQL Cluster NDB 6.2.2.