Created
April 20, 2017 15:29
-
-
Save nbhatti/6bdaec34dea6da984d2d2773c6a99777 to your computer and use it in GitHub Desktop.
show engine tokudb status
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
TokuDB disk free space more than 10 percent of total file system space | |
TokuDB time of environment creation Thu Apr 13 20:15:02 2017 | |
TokuDB time of engine startup Mon Apr 17 14:24:08 2017 | |
TokuDB time now Thu Apr 20 16:29:03 2017 | |
TokuDB db opens 6574 | |
TokuDB db closes 6551 | |
TokuDB num open dbs now 23 | |
TokuDB max open dbs 25 | |
TokuDB period, in ms, that recovery log is automatically fsynced 0 | |
TokuDB dictionary inserts 5996397 | |
TokuDB dictionary inserts fail 0 | |
TokuDB dictionary deletes 1 | |
TokuDB dictionary deletes fail 0 | |
TokuDB dictionary updates 0 | |
TokuDB dictionary updates fail 0 | |
TokuDB dictionary broadcast updates 0 | |
TokuDB dictionary broadcast updates fail 0 | |
TokuDB dictionary multi inserts 48202335 | |
TokuDB dictionary multi inserts fail 0 | |
TokuDB dictionary multi deletes 644065 | |
TokuDB dictionary multi deletes fail 0 | |
TokuDB dictionary updates multi 276028022 | |
TokuDB dictionary updates multi fail 0 | |
TokuDB le: max committed xr 12 | |
TokuDB le: max provisional xr 2 | |
TokuDB le: expanded 0 | |
TokuDB le: max memsize 18226 | |
TokuDB le: size of leafentries before garbage collection (during message application) 37481643309 | |
TokuDB le: size of leafentries after garbage collection (during message application) 12919496005 | |
TokuDB le: size of leafentries before garbage collection (outside message application) 0 | |
TokuDB le: size of leafentries after garbage collection (outside message application) 0 | |
TokuDB checkpoint: period 60 | |
TokuDB checkpoint: footprint 0 | |
TokuDB checkpoint: last checkpoint began Thu Apr 20 16:28:08 2017 | |
TokuDB checkpoint: last complete checkpoint began Thu Apr 20 16:28:08 2017 | |
TokuDB checkpoint: last complete checkpoint ended Thu Apr 20 16:28:09 2017 | |
TokuDB checkpoint: time spent during checkpoint (begin and end phases) 2466 | |
TokuDB checkpoint: time spent during last checkpoint (begin and end phases) 1 | |
TokuDB checkpoint: last complete checkpoint LSN 165481875 | |
TokuDB checkpoint: checkpoints taken 4445 | |
TokuDB checkpoint: checkpoints failed 0 | |
TokuDB checkpoint: waiters now 0 | |
TokuDB checkpoint: waiters max 0 | |
TokuDB checkpoint: non-checkpoint client wait on mo lock 191 | |
TokuDB checkpoint: non-checkpoint client wait on cs lock 0 | |
TokuDB checkpoint: checkpoint begin time 2631355 | |
TokuDB checkpoint: long checkpoint begin time 0 | |
TokuDB checkpoint: long checkpoint begin count 0 | |
TokuDB checkpoint: checkpoint end time 2290736389 | |
TokuDB checkpoint: long checkpoint end time 0 | |
TokuDB checkpoint: long checkpoint end count 0 | |
TokuDB cachetable: miss 1968 | |
TokuDB cachetable: miss time 3340713 | |
TokuDB cachetable: prefetches 2484 | |
TokuDB cachetable: size current 29419484931 | |
TokuDB cachetable: size limit 51325018112 | |
TokuDB cachetable: size writing 0 | |
TokuDB cachetable: size nonleaf 297286359 | |
TokuDB cachetable: size leaf 29122198156 | |
TokuDB cachetable: size rollback 416 | |
TokuDB cachetable: size cachepressure 324181536 | |
TokuDB cachetable: size currently cloned data for checkpoint 0 | |
TokuDB cachetable: evictions 1302 | |
TokuDB cachetable: cleaner executions 288528 | |
TokuDB cachetable: cleaner period 1 | |
TokuDB cachetable: cleaner iterations 5 | |
TokuDB cachetable: number of waits on cache pressure 0 | |
TokuDB cachetable: time waiting on cache pressure 0 | |
TokuDB cachetable: number of long waits on cache pressure 0 | |
TokuDB cachetable: long time waiting on cache pressure 0 | |
TokuDB cachetable: client pool: number of threads in pool 24 | |
TokuDB cachetable: client pool: number of currently active threads in pool 0 | |
TokuDB cachetable: client pool: number of currently queued work items 0 | |
TokuDB cachetable: client pool: largest number of queued work items 2 | |
TokuDB cachetable: client pool: total number of work items processed 364845 | |
TokuDB cachetable: client pool: total execution time of processing work items 1050663 | |
TokuDB cachetable: cachetable pool: number of threads in pool 48 | |
TokuDB cachetable: cachetable pool: number of currently active threads in pool 0 | |
TokuDB cachetable: cachetable pool: number of currently queued work items 0 | |
TokuDB cachetable: cachetable pool: largest number of queued work items 11 | |
TokuDB cachetable: cachetable pool: total number of work items processed 7170 | |
TokuDB cachetable: cachetable pool: total execution time of processing work items 108458 | |
TokuDB cachetable: checkpoint pool: number of threads in pool 6 | |
TokuDB cachetable: checkpoint pool: number of currently active threads in pool 0 | |
TokuDB cachetable: checkpoint pool: number of currently queued work items 0 | |
TokuDB cachetable: checkpoint pool: largest number of queued work items 34 | |
TokuDB cachetable: checkpoint pool: total number of work items processed 58573 | |
TokuDB cachetable: checkpoint pool: total execution time of processing work items 2261402 | |
TokuDB locktree: memory size 0 | |
TokuDB locktree: memory size limit 6348518400 | |
TokuDB locktree: number of times lock escalation ran 0 | |
TokuDB locktree: time spent running escalation (seconds) 0.000000 | |
TokuDB locktree: latest post-escalation memory size 0 | |
TokuDB locktree: number of locktrees open now 25 | |
TokuDB locktree: number of pending lock requests 0 | |
TokuDB locktree: number of locktrees eligible for the STO 0 | |
TokuDB locktree: number of times a locktree ended the STO early 122 | |
TokuDB locktree: time spent ending the STO early (seconds) 37.181834 | |
TokuDB locktree: number of wait locks 0 | |
TokuDB locktree: time waiting for locks 0 | |
TokuDB locktree: number of long wait locks 0 | |
TokuDB locktree: long time waiting for locks 0 | |
TokuDB locktree: number of lock timeouts 0 | |
TokuDB locktree: number of waits on lock escalation 0 | |
TokuDB locktree: time waiting on lock escalation 0 | |
TokuDB locktree: number of long waits on lock escalation 0 | |
TokuDB locktree: long time waiting on lock escalation 0 | |
TokuDB ft: dictionary updates 0 | |
TokuDB ft: dictionary broadcast updates 0 | |
TokuDB ft: descriptor set 1 | |
TokuDB ft: messages ignored by leaf due to msn 90581004 | |
TokuDB ft: total search retries due to TRY_AGAIN 404560806 | |
TokuDB ft: searches requiring more tries than the height of the tree 7282441 | |
TokuDB ft: searches requiring more tries than the height of the tree plus three 6097977 | |
TokuDB ft: leaf nodes flushed to disk (not for checkpoint) 3057 | |
TokuDB ft: leaf nodes flushed to disk (not for checkpoint) (bytes) 406152704 | |
TokuDB ft: leaf nodes flushed to disk (not for checkpoint) (uncompressed bytes) 1761601181 | |
TokuDB ft: leaf nodes flushed to disk (not for checkpoint) (seconds) 0.192127 | |
TokuDB ft: nonleaf nodes flushed to disk (not for checkpoint) 1532 | |
TokuDB ft: nonleaf nodes flushed to disk (not for checkpoint) (bytes) 6320128 | |
TokuDB ft: nonleaf nodes flushed to disk (not for checkpoint) (uncompressed bytes) 18744002 | |
TokuDB ft: nonleaf nodes flushed to disk (not for checkpoint) (seconds) 0.017442 | |
TokuDB ft: leaf nodes flushed to disk (for checkpoint) 52123 | |
TokuDB ft: leaf nodes flushed to disk (for checkpoint) (bytes) 9615860224 | |
TokuDB ft: leaf nodes flushed to disk (for checkpoint) (uncompressed bytes) 59679897417 | |
TokuDB ft: leaf nodes flushed to disk (for checkpoint) (seconds) 4.189710 | |
TokuDB ft: nonleaf nodes flushed to disk (for checkpoint) 77594 | |
TokuDB ft: nonleaf nodes flushed to disk (for checkpoint) (bytes) 16229150208 | |
TokuDB ft: nonleaf nodes flushed to disk (for checkpoint) (uncompressed bytes) 89428122958 | |
TokuDB ft: nonleaf nodes flushed to disk (for checkpoint) (seconds) 6.863198 | |
TokuDB ft: uncompressed / compressed bytes written (leaf) 6.130654 | |
TokuDB ft: uncompressed / compressed bytes written (nonleaf) 5.509349 | |
TokuDB ft: uncompressed / compressed bytes written (overall) 5.746490 | |
TokuDB ft: nonleaf node partial evictions 0 | |
TokuDB ft: nonleaf node partial evictions (bytes) 0 | |
TokuDB ft: leaf node partial evictions 0 | |
TokuDB ft: leaf node partial evictions (bytes) 0 | |
TokuDB ft: leaf node full evictions 261 | |
TokuDB ft: leaf node full evictions (bytes) 37800 | |
TokuDB ft: nonleaf node full evictions 5 | |
TokuDB ft: nonleaf node full evictions (bytes) 980 | |
TokuDB ft: leaf nodes created 3454 | |
TokuDB ft: nonleaf nodes created 421 | |
TokuDB ft: leaf nodes destroyed 0 | |
TokuDB ft: nonleaf nodes destroyed 0 | |
TokuDB ft: bytes of messages injected at root (all trees) 22437596630 | |
TokuDB ft: bytes of messages flushed from h1 nodes to leaves 22284426287 | |
TokuDB ft: bytes of messages currently in trees (estimate) 153170343 | |
TokuDB ft: messages injected at root 432630072 | |
TokuDB ft: broadcast messages injected at root 0 | |
TokuDB ft: basements decompressed as a target of a query 0 | |
TokuDB ft: basements decompressed for prelocked range 0 | |
TokuDB ft: basements decompressed for prefetch 0 | |
TokuDB ft: basements decompressed for write 0 | |
TokuDB ft: buffers decompressed as a target of a query 165 | |
TokuDB ft: buffers decompressed for prelocked range 238 | |
TokuDB ft: buffers decompressed for prefetch 0 | |
TokuDB ft: buffers decompressed for write 748 | |
TokuDB ft: pivots fetched for query 629 | |
TokuDB ft: pivots fetched for query (bytes) 18534400 | |
TokuDB ft: pivots fetched for query (seconds) 0.009820 | |
TokuDB ft: pivots fetched for prefetch 2484 | |
TokuDB ft: pivots fetched for prefetch (bytes) 81395712 | |
TokuDB ft: pivots fetched for prefetch (seconds) 0.047172 | |
TokuDB ft: pivots fetched for write 27 | |
TokuDB ft: pivots fetched for write (bytes) 443904 | |
TokuDB ft: pivots fetched for write (seconds) 0.000285 | |
TokuDB ft: basements fetched as a target of a query 11578 | |
TokuDB ft: basements fetched as a target of a query (bytes) 136746496 | |
TokuDB ft: basements fetched as a target of a query (seconds) 0.052886 | |
TokuDB ft: basements fetched for prelocked range 17257 | |
TokuDB ft: basements fetched for prelocked range (bytes) 207099392 | |
TokuDB ft: basements fetched for prelocked range (seconds) 0.054769 | |
TokuDB ft: basements fetched for prefetch 139051 | |
TokuDB ft: basements fetched for prefetch (bytes) 1699767296 | |
TokuDB ft: basements fetched for prefetch (seconds) 0.492530 | |
TokuDB ft: basements fetched for write 142568 | |
TokuDB ft: basements fetched for write (bytes) 1348021760 | |
TokuDB ft: basements fetched for write (seconds) 0.441469 | |
TokuDB ft: buffers fetched as a target of a query 132 | |
TokuDB ft: buffers fetched as a target of a query (bytes) 70656 | |
TokuDB ft: buffers fetched as a target of a query (seconds) 0.000415 | |
TokuDB ft: buffers fetched for prelocked range 118 | |
TokuDB ft: buffers fetched for prelocked range (bytes) 63488 | |
TokuDB ft: buffers fetched for prelocked range (seconds) 0.000045 | |
TokuDB ft: buffers fetched for prefetch 0 | |
TokuDB ft: buffers fetched for prefetch (bytes) 0 | |
TokuDB ft: buffers fetched for prefetch (seconds) 0.000000 | |
TokuDB ft: buffers fetched for write 2519 | |
TokuDB ft: buffers fetched for write (bytes) 1368064 | |
TokuDB ft: buffers fetched for write (seconds) 0.001445 | |
TokuDB ft: leaf compression to memory (seconds) 1299.797316 | |
TokuDB ft: leaf serialization to memory (seconds) 93.164829 | |
TokuDB ft: leaf decompression to memory (seconds) 67.477536 | |
TokuDB ft: leaf deserialization to memory (seconds) 13.037317 | |
TokuDB ft: nonleaf compression to memory (seconds) 2074.181647 | |
TokuDB ft: nonleaf serialization to memory (seconds) 207.054707 | |
TokuDB ft: nonleaf decompression to memory (seconds) 0.009454 | |
TokuDB ft: nonleaf deserialization to memory (seconds) 0.010842 | |
TokuDB ft: promotion: roots split 12 | |
TokuDB ft: promotion: leaf roots injected into 298667 | |
TokuDB ft: promotion: h1 roots injected into 7816299 | |
TokuDB ft: promotion: injections at depth 0 41927291 | |
TokuDB ft: promotion: injections at depth 1 159001847 | |
TokuDB ft: promotion: injections at depth 2 227867754 | |
TokuDB ft: promotion: injections at depth 3 13350487 | |
TokuDB ft: promotion: injections lower than depth 3 0 | |
TokuDB ft: promotion: stopped because of a nonempty buffer 250051854 | |
TokuDB ft: promotion: stopped at height 1 4790 | |
TokuDB ft: promotion: stopped because the child was locked or not at all in memory 3698 | |
TokuDB ft: promotion: stopped because the child was not fully in memory 34 | |
TokuDB ft: promotion: stopped anyway, after locking the child 6403 | |
TokuDB ft: basement nodes deserialized with fixed-keysize 298630 | |
TokuDB ft: basement nodes deserialized with variable-keysize 11831 | |
TokuDB ft: promotion: succeeded in using the rightmost leaf shortcut 10294176 | |
TokuDB ft: promotion: tried the rightmost leaf shorcut but failed (out-of-bounds) 170 | |
TokuDB ft: promotion: tried the rightmost leaf shorcut but failed (child reactive) 46763 | |
TokuDB ft: cursor skipped deleted leaf entries 545480903616 | |
TokuDB ft flusher: total nodes potentially flushed by cleaner thread 22991 | |
TokuDB ft flusher: height-one nodes flushed by cleaner thread 17400 | |
TokuDB ft flusher: height-greater-than-one nodes flushed by cleaner thread 5591 | |
TokuDB ft flusher: nodes cleaned which had empty buffers 43 | |
TokuDB ft flusher: nodes dirtied by cleaner thread 37731 | |
TokuDB ft flusher: max bytes in a buffer flushed by cleaner thread 3852642 | |
TokuDB ft flusher: min bytes in a buffer flushed by cleaner thread 43 | |
TokuDB ft flusher: total bytes in buffers flushed by cleaner thread 13709001155 | |
TokuDB ft flusher: max workdone in a buffer flushed by cleaner thread 3049712 | |
TokuDB ft flusher: min workdone in a buffer flushed by cleaner thread 0 | |
TokuDB ft flusher: total workdone in buffers flushed by cleaner thread 2455860929 | |
TokuDB ft flusher: times cleaner thread tries to merge a leaf 332 | |
TokuDB ft flusher: cleaner thread leaf merges in progress 0 | |
TokuDB ft flusher: cleaner thread leaf merges successful 323 | |
TokuDB ft flusher: nodes dirtied by cleaner thread leaf merges 101 | |
TokuDB ft flusher: total number of flushes done by flusher threads or cleaner threads 383850 | |
TokuDB ft flusher: number of in memory flushes 383850 | |
TokuDB ft flusher: number of flushes that read something off disk 0 | |
TokuDB ft flusher: number of flushes that triggered another flush in child 365 | |
TokuDB ft flusher: number of flushes that triggered 1 cascading flush 358 | |
TokuDB ft flusher: number of flushes that triggered 2 cascading flushes 7 | |
TokuDB ft flusher: number of flushes that triggered 3 cascading flushes 0 | |
TokuDB ft flusher: number of flushes that triggered 4 cascading flushes 0 | |
TokuDB ft flusher: number of flushes that triggered 5 cascading flushes 0 | |
TokuDB ft flusher: number of flushes that triggered over 5 cascading flushes 0 | |
TokuDB ft flusher: leaf node splits 3095 | |
TokuDB ft flusher: nonleaf node splits 374 | |
TokuDB ft flusher: leaf node merges 356 | |
TokuDB ft flusher: nonleaf node merges 5 | |
TokuDB ft flusher: leaf node balances 96 | |
TokuDB hot: operations ever started 0 | |
TokuDB hot: operations successfully completed 0 | |
TokuDB hot: operations aborted 0 | |
TokuDB hot: max number of flushes from root ever required to optimize a tree 0 | |
TokuDB txn: begin 42613605 | |
TokuDB txn: begin read only 2899374 | |
TokuDB txn: successful commits 45512978 | |
TokuDB txn: aborts 1 | |
TokuDB logger: next LSN 165554557 | |
TokuDB logger: writes 18314654 | |
TokuDB logger: writes (bytes) 14670177695 | |
TokuDB logger: writes (uncompressed bytes) 14670177695 | |
TokuDB logger: writes (seconds) 223.047228 | |
TokuDB logger: number of long logger write operations 0 | |
TokuDB indexer: number of indexers successfully created 0 | |
TokuDB indexer: number of calls to toku_indexer_create_indexer() that failed 0 | |
TokuDB indexer: number of calls to indexer->build() succeeded 0 | |
TokuDB indexer: number of calls to indexer->build() failed 0 | |
TokuDB indexer: number of calls to indexer->close() that succeeded 0 | |
TokuDB indexer: number of calls to indexer->close() that failed 0 | |
TokuDB indexer: number of calls to indexer->abort() 0 | |
TokuDB indexer: number of indexers currently in existence 0 | |
TokuDB indexer: max number of indexers that ever existed simultaneously 0 | |
TokuDB loader: number of loaders successfully created 1 | |
TokuDB loader: number of calls to toku_loader_create_loader() that failed 0 | |
TokuDB loader: number of calls to loader->put() succeeded 87520119 | |
TokuDB loader: number of calls to loader->put() failed 0 | |
TokuDB loader: number of calls to loader->close() that succeeded 1 | |
TokuDB loader: number of calls to loader->close() that failed 0 | |
TokuDB loader: number of calls to loader->abort() 0 | |
TokuDB loader: number of loaders currently in existence 0 | |
TokuDB loader: max number of loaders that ever existed simultaneously 1 | |
TokuDB memory: number of malloc operations 0 | |
TokuDB memory: number of free operations 0 | |
TokuDB memory: number of realloc operations 0 | |
TokuDB memory: number of malloc operations that failed 0 | |
TokuDB memory: number of realloc operations that failed 89 | |
TokuDB memory: number of bytes requested 0 | |
TokuDB memory: number of bytes used (requested + overhead) 0 | |
TokuDB memory: number of bytes freed 0 | |
TokuDB memory: largest attempted allocation size 0 | |
TokuDB memory: size of the last failed allocation attempt 0 | |
TokuDB memory: estimated maximum memory footprint 0 | |
TokuDB memory: mallocator version 3.6.0-0-g46c0af68bd248b04df75e4f92d5fb804c3d75340 | |
TokuDB memory: mmap threshold 4194304 | |
TokuDB filesystem: ENOSPC redzone state 0 | |
TokuDB filesystem: threads currently blocked by full disk 0 | |
TokuDB filesystem: number of operations rejected by enospc prevention (red zone) 0 | |
TokuDB filesystem: most recent disk full Thu Jan 1 01:00:00 1970 | |
TokuDB filesystem: number of write operations that returned ENOSPC 0 | |
TokuDB filesystem: fsync time 6764531124 | |
TokuDB filesystem: fsync count 18414602 | |
TokuDB filesystem: long fsync time 0 | |
TokuDB filesystem: long fsync count 0 | |
TokuDB context: tree traversals blocked by a full fetch 0 | |
TokuDB context: tree traversals blocked by a partial fetch 14 | |
TokuDB context: tree traversals blocked by a full eviction 0 | |
TokuDB context: tree traversals blocked by a partial eviction 0 | |
TokuDB context: tree traversals blocked by a message injection 25600406 | |
TokuDB context: tree traversals blocked by a message application 248424 | |
TokuDB context: tree traversals blocked by a flush 2842 | |
TokuDB context: tree traversals blocked by a the cleaner thread 1254 | |
TokuDB context: tree traversals blocked by something uninstrumented 178319 | |
TokuDB context: promotion blocked by a full fetch (should never happen) 8 | |
TokuDB context: promotion blocked by a partial fetch (should never happen) 0 | |
TokuDB context: promotion blocked by a full eviction (should never happen) 0 | |
TokuDB context: promotion blocked by a partial eviction (should never happen) 0 | |
TokuDB context: promotion blocked by a message injection 532 | |
TokuDB context: promotion blocked by a message application 0 | |
TokuDB context: promotion blocked by a flush 193 | |
TokuDB context: promotion blocked by the cleaner thread 221 | |
TokuDB context: promotion blocked by something uninstrumented 70 | |
TokuDB context: something uninstrumented blocked by something uninstrumented 73300 | |
TokuDB handlerton: primary key bytes inserted 2208262965 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment