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


8.2.44 DUMP 2401

Code Symbol Kernel Block(s)
2401 AccDumpAllScanRec DBACC

Description.  Dumps all scan records for the node specified.

Sample Output. 

2014-10-15 13:52:06 [MgmtSrvr] INFO     -- Node 5: ACC: Dump all ScanRec - size: 514
2014-10-15 13:52:06 [MgmtSrvr] INFO     -- Node 5: Dbacc::ScanRec[1]: state=1, transid(0x0, 0x0)
2014-10-15 13:52:06 [MgmtSrvr] INFO     -- Node 5:  activeLocalFrag=0, nextBucketIndex=0
2014-10-15 13:52:06 [MgmtSrvr] INFO     -- Node 5:  scanNextfreerec=2 firstActOp=0 firstLockedOp=0, scanLastLockedOp=0 firstQOp=0 lastQOp=0
2014-10-15 13:52:06 [MgmtSrvr] INFO     -- Node 5:  scanUserP=0, startNoBuck=0, minBucketIndexToRescan=0, maxBucketIndexToRescan=0
2014-10-15 13:52:06 [MgmtSrvr] INFO     -- Node 5:  scanBucketState=0, scanLockHeld=0, userBlockRef=0, scanMask=0 scanLockMode=0
2014-10-15 13:52:06 [MgmtSrvr] INFO     -- Node 5: Dbacc::ScanRec[2]: state=1, transid(0x0, 0x0)
2014-10-15 13:52:06 [MgmtSrvr] INFO     -- Node 5:  activeLocalFrag=0, nextBucketIndex=0
2014-10-15 13:52:06 [MgmtSrvr] INFO     -- Node 5:  scanNextfreerec=3 firstActOp=0 firstLockedOp=0, scanLastLockedOp=0 firstQOp=0 lastQOp=0
2014-10-15 13:52:06 [MgmtSrvr] INFO     -- Node 5:  scanUserP=0, startNoBuck=0, minBucketIndexToRescan=0, maxBucketIndexToRescan=0
2014-10-15 13:52:06 [MgmtSrvr] INFO     -- Node 5:  scanBucketState=0, scanLockHeld=0, userBlockRef=0, scanMask=0 scanLockMode=0
2014-10-15 13:52:06 [MgmtSrvr] INFO     -- Node 5: Dbacc::ScanRec[3]: state=1, transid(0x0, 0x0)
2014-10-15 13:52:06 [MgmtSrvr] INFO     -- Node 5:  activeLocalFrag=0, nextBucketIndex=0
2014-10-15 13:52:06 [MgmtSrvr] INFO     -- Node 5:  scanNextfreerec=4 firstActOp=0 firstLockedOp=0, scanLastLockedOp=0 firstQOp=0 lastQOp=0
2014-10-15 13:52:06 [MgmtSrvr] INFO     -- Node 5:  scanUserP=0, startNoBuck=0, minBucketIndexToRescan=0, maxBucketIndexToRescan=0
2014-10-15 13:52:06 [MgmtSrvr] INFO     -- Node 5:  scanBucketState=0, scanLockHeld=0, userBlockRef=0, scanMask=0 scanLockMode=0

.
.
.

2014-10-15 13:52:06 [MgmtSrvr] INFO     -- Node 6: Dbacc::ScanRec[511]: state=1, transid(0x0, 0x0)
2014-10-15 13:52:06 [MgmtSrvr] INFO     -- Node 6:  activeLocalFrag=0, nextBucketIndex=0
2014-10-15 13:52:06 [MgmtSrvr] INFO     -- Node 6:  scanNextfreerec=512 firstActOp=0 firstLockedOp=0, scanLastLockedOp=0 firstQOp=0 lastQOp=0
2014-10-15 13:52:06 [MgmtSrvr] INFO     -- Node 6:  scanUserP=0, startNoBuck=0, minBucketIndexToRescan=0, maxBucketIndexToRescan=0
2014-10-15 13:52:06 [MgmtSrvr] INFO     -- Node 6:  scanBucketState=0, scanLockHeld=0, userBlockRef=0, scanMask=0 scanLockMode=0
2014-10-15 13:52:06 [MgmtSrvr] INFO     -- Node 6: Dbacc::ScanRec[512]: state=1, transid(0x0, 0x0)
2014-10-15 13:52:06 [MgmtSrvr] INFO     -- Node 6:  activeLocalFrag=0, nextBucketIndex=0
2014-10-15 13:52:06 [MgmtSrvr] INFO     -- Node 6:  scanNextfreerec=513 firstActOp=0 firstLockedOp=0, scanLastLockedOp=0 firstQOp=0 lastQOp=0
2014-10-15 13:52:06 [MgmtSrvr] INFO     -- Node 6:  scanUserP=0, startNoBuck=0, minBucketIndexToRescan=0, maxBucketIndexToRescan=0
2014-10-15 13:52:06 [MgmtSrvr] INFO     -- Node 6:  scanBucketState=0, scanLockHeld=0, userBlockRef=0, scanMask=0 scanLockMode=0
2014-10-15 13:52:06 [MgmtSrvr] INFO     -- Node 6: Dbacc::ScanRec[513]: state=1, transid(0x0, 0x0)
2014-10-15 13:52:06 [MgmtSrvr] INFO     -- Node 6:  activeLocalFrag=0, nextBucketIndex=0
2014-10-15 13:52:06 [MgmtSrvr] INFO     -- Node 6:  scanNextfreerec=-256 firstActOp=0 firstLockedOp=0, scanLastLockedOp=0 firstQOp=0 lastQOp=0
2014-10-15 13:52:06 [MgmtSrvr] INFO     -- Node 6:  scanUserP=0, startNoBuck=0, minBucketIndexToRescan=0, maxBucketIndexToRescan=0
2014-10-15 13:52:06 [MgmtSrvr] INFO     -- Node 6:  scanBucketState=0, scanLockHeld=0, userBlockRef=0, scanMask=0 scanLockMode=0

Additional Information.  Use this command with caution, as there may be a great many scans. If you want to dump a single scan record, given its record ID, see Section 8.2.43, “DUMP 2400”; for dumping all active scan records, see Section 8.2.45, “DUMP 2402”.


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