MySQL :: NDB Cluster Internals

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

2.39 DUMP 2301

Code: 2301
Symbol: LqhDumpAllScanRec
Kernel Block: DBLQH

Description. Dump all scan records to the cluster log.

Sample Output. Only the first few scan records printed to the log for a single data node are shown here.

2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6: LQH: Dump all ScanRecords - size: 514
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6: Dblqh::ScanRecord[1]: state=0, type=0, complStatus=0, scanNodeId=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  apiBref=0x2f40006, scanAccPtr=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  copyptr=-256, ailen=6, complOps=0, concurrOps=16
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  errCnt=0, schV=1
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  stpid=0, flag=2, lhold=0, lmode=0, num=134
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  relCount=16, TCwait=0, TCRec=2, KIflag=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  LcpScan=1  RowId(0:0)
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6: Dblqh::ScanRecord[2]: state=0, type=0, complStatus=0, scanNodeId=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  apiBref=0x0, scanAccPtr=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  copyptr=0, ailen=0, complOps=0, concurrOps=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  errCnt=0, schV=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  stpid=0, flag=0, lhold=0, lmode=0, num=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  relCount=0, TCwait=0, TCRec=0, KIflag=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  LcpScan=0  RowId(0:0)
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6: Dblqh::ScanRecord[3]: state=0, type=0, complStatus=0, scanNodeId=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  apiBref=0x0, scanAccPtr=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  copyptr=0, ailen=0, complOps=0, concurrOps=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  errCnt=0, schV=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  stpid=0, flag=0, lhold=0, lmode=0, num=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  relCount=0, TCwait=0, TCRec=0, KIflag=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  LcpScan=0  RowId(0:0)
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6: Dblqh::ScanRecord[4]: state=0, type=0, complStatus=0, scanNodeId=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  apiBref=0x0, scanAccPtr=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  copyptr=0, ailen=0, complOps=0, concurrOps=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  errCnt=0, schV=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  stpid=0, flag=0, lhold=0, lmode=0, num=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  relCount=0, TCwait=0, TCRec=0, KIflag=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  LcpScan=0  RowId(0:0)
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6: Dblqh::ScanRecord[5]: state=0, type=0, complStatus=0, scanNodeId=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  apiBref=0x0, scanAccPtr=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  copyptr=0, ailen=0, complOps=0, concurrOps=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  errCnt=0, schV=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  stpid=0, flag=0, lhold=0, lmode=0, num=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  relCount=0, TCwait=0, TCRec=0, KIflag=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  LcpScan=0  RowId(0:0)
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6: Dblqh::ScanRecord[6]: state=0, type=0, complStatus=0, scanNodeId=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  apiBref=0x0, scanAccPtr=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  copyptr=0, ailen=0, complOps=0, concurrOps=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  errCnt=0, schV=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  stpid=0, flag=0, lhold=0, lmode=0, num=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  relCount=0, TCwait=0, TCRec=0, KIflag=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  LcpScan=0  RowId(0:0)
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6: Dblqh::ScanRecord[7]: state=0, type=0, complStatus=0, scanNodeId=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  apiBref=0x0, scanAccPtr=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  copyptr=0, ailen=0, complOps=0, concurrOps=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  errCnt=0, schV=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  stpid=0, flag=0, lhold=0, lmode=0, num=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  relCount=0, TCwait=0, TCRec=0, KIflag=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  LcpScan=0  RowId(0:0)
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6: Dblqh::ScanRecord[8]: state=0, type=0, complStatus=0, scanNodeId=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  apiBref=0x0, scanAccPtr=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  copyptr=0, ailen=0, complOps=0, concurrOps=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  errCnt=0, schV=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  stpid=0, flag=0, lhold=0, lmode=0, num=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  relCount=0, TCwait=0, TCRec=0, KIflag=0
2014-10-15 12:40:00 [MgmtSrvr] INFO     -- Node 6:  LcpScan=0  RowId(0:0)
...

Additional Information. This DUMP code should be used sparingly if at all on an NDB Cluster in production, since hundreds or even thousands of scan records may be created on even a relatively small cluster that is not under load. For this reason, it is often preferable to print a single scan record using DUMP 2300.

The first line provides the total number of scan records dumped for this data node.

PREV HOME UP NEXT