Skip to content

Instantly share code, notes, and snippets.

@fennb
Created June 12, 2012 07:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save fennb/869edc4c00b0d9664e13 to your computer and use it in GitHub Desktop.
Save fennb/869edc4c00b0d9664e13 to your computer and use it in GitHub Desktop.
BDB JE stats sample
-------------------------------------
I/O: Log file opens, fsyncs, reads, writes, cache misses.
bufferBytes=3,145,728
endOfLog=0x12/0x491ff65
nBytesReadFromWriteQueue=0
nBytesWrittenFromWriteQueue=0
nCacheMiss=880,605
nFSyncRequests=0
nFSyncTime=0
nFSyncTimeouts=0
nFSyncs=0
nFileOpens=22
nLogBuffers=3
nLogFSyncs=0
nNotResident=880,605
nOpenFiles=19
nRandomReadBytes=116,758,528
nRandomReads=57,011
nRandomWriteBytes=0
nRandomWrites=0
nReadsFromWriteQueue=0
nRepeatFaultReads=62,878
nSequentialReadBytes=1,960,272,114
nSequentialReads=895,860
nSequentialWriteBytes=0
nSequentialWrites=0
nTempBufferWrites=0
nWriteQueueOverflow=0
nWriteQueueOverflowFailures=0
nWritesFromWriteQueue=0
Cache: Current size, allocations, and eviction activity.
adminBytes=11,191
avgBatchCACHEMODE=0
avgBatchCRITICAL=0
avgBatchDAEMON=0
avgBatchEVICTORTHREAD=0
avgBatchMANUAL=0
cacheTotalBytes=461,080,151
dataBytes=457,922,960
lockBytes=272
nBINsEvictedCACHEMODE=0
nBINsEvictedCRITICAL=0
nBINsEvictedDAEMON=0
nBINsEvictedEVICTORTHREAD=0
nBINsEvictedMANUAL=0
nBINsFetch=3,980,084
nBINsFetchMiss=61,505
nBINsStripped=0
nBatchesCACHEMODE=0
nBatchesCRITICAL=0
nBatchesDAEMON=0
nBatchesEVICTORTHREAD=0
nBatchesMANUAL=0
nCachedBINs=61,846
nCachedUpperINs=1,889
nEvictPasses=0
nINCompactKey=3
nINNoTarget=8,425
nINSparseTarget=38,072
nLNsFetch=27,302,991
nLNsFetchMiss=817,216
nNodesEvicted=0
nNodesScanned=0
nNodesSelected=0
nRootNodesEvicted=0
nSharedCacheEnvironments=1
nThreadUnavailable=0
nUpperINsEvictedCACHEMODE=0
nUpperINsEvictedCRITICAL=0
nUpperINsEvictedDAEMON=0
nUpperINsEvictedEVICTORTHREAD=0
nUpperINsEvictedMANUAL=0
nUpperINsFetch=7,390,730
nUpperINsFetchMiss=1,878
requiredEvictBytes=0
sharedCacheTotalBytes=461,080,071
Cleaning: Frequency and extent of log file cleaning activity.
cleanerBackLog=0
correctedAvgLNSize=NaN
estimatedAvgLNSize=NaN
fileDeletionBacklog=0
nBINDeltasCleaned=0
nBINDeltasDead=0
nBINDeltasMigrated=0
nBINDeltasObsolete=0
nCleanerDeletions=0
nCleanerEntriesRead=0
nCleanerProbeRuns=0
nCleanerRuns=0
nClusterLNsProcessed=0
nINsCleaned=0
nINsDead=0
nINsMigrated=0
nINsObsolete=0
nLNQueueHits=0
nLNsCleaned=0
nLNsDead=0
nLNsLocked=0
nLNsMarked=0
nLNsMigrated=0
nLNsObsolete=0
nMarkLNsProcessed=0
nPendingLNsLocked=0
nPendingLNsProcessed=0
nRepeatIteratorReads=0
nToBeCleanedLNsProcessed=0
totalLogSize=1,876,669,971
Node Compression: Removal and compression of internal btree nodes.
cursorsBins=0
dbClosedBins=0
inCompQueueSize=0
nonEmptyBins=0
processedBins=0
splitBins=0
Checkpoints: Frequency and extent of checkpointing activity.
lastCheckpointEnd=0x12/0x491e1e8
lastCheckpointId=5
lastCheckpointStart=0x12/0x491dcba
nCheckpoints=0
nDeltaINFlush=0
nFullBINFlush=0
nFullINFlush=0
Environment: General environment wide statistics.
btreeRelatchesRequired=33,819
Locks: Locks held by data operations, latching contention on lock table.
nLatchAcquireNoWaitUnsuccessful=0
nLatchAcquiresNoWaitSuccessful=0
nLatchAcquiresNoWaiters=0
nLatchAcquiresSelfOwned=0
nLatchAcquiresWithContention=0
nLatchReleases=0
nOwners=2
nReadLocks=2
nRequests=27,416,888
nTotalLocks=2
nWaiters=0
nWaits=0
nWriteLocks=0
----------------
I/O: Log file opens, fsyncs, reads, writes, cache misses.
bufferBytes=3,145,728
endOfLog=0x12/0x49212b5
nBytesReadFromWriteQueue=0
nBytesWrittenFromWriteQueue=0
nCacheMiss=905,984
nFSyncRequests=0
nFSyncTime=0
nFSyncTimeouts=0
nFSyncs=0
nFileOpens=22
nLogBuffers=3
nLogFSyncs=0
nNotResident=905,984
nOpenFiles=19
nRandomReadBytes=168,345,600
nRandomReads=82,200
nRandomWriteBytes=0
nRandomWrites=0
nReadsFromWriteQueue=0
nRepeatFaultReads=88,049
nSequentialReadBytes=2,036,690,567
nSequentialReads=921,221
nSequentialWriteBytes=0
nSequentialWrites=0
nTempBufferWrites=0
nWriteQueueOverflow=0
nWriteQueueOverflowFailures=0
nWritesFromWriteQueue=0
Cache: Current size, allocations, and eviction activity.
adminBytes=11,191
avgBatchCACHEMODE=0
avgBatchCRITICAL=0
avgBatchDAEMON=0
avgBatchEVICTORTHREAD=0
avgBatchMANUAL=0
cacheTotalBytes=608,320,639
dataBytes=605,163,528
lockBytes=112
nBINsEvictedCACHEMODE=0
nBINsEvictedCRITICAL=0
nBINsEvictedDAEMON=0
nBINsEvictedEVICTORTHREAD=0
nBINsEvictedMANUAL=0
nBINsFetch=9,106,205
nBINsFetchMiss=86,870
nBINsStripped=0
nBatchesCACHEMODE=0
nBatchesCRITICAL=0
nBatchesDAEMON=0
nBatchesEVICTORTHREAD=0
nBatchesMANUAL=0
nCachedBINs=87,373
nCachedUpperINs=1,903
nEvictPasses=0
nINCompactKey=3
nINNoTarget=9,237
nINSparseTarget=53,537
nLNsFetch=62,792,403
nLNsFetchMiss=817,216
nNodesEvicted=0
nNodesScanned=0
nNodesSelected=0
nRootNodesEvicted=0
nSharedCacheEnvironments=1
nThreadUnavailable=0
nUpperINsEvictedCACHEMODE=0
nUpperINsEvictedCRITICAL=0
nUpperINsEvictedDAEMON=0
nUpperINsEvictedEVICTORTHREAD=0
nUpperINsEvictedMANUAL=0
nUpperINsFetch=16,851,599
nUpperINsFetchMiss=1,892
requiredEvictBytes=0
sharedCacheTotalBytes=608,320,639
Cleaning: Frequency and extent of log file cleaning activity.
cleanerBackLog=0
correctedAvgLNSize=NaN
estimatedAvgLNSize=NaN
fileDeletionBacklog=0
nBINDeltasCleaned=0
nBINDeltasDead=0
nBINDeltasMigrated=0
nBINDeltasObsolete=0
nCleanerDeletions=0
nCleanerEntriesRead=0
nCleanerProbeRuns=0
nCleanerRuns=0
nClusterLNsProcessed=0
nINsCleaned=0
nINsDead=0
nINsMigrated=0
nINsObsolete=0
nLNQueueHits=0
nLNsCleaned=0
nLNsDead=0
nLNsLocked=0
nLNsMarked=0
nLNsMigrated=0
nLNsObsolete=0
nMarkLNsProcessed=0
nPendingLNsLocked=0
nPendingLNsProcessed=0
nRepeatIteratorReads=0
nToBeCleanedLNsProcessed=0
totalLogSize=1,876,674,911
Node Compression: Removal and compression of internal btree nodes.
cursorsBins=0
dbClosedBins=0
inCompQueueSize=0
nonEmptyBins=0
processedBins=0
splitBins=0
Checkpoints: Frequency and extent of checkpointing activity.
lastCheckpointEnd=0x12/0x491e1e8
lastCheckpointId=5
lastCheckpointStart=0x12/0x491dcba
nCheckpoints=0
nDeltaINFlush=0
nFullBINFlush=0
nFullINFlush=0
Environment: General environment wide statistics.
btreeRelatchesRequired=51,894
Locks: Locks held by data operations, latching contention on lock table.
nLatchAcquireNoWaitUnsuccessful=0
nLatchAcquiresNoWaitSuccessful=0
nLatchAcquiresNoWaiters=0
nLatchAcquiresSelfOwned=0
nLatchAcquiresWithContention=0
nLatchReleases=0
nOwners=1
nReadLocks=1
nRequests=63,025,006
nTotalLocks=1
nWaiters=0
nWaits=0
nWriteLocks=0
-------------------------------------
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment