Documentation Home
MySQL Cluster API Developer Guide
Download this Manual
PDF (US Ltr) - 5.0Mb
PDF (A4) - 5.0Mb
EPUB - 1.9Mb
HTML Download (TGZ) - 1.9Mb
HTML Download (Zip) - 1.9Mb


8.2.31 DUMP 2301

Code Symbol Kernel Block(s)
2301 LqhDumpAllScanRec 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 a MySQL 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.


User Comments
Sign Up Login You must be logged in to post a comment.