MariaDB [(none)]> show engine tokudb status; +--------+---------------------------------------------------------------------------------+---------------------------------------------------+ | Type | Name | Status | +--------+---------------------------------------------------------------------------------+---------------------------------------------------+ | TokuDB | disk free space | more than 4 percent of total file system space | | TokuDB | time of environment creation | Fri Mar 28 20:42:07 2014 | | TokuDB | time of engine startup | Thu Jul 27 17:16:10 2017 | | TokuDB | time now | Sat Jul 29 10:33:25 2017 | | TokuDB | db opens | 78 | | TokuDB | db closes | 0 | | TokuDB | num open dbs now | 78 | | TokuDB | max open dbs | 78 | | TokuDB | period, in ms, that recovery log is automatically fsynced | 0 | | TokuDB | dictionary inserts | 404524 | | TokuDB | dictionary inserts fail | 0 | | TokuDB | dictionary deletes | 0 | | 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 | 128931900 | | TokuDB | dictionary multi inserts fail | 0 | | TokuDB | dictionary multi deletes | 96 | | TokuDB | dictionary multi deletes fail | 0 | | TokuDB | dictionary updates multi | 2763360 | | TokuDB | dictionary updates multi fail | 0 | | TokuDB | le: max committed xr | 5 | | TokuDB | le: max provisional xr | 2 | | TokuDB | le: expanded | 0 | | TokuDB | le: max memsize | 7903222 | | TokuDB | le: size of leafentries before garbage collection (during message application) | 25162057466 | | TokuDB | le: size of leafentries after garbage collection (during message application) | 11356236388 | | 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 | Sat Jul 29 10:33:16 2017 | | TokuDB | checkpoint: last complete checkpoint began | Sat Jul 29 10:33:16 2017 | | TokuDB | checkpoint: last complete checkpoint ended | Sat Jul 29 10:33:19 2017 | | TokuDB | checkpoint: time spent during checkpoint (begin and end phases) | 24044 | | TokuDB | checkpoint: time spent during last checkpoint (begin and end phases) | 3 | | TokuDB | checkpoint: last complete checkpoint LSN | 18325135371 | | TokuDB | checkpoint: checkpoints taken | 2478 | | TokuDB | checkpoint: checkpoints failed | 0 | | TokuDB | checkpoint: waiters now | 0 | | TokuDB | checkpoint: waiters max | 0 | | TokuDB | checkpoint: non-checkpoint client wait on mo lock | 83 | | TokuDB | checkpoint: non-checkpoint client wait on cs lock | 0 | | TokuDB | checkpoint: checkpoint begin time | 49442887 | | TokuDB | checkpoint: long checkpoint begin time | 1813377 | | TokuDB | checkpoint: long checkpoint begin count | 1 | | TokuDB | checkpoint: checkpoint end time | 23562946841 | | TokuDB | checkpoint: long checkpoint end time | 0 | | TokuDB | checkpoint: long checkpoint end count | 0 | | TokuDB | cachetable: miss | 58308 | | TokuDB | cachetable: miss time | 114725160 | | TokuDB | cachetable: prefetches | 384 | | TokuDB | cachetable: size current | 4294285658 | | TokuDB | cachetable: size limit | 4724464025 | | TokuDB | cachetable: size writing | 0 | | TokuDB | cachetable: size nonleaf | 1031270753 | | TokuDB | cachetable: size leaf | 3263013865 | | TokuDB | cachetable: size rollback | 1040 | | TokuDB | cachetable: size cachepressure | 1045224045 | | TokuDB | cachetable: size currently cloned data for checkpoint | 0 | | TokuDB | cachetable: evictions | 35391 | | TokuDB | cachetable: cleaner executions | 286309 | | 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 | 4 | | 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 | 3 | | TokuDB | cachetable: client pool: total number of work items processed | 11496 | | TokuDB | cachetable: client pool: total execution time of processing work items | 302807 | | TokuDB | cachetable: cachetable pool: number of threads in pool | 8 | | 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 | 182 | | TokuDB | cachetable: cachetable pool: total number of work items processed | 205890 | | TokuDB | cachetable: cachetable pool: total execution time of processing work items | 1690963 | | TokuDB | cachetable: checkpoint pool: number of threads in pool | 1 | | 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 | 71 | | TokuDB | cachetable: checkpoint pool: total number of work items processed | 27869 | | TokuDB | cachetable: checkpoint pool: total execution time of processing work items | 1844927 | | TokuDB | locktree: memory size | 0 | | TokuDB | locktree: memory size limit | 536870912 | | 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 | 80 | | 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 | 481 | | TokuDB | locktree: time spent ending the STO early (seconds) | 5.907182 | | TokuDB | locktree: number of wait locks | 187 | | TokuDB | locktree: time waiting for locks | 712627 | | 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 | 0 | | TokuDB | ft: messages ignored by leaf due to msn | 386307 | | TokuDB | ft: total search retries due to TRY_AGAIN | 1325456 | | TokuDB | ft: searches requiring more tries than the height of the tree | 1 | | TokuDB | ft: searches requiring more tries than the height of the tree plus three | 0 | | TokuDB | ft: leaf nodes flushed to disk (not for checkpoint) | 0 | | TokuDB | ft: leaf nodes flushed to disk (not for checkpoint) (bytes) | 0 | | TokuDB | ft: leaf nodes flushed to disk (not for checkpoint) (uncompressed bytes) | 0 | | TokuDB | ft: leaf nodes flushed to disk (not for checkpoint) (seconds) | 0.000000 | | TokuDB | ft: nonleaf nodes flushed to disk (not for checkpoint) | 257 | | TokuDB | ft: nonleaf nodes flushed to disk (not for checkpoint) (bytes) | 64172032 | | TokuDB | ft: nonleaf nodes flushed to disk (not for checkpoint) (uncompressed bytes) | 449127325 | | TokuDB | ft: nonleaf nodes flushed to disk (not for checkpoint) (seconds) | 0.104746 | | TokuDB | ft: leaf nodes flushed to disk (for checkpoint) | 88129 | | TokuDB | ft: leaf nodes flushed to disk (for checkpoint) (bytes) | 29689873408 | | TokuDB | ft: leaf nodes flushed to disk (for checkpoint) (uncompressed bytes) | 158447921450 | | TokuDB | ft: leaf nodes flushed to disk (for checkpoint) (seconds) | 39.880251 | | TokuDB | ft: nonleaf nodes flushed to disk (for checkpoint) | 169563 | | TokuDB | ft: nonleaf nodes flushed to disk (for checkpoint) (bytes) | 25250167808 | | TokuDB | ft: nonleaf nodes flushed to disk (for checkpoint) (uncompressed bytes) | 194088942581 | | TokuDB | ft: nonleaf nodes flushed to disk (for checkpoint) (seconds) | 47.989150 | | TokuDB | ft: uncompressed / compressed bytes written (leaf) | 5.336766 | | TokuDB | ft: uncompressed / compressed bytes written (nonleaf) | 7.684896 | | TokuDB | ft: uncompressed / compressed bytes written (overall) | 6.417436 | | TokuDB | ft: nonleaf node partial evictions | 1265457 | | TokuDB | ft: nonleaf node partial evictions (bytes) | 90857600922 | | TokuDB | ft: leaf node partial evictions | 2926711 | | TokuDB | ft: leaf node partial evictions (bytes) | 295750353219 | | TokuDB | ft: leaf node full evictions | 15636 | | TokuDB | ft: leaf node full evictions (bytes) | 604477548 | | TokuDB | ft: nonleaf node full evictions | 19732 | | TokuDB | ft: nonleaf node full evictions (bytes) | 25023897213 | | TokuDB | ft: leaf nodes created | 2514 | | TokuDB | ft: nonleaf nodes created | 255 | | TokuDB | ft: leaf nodes destroyed | 0 | | TokuDB | ft: nonleaf nodes destroyed | 0 | | TokuDB | ft: bytes of messages injected at root (all trees) | 4034845952 | | TokuDB | ft: bytes of messages flushed from h1 nodes to leaves | 7236515047 | | TokuDB | ft: bytes of messages currently in trees (estimate) | 18446744070507882521 | | TokuDB | ft: messages injected at root | 71827984 | | TokuDB | ft: broadcast messages injected at root | 0 | | TokuDB | ft: basements decompressed as a target of a query | 60 | | TokuDB | ft: basements decompressed for prelocked range | 0 | | TokuDB | ft: basements decompressed for prefetch | 0 | | TokuDB | ft: basements decompressed for write | 51 | | TokuDB | ft: buffers decompressed as a target of a query | 117268 | | TokuDB | ft: buffers decompressed for prelocked range | 16 | | TokuDB | ft: buffers decompressed for prefetch | 0 | | TokuDB | ft: buffers decompressed for write | 990876 | | TokuDB | ft: pivots fetched for query | 19746 | | TokuDB | ft: pivots fetched for query (bytes) | 640998912 | | TokuDB | ft: pivots fetched for query (seconds) | 20.616376 | | TokuDB | ft: pivots fetched for prefetch | 384 | | TokuDB | ft: pivots fetched for prefetch (bytes) | 12551168 | | TokuDB | ft: pivots fetched for prefetch (seconds) | 0.236748 | | TokuDB | ft: pivots fetched for write | 111 | | TokuDB | ft: pivots fetched for write (bytes) | 2438144 | | TokuDB | ft: pivots fetched for write (seconds) | 0.020151 | | TokuDB | ft: basements fetched as a target of a query | 1679819 | | TokuDB | ft: basements fetched as a target of a query (bytes) | 23962012672 | | TokuDB | ft: basements fetched as a target of a query (seconds) | 822.651360 | | TokuDB | ft: basements fetched for prelocked range | 7187 | | TokuDB | ft: basements fetched for prelocked range (bytes) | 58366976 | | TokuDB | ft: basements fetched for prelocked range (seconds) | 0.432054 | | TokuDB | ft: basements fetched for prefetch | 49262 | | TokuDB | ft: basements fetched for prefetch (bytes) | 388774912 | | TokuDB | ft: basements fetched for prefetch (seconds) | 1.567420 | | TokuDB | ft: basements fetched for write | 1205149 | | TokuDB | ft: basements fetched for write (bytes) | 14772705792 | | TokuDB | ft: basements fetched for write (seconds) | 52.374179 | | TokuDB | ft: buffers fetched as a target of a query | 6113 | | TokuDB | ft: buffers fetched as a target of a query (bytes) | 7969280 | | TokuDB | ft: buffers fetched as a target of a query (seconds) | 2.781929 | | TokuDB | ft: buffers fetched for prelocked range | 0 | | TokuDB | ft: buffers fetched for prelocked range (bytes) | 0 | | TokuDB | ft: buffers fetched for prelocked range (seconds) | 0.000000 | | 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 | 236805 | | TokuDB | ft: buffers fetched for write (bytes) | 6552146944 | | TokuDB | ft: buffers fetched for write (seconds) | 39.100732 | | TokuDB | ft: leaf compression to memory (seconds) | 11579.673914 | | TokuDB | ft: leaf serialization to memory (seconds) | 249.198177 | | TokuDB | ft: leaf decompression to memory (seconds) | 3731.830846 | | TokuDB | ft: leaf deserialization to memory (seconds) | 338.786594 | | TokuDB | ft: nonleaf compression to memory (seconds) | 12857.636482 | | TokuDB | ft: nonleaf serialization to memory (seconds) | 457.865795 | | TokuDB | ft: nonleaf decompression to memory (seconds) | 721.429967 | | TokuDB | ft: nonleaf deserialization to memory (seconds) | 300.284931 | | TokuDB | ft: promotion: roots split | 0 | | TokuDB | ft: promotion: leaf roots injected into | 23449 | | TokuDB | ft: promotion: h1 roots injected into | 128830 | | TokuDB | ft: promotion: injections at depth 0 | 33471538 | | TokuDB | ft: promotion: injections at depth 1 | 27502460 | | TokuDB | ft: promotion: injections at depth 2 | 6790774 | | TokuDB | ft: promotion: injections at depth 3 | 1271249 | | TokuDB | ft: promotion: injections lower than depth 3 | 4277853 | | TokuDB | ft: promotion: stopped because of a nonempty buffer | 70292024 | | TokuDB | ft: promotion: stopped at height 1 | 2780 | | TokuDB | ft: promotion: stopped because the child was locked or not at all in memory | 2838 | | TokuDB | ft: promotion: stopped because the child was not fully in memory | 143 | | TokuDB | ft: promotion: stopped anyway, after locking the child | 3091 | | TokuDB | ft: basement nodes deserialized with fixed-keysize | 1638980 | | TokuDB | ft: basement nodes deserialized with variable-keysize | 1302558 | | TokuDB | ft: promotion: succeeded in using the rightmost leaf shortcut | 56649200 | | TokuDB | ft: promotion: tried the rightmost leaf shorcut but failed (out-of-bounds) | 1426 | | TokuDB | ft: promotion: tried the rightmost leaf shorcut but failed (child reactive) | 835089 | | TokuDB | ft: cursor skipped deleted leaf entries | 2876 | | TokuDB | ft flusher: total nodes potentially flushed by cleaner thread | 152841 | | TokuDB | ft flusher: height-one nodes flushed by cleaner thread | 119461 | | TokuDB | ft flusher: height-greater-than-one nodes flushed by cleaner thread | 33380 | | TokuDB | ft flusher: nodes cleaned which had empty buffers | 109392 | | TokuDB | ft flusher: nodes dirtied by cleaner thread | 86253 | | TokuDB | ft flusher: max bytes in a buffer flushed by cleaner thread | 3431322 | | TokuDB | ft flusher: min bytes in a buffer flushed by cleaner thread | 38 | | TokuDB | ft flusher: total bytes in buffers flushed by cleaner thread | 14034881977 | | TokuDB | ft flusher: max workdone in a buffer flushed by cleaner thread | 2096580 | | TokuDB | ft flusher: min workdone in a buffer flushed by cleaner thread | 0 | | TokuDB | ft flusher: total workdone in buffers flushed by cleaner thread | 308439149 | | TokuDB | ft flusher: times cleaner thread tries to merge a leaf | 18 | | TokuDB | ft flusher: cleaner thread leaf merges in progress | 0 | | TokuDB | ft flusher: cleaner thread leaf merges successful | 17 | | TokuDB | ft flusher: nodes dirtied by cleaner thread leaf merges | 8 | | TokuDB | ft flusher: total number of flushes done by flusher threads or cleaner threads | 55217 | | TokuDB | ft flusher: number of in memory flushes | 55217 | | TokuDB | ft flusher: number of flushes that read something off disk | 0 | | TokuDB | ft flusher: number of flushes that triggered another flush in child | 1819 | | TokuDB | ft flusher: number of flushes that triggered 1 cascading flush | 1689 | | TokuDB | ft flusher: number of flushes that triggered 2 cascading flushes | 116 | | TokuDB | ft flusher: number of flushes that triggered 3 cascading flushes | 13 | | TokuDB | ft flusher: number of flushes that triggered 4 cascading flushes | 1 | | 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 | 2516 | | TokuDB | ft flusher: nonleaf node splits | 255 | | TokuDB | ft flusher: leaf node merges | 17 | | TokuDB | ft flusher: nonleaf node merges | 0 | | TokuDB | ft flusher: leaf node balances | 2 | | 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 | 2101039 | | TokuDB | txn: begin read only | 1228419 | | TokuDB | txn: successful commits | 3329404 | | TokuDB | txn: aborts | 54 | | TokuDB | logger: next LSN | 18325135453 | | TokuDB | logger: writes | 110824 | | TokuDB | logger: writes (bytes) | 3440319024 | | TokuDB | logger: writes (uncompressed bytes) | 3440319024 | | TokuDB | logger: writes (seconds) | 6.186685 | | 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 | 0 | | TokuDB | loader: number of calls to toku_loader_create_loader() that failed | 0 | | TokuDB | loader: number of calls to loader->put() succeeded | 0 | | TokuDB | loader: number of calls to loader->put() failed | 0 | | TokuDB | loader: number of calls to loader->close() that succeeded | 0 | | 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 | 0 | | 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 | 0 | | 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 | 725496030 | | TokuDB | filesystem: fsync count | 289609 | | TokuDB | filesystem: long fsync time | 14798206 | | TokuDB | filesystem: long fsync count | 4 | | TokuDB | context: tree traversals blocked by a full fetch | 1 | | TokuDB | context: tree traversals blocked by a partial fetch | 626 | | TokuDB | context: tree traversals blocked by a full eviction | 0 | | TokuDB | context: tree traversals blocked by a partial eviction | 1 | | TokuDB | context: tree traversals blocked by a message injection | 468 | | TokuDB | context: tree traversals blocked by a message application | 3403 | | TokuDB | context: tree traversals blocked by a flush | 0 | | TokuDB | context: tree traversals blocked by a the cleaner thread | 38 | | TokuDB | context: tree traversals blocked by something uninstrumented | 3173 | | TokuDB | context: promotion blocked by a full fetch (should never happen) | 2 | | TokuDB | context: promotion blocked by a partial fetch (should never happen) | 2 | | 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 | 1058 | | TokuDB | context: promotion blocked by a message application | 0 | | TokuDB | context: promotion blocked by a flush | 92 | | TokuDB | context: promotion blocked by the cleaner thread | 3 | | TokuDB | context: promotion blocked by something uninstrumented | 0 | | TokuDB | context: something uninstrumented blocked by something uninstrumented | 8511 | | TokuDB | handlerton: primary key bytes inserted | 712714526 | +--------+---------------------------------------------------------------------------------+---------------------------------------------------+