-
-
Save fennb/869edc4c00b0d9664e13 to your computer and use it in GitHub Desktop.
BDB JE stats sample
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
------------------------------------- | |
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