MySQL :: NDB Cluster Internals

NDB Cluster Internals / NDB Cluster Management Client DUMP Commands / DUMP 7015

2.114 DUMP 7015

Code: 7015
Symbol: ---
Kernel Block: DBDIH

Description. Writes table fragment status output for NDB tables to the cluster log, in order of their table IDs. A starting table ID can optionally be specified, in which case tables having lower IDs than this are skipped; otherwise, status information for all NDB tables is included in the output.

Sample Invocation/Output. Invoking this command using the optional table ID argument gives the following output in the management client:

Press CTRL+C to copy
 
ndb_mgm> ALL DUMP 7015 5
Sending dump signal with data:
0x00001b67 0x00000005
Sending dump signal with data:
0x00001b67 0x00000005

This causes table 1 through table 5 to be skipped in the output written into the cluster log, as shown here:

Press CTRL+C to copy
 
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 5: Table 5: TabCopyStatus: 0 TabUpdateStatus: 0 TabLcpStatus: 3
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 5:  Fragment 0: noLcpReplicas==0  0(on 5)=12(Idle) 1(on 6)=12(Idle)
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 5:  Fragment 1: noLcpReplicas==0  0(on 5)=12(Idle) 1(on 6)=12(Idle)
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 5: Table 6: TabCopyStatus: 0 TabUpdateStatus: 0 TabLcpStatus: 3
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 5:  Fragment 0: noLcpReplicas==0  0(on 5)=0(Idle) 1(on 6)=0(Idle)
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 5:  Fragment 1: noLcpReplicas==0  0(on 5)=0(Idle) 1(on 6)=0(Idle)
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 5: Table 7: TabCopyStatus: 0 TabUpdateStatus: 0 TabLcpStatus: 3
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 5:  Fragment 0: noLcpReplicas==0  0(on 5)=12(Idle) 1(on 6)=12(Idle)
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 5:  Fragment 1: noLcpReplicas==0  0(on 5)=12(Idle) 1(on 6)=12(Idle)
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 5: Table 8: TabCopyStatus: 0 TabUpdateStatus: 0 TabLcpStatus: 3
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 5:  Fragment 0: noLcpReplicas==0  0(on 5)=12(Idle) 1(on 6)=12(Idle)
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 5:  Fragment 1: noLcpReplicas==0  0(on 5)=12(Idle) 1(on 6)=12(Idle)
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 5: Table 9: TabCopyStatus: 0 TabUpdateStatus: 0 TabLcpStatus: 3
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 5:  Fragment 0: noLcpReplicas==0  0(on 5)=12(Idle) 1(on 6)=12(Idle)
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 5:  Fragment 1: noLcpReplicas==0  0(on 5)=12(Idle) 1(on 6)=12(Idle)
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 5: Table 10: TabCopyStatus: 0 TabUpdateStatus: 0 TabLcpStatus: 3
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 5:  Fragment 0: noLcpReplicas==0  0(on 5)=12(Idle) 1(on 6)=12(Idle)
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 5:  Fragment 1: noLcpReplicas==0  0(on 5)=12(Idle) 1(on 6)=12(Idle)
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 5: Table 11: TabCopyStatus: 0 TabUpdateStatus: 0 TabLcpStatus: 3
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 5:  Fragment 0: noLcpReplicas==0  0(on 5)=12(Idle) 1(on 6)=12(Idle)
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 5:  Fragment 1: noLcpReplicas==0  0(on 5)=12(Idle) 1(on 6)=12(Idle)
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 5: Table 12: TabCopyStatus: 0 TabUpdateStatus: 0 TabLcpStatus: 3
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 5:  Fragment 0: noLcpReplicas==0  0(on 5)=0(Idle) 1(on 6)=0(Idle)
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 5:  Fragment 1: noLcpReplicas==0  0(on 5)=0(Idle) 1(on 6)=0(Idle)
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 6: Table 5: TabCopyStatus: 0 TabUpdateStatus: 0 TabLcpStatus: 3
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 6:  Fragment 0: noLcpReplicas==0  0(on 5)=12(Idle) 1(on 6)=12(Idle)
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 6:  Fragment 1: noLcpReplicas==0  0(on 5)=12(Idle) 1(on 6)=12(Idle)
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 6: Table 6: TabCopyStatus: 0 TabUpdateStatus: 0 TabLcpStatus: 3
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 6:  Fragment 0: noLcpReplicas==0  0(on 5)=0(Idle) 1(on 6)=0(Idle)
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 6:  Fragment 1: noLcpReplicas==0  0(on 5)=0(Idle) 1(on 6)=0(Idle)
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 6: Table 7: TabCopyStatus: 0 TabUpdateStatus: 0 TabLcpStatus: 3
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 6:  Fragment 0: noLcpReplicas==0  0(on 5)=12(Idle) 1(on 6)=12(Idle)
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 6:  Fragment 1: noLcpReplicas==0  0(on 5)=12(Idle) 1(on 6)=12(Idle)
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 6: Table 8: TabCopyStatus: 0 TabUpdateStatus: 0 TabLcpStatus: 3
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 6:  Fragment 0: noLcpReplicas==0  0(on 5)=12(Idle) 1(on 6)=12(Idle)
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 6:  Fragment 1: noLcpReplicas==0  0(on 5)=12(Idle) 1(on 6)=12(Idle)
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 6: Table 9: TabCopyStatus: 0 TabUpdateStatus: 0 TabLcpStatus: 3
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 6:  Fragment 0: noLcpReplicas==0  0(on 5)=12(Idle) 1(on 6)=12(Idle)
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 6:  Fragment 1: noLcpReplicas==0  0(on 5)=12(Idle) 1(on 6)=12(Idle)
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 6: Table 10: TabCopyStatus: 0 TabUpdateStatus: 0 TabLcpStatus: 3
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 6:  Fragment 0: noLcpReplicas==0  0(on 5)=12(Idle) 1(on 6)=12(Idle)
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 6:  Fragment 1: noLcpReplicas==0  0(on 5)=12(Idle) 1(on 6)=12(Idle)
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 6: Table 11: TabCopyStatus: 0 TabUpdateStatus: 0 TabLcpStatus: 3
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 6:  Fragment 0: noLcpReplicas==0  0(on 5)=12(Idle) 1(on 6)=12(Idle)
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 6:  Fragment 1: noLcpReplicas==0  0(on 5)=12(Idle) 1(on 6)=12(Idle)
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 6: Table 12: TabCopyStatus: 0 TabUpdateStatus: 0 TabLcpStatus: 3
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 6:  Fragment 0: noLcpReplicas==0  0(on 5)=0(Idle) 1(on 6)=0(Idle)
2019-07-31 11:47:29 [MgmtSrvr] INFO     -- Node 6:  Fragment 1: noLcpReplicas==0  0(on 5)=0(Idle) 1(on 6)=0(Idle)

Additional Information. Output provided by DUMP 7015 is the same as that provided by DUMP 7021, except that the latter includes only a single table specified by table ID. For more detailed information about the fields included in this output, see Section 2.120, “DUMP 7021”.

PREV HOME UP NEXT