TokuDB status variables

Important

Starting with Percona Server for MySQL 8.0.28-19, the TokuDB storage engine is no longer supported. We have removed the storage engine from the installation packages and disabled the storage engine in our binary builds.

Starting with Percona Server for MySQL 8.0.26-16, the binary builds and packages include but disable the TokuDB storage engine plugins. The tokudb_enabled option and the tokudb_backup_enabled option control the state of the plugins and have a default setting of FALSE. The result of attempting to load the plugins are the plugins fail to initialize and print a deprecation message.

We recommend Migrating the data to the MyRocks storage engine. To enable the plugins to migrate to another storage engine, set the tokudb_enabled and tokudb_backup_enabled options to TRUE in your my.cnf file and restart your server instance. Then, you can load the plugins.

The TokuDB storage engine was declared as deprecated in Percona Server for MySQL 8.0. For more information, see the Percona blog post: Heads-Up: TokuDB Support Changes and Future Removal from Percona Server for MySQL 8.0.

TokuDB status variables provide details about the inner workings of TokuDB storage engine and they can be useful in tuning the storage engine to a particular environment.

You can view these variables and their values by running:

mysql> SHOW STATUS LIKE 'tokudb%';

TokuDB Status Variables Summary

The following global status variables are available:

Name	Var Type
Tokudb_DB_OPENS	integer
Tokudb_DB_CLOSES	integer
Tokudb_DB_OPEN_CURRENT	integer
Tokudb_DB_OPEN_MAX	integer
Tokudb_LEAF_ENTRY_MAX_COMMITTED_XR	integer
Tokudb_LEAF_ENTRY_MAX_PROVISIONAL_XR	integer
Tokudb_LEAF_ENTRY_EXPANDED	integer
Tokudb_LEAF_ENTRY_MAX_MEMSIZE	integer
Tokudb_LEAF_ENTRY_APPLY_GC_BYTES_IN	integer
Tokudb_LEAF_ENTRY_APPLY_GC_BYTES_OUT	integer
Tokudb_LEAF_ENTRY_NORMAL_GC_BYTES_IN	integer
Tokudb_LEAF_ENTRY_NORMAL_GC_BYTES_OUT	integer
Tokudb_CHECKPOINT_PERIOD	integer
Tokudb_CHECKPOINT_FOOTPRINT	integer
Tokudb_CHECKPOINT_LAST_BEGAN	datetime
Tokudb_CHECKPOINT_LAST_COMPLETE_BEGAN	datetime
Tokudb_CHECKPOINT_LAST_COMPLETE_ENDED	datetime
Tokudb_CHECKPOINT_DURATION	integer
Tokudb_CHECKPOINT_DURATION_LAST	integer
Tokudb_CHECKPOINT_LAST_LSN	integer
Tokudb_CHECKPOINT_TAKEN	integer
Tokudb_CHECKPOINT_FAILED	integer
Tokudb_CHECKPOINT_WAITERS_NOW	integer
Tokudb_CHECKPOINT_WAITERS_MAX	integer
Tokudb_CHECKPOINT_CLIENT_WAIT_ON_MO	integer
Tokudb_CHECKPOINT_CLIENT_WAIT_ON_CS	integer
Tokudb_CHECKPOINT_BEGIN_TIME	integer
Tokudb_CHECKPOINT_LONG_BEGIN_TIME	integer
Tokudb_CHECKPOINT_LONG_BEGIN_COUNT	integer
Tokudb_CHECKPOINT_END_TIME	integer
Tokudb_CHECKPOINT_LONG_END_TIME	integer
Tokudb_CHECKPOINT_LONG_END_COUNT	integer
Tokudb_CACHETABLE_MISS	integer
Tokudb_CACHETABLE_MISS_TIME	integer
Tokudb_CACHETABLE_PREFETCHES	integer
Tokudb_CACHETABLE_SIZE_CURRENT	integer
Tokudb_CACHETABLE_SIZE_LIMIT	integer
Tokudb_CACHETABLE_SIZE_WRITING	integer
Tokudb_CACHETABLE_SIZE_NONLEAF	integer
Tokudb_CACHETABLE_SIZE_LEAF	integer
Tokudb_CACHETABLE_SIZE_ROLLBACK	integer
Tokudb_CACHETABLE_SIZE_CACHEPRESSURE	integer
Tokudb_CACHETABLE_SIZE_CLONED	integer
Tokudb_CACHETABLE_EVICTIONS	integer
Tokudb_CACHETABLE_CLEANER_EXECUTIONS	integer
Tokudb_CACHETABLE_CLEANER_PERIOD	integer
Tokudb_CACHETABLE_CLEANER_ITERATIONS	integer
Tokudb_CACHETABLE_WAIT_PRESSURE_COUNT	integer
Tokudb_CACHETABLE_WAIT_PRESSURE_TIME	integer
Tokudb_CACHETABLE_LONG_WAIT_PRESSURE_COUNT	integer
Tokudb_CACHETABLE_LONG_WAIT_PRESSURE_TIME	integer
Tokudb_CACHETABLE_POOL_CLIENT_NUM_THREADS	integer
Tokudb_CACHETABLE_POOL_CLIENT_NUM_THREADS_ACTIVE	integer
Tokudb_CACHETABLE_POOL_CLIENT_QUEUE_SIZE	integer
Tokudb_CACHETABLE_POOL_CLIENT_MAX_QUEUE_SIZE	integer
Tokudb_CACHETABLE_POOL_CLIENT_TOTAL_ITEMS_PROCESSED	integer
Tokudb_CACHETABLE_POOL_CLIENT_TOTAL_EXECUTION_TIME	integer
Tokudb_CACHETABLE_POOL_CACHETABLE_NUM_THREADS	integer
Tokudb_CACHETABLE_POOL_CACHETABLE_NUM_THREADS_ACTIVE	integer
Tokudb_CACHETABLE_POOL_CACHETABLE_QUEUE_SIZE	integer
Tokudb_CACHETABLE_POOL_CACHETABLE_MAX_QUEUE_SIZE	integer
Tokudb_CACHETABLE_POOL_CACHETABLE_TOTAL_ITEMS_PROCESSED	integer
Tokudb_CACHETABLE_POOL_CACHETABLE_TOTAL_EXECUTION_TIME	integer
Tokudb_CACHETABLE_POOL_CHECKPOINT_NUM_THREADS	integer
Tokudb_CACHETABLE_POOL_CHECKPOINT_NUM_THREADS_ACTIVE	integer
Tokudb_CACHETABLE_POOL_CHECKPOINT_QUEUE_SIZE	integer
Tokudb_CACHETABLE_POOL_CHECKPOINT_MAX_QUEUE_SIZE	integer
Tokudb_CACHETABLE_POOL_CHECKPOINT_TOTAL_ITEMS_PROCESSED	integer
Tokudb_CACHETABLE_POOL_CHECKPOINT_TOTAL_EXECUTION_TIME	integer
Tokudb_LOCKTREE_MEMORY_SIZE	integer
Tokudb_LOCKTREE_MEMORY_SIZE_LIMIT	integer
Tokudb_LOCKTREE_ESCALATION_NUM	integer
Tokudb_LOCKTREE_ESCALATION_SECONDS	numeric
Tokudb_LOCKTREE_LATEST_POST_ESCALATION_MEMORY_SIZE	integer
Tokudb_LOCKTREE_OPEN_CURRENT	integer
Tokudb_LOCKTREE_PENDING_LOCK_REQUESTS	integer
Tokudb_LOCKTREE_STO_ELIGIBLE_NUM	integer
Tokudb_LOCKTREE_STO_ENDED_NUM	integer
Tokudb_LOCKTREE_STO_ENDED_SECONDS	numeric
Tokudb_LOCKTREE_WAIT_COUNT	integer
Tokudb_LOCKTREE_WAIT_TIME	integer
Tokudb_LOCKTREE_LONG_WAIT_COUNT	integer
Tokudb_LOCKTREE_LONG_WAIT_TIME	integer
Tokudb_LOCKTREE_TIMEOUT_COUNT	integer
Tokudb_LOCKTREE_WAIT_ESCALATION_COUNT	integer
Tokudb_LOCKTREE_WAIT_ESCALATION_TIME	integer
Tokudb_LOCKTREE_LONG_WAIT_ESCALATION_COUNT	integer
Tokudb_LOCKTREE_LONG_WAIT_ESCALATION_TIME	integer
Tokudb_DICTIONARY_UPDATES	integer
Tokudb_DICTIONARY_BROADCAST_UPDATES	integer
Tokudb_DESCRIPTOR_SET	integer
Tokudb_MESSAGES_IGNORED_BY_LEAF_DUE_TO_MSN	integer
Tokudb_TOTAL_SEARCH_RETRIES	integer
Tokudb_SEARCH_TRIES_GT_HEIGHT	integer
Tokudb_SEARCH_TRIES_GT_HEIGHTPLUS3	integer
Tokudb_LEAF_NODES_FLUSHED_NOT_CHECKPOINT	integer
Tokudb_LEAF_NODES_FLUSHED_NOT_CHECKPOINT_BYTES	integer
Tokudb_LEAF_NODES_FLUSHED_NOT_CHECKPOINT_UNCOMPRESSED_BYTES	integer
Tokudb_LEAF_NODES_FLUSHED_NOT_CHECKPOINT_SECONDS	numeric
Tokudb_NONLEAF_NODES_FLUSHED_TO_DISK_NOT_CHECKPOINT	integer
Tokudb_NONLEAF_NODES_FLUSHED_TO_DISK_NOT_CHECKPOINT_BYTES	integer
Tokudb_NONLEAF_NODES_FLUSHED_TO_DISK_NOT_CHECKPOINT_UNCOMPRESSE	integer
Tokudb_NONLEAF_NODES_FLUSHED_TO_DISK_NOT_CHECKPOINT_SECONDS	numeric
Tokudb_LEAF_NODES_FLUSHED_CHECKPOINT	integer
Tokudb_LEAF_NODES_FLUSHED_CHECKPOINT_BYTES	integer
Tokudb_LEAF_NODES_FLUSHED_CHECKPOINT_UNCOMPRESSED_BYTES	integer
Tokudb_LEAF_NODES_FLUSHED_CHECKPOINT_SECONDS	numeric
Tokudb_NONLEAF_NODES_FLUSHED_TO_DISK_CHECKPOINT	integer
Tokudb_NONLEAF_NODES_FLUSHED_TO_DISK_CHECKPOINT_BYTES	integer
Tokudb_NONLEAF_NODES_FLUSHED_TO_DISK_CHECKPOINT_UNCOMPRESSED_BY	integer
Tokudb_NONLEAF_NODES_FLUSHED_TO_DISK_CHECKPOINT_SECONDS	numeric
Tokudb_LEAF_NODE_COMPRESSION_RATIO	numeric
Tokudb_NONLEAF_NODE_COMPRESSION_RATIO	numeric
Tokudb_OVERALL_NODE_COMPRESSION_RATIO	numeric
Tokudb_NONLEAF_NODE_PARTIAL_EVICTIONS	numeric
Tokudb_NONLEAF_NODE_PARTIAL_EVICTIONS_BYTES	integer
Tokudb_LEAF_NODE_PARTIAL_EVICTIONS	integer
Tokudb_LEAF_NODE_PARTIAL_EVICTIONS_BYTES	integer
Tokudb_LEAF_NODE_FULL_EVICTIONS	integer
Tokudb_LEAF_NODE_FULL_EVICTIONS_BYTES	integer
Tokudb_NONLEAF_NODE_FULL_EVICTIONS	integer
Tokudb_NONLEAF_NODE_FULL_EVICTIONS_BYTES	integer
Tokudb_LEAF_NODES_CREATED	integer
Tokudb_NONLEAF_NODES_CREATED	integer
Tokudb_LEAF_NODES_DESTROYED	integer
Tokudb_NONLEAF_NODES_DESTROYED	integer
Tokudb_MESSAGES_INJECTED_AT_ROOT_BYTES	integer
Tokudb_MESSAGES_FLUSHED_FROM_H1_TO_LEAVES_BYTES	integer
Tokudb_MESSAGES_IN_TREES_ESTIMATE_BYTES	integer
Tokudb_MESSAGES_INJECTED_AT_ROOT	integer
Tokudb_BROADCASE_MESSAGES_INJECTED_AT_ROOT	integer
Tokudb_BASEMENTS_DECOMPRESSED_TARGET_QUERY	integer
Tokudb_BASEMENTS_DECOMPRESSED_PRELOCKED_RANGE	integer
Tokudb_BASEMENTS_DECOMPRESSED_PREFETCH	integer
Tokudb_BASEMENTS_DECOMPRESSED_FOR_WRITE	integer
Tokudb_BUFFERS_DECOMPRESSED_TARGET_QUERY	integer
Tokudb_BUFFERS_DECOMPRESSED_PRELOCKED_RANGE	integer
Tokudb_BUFFERS_DECOMPRESSED_PREFETCH	integer
Tokudb_BUFFERS_DECOMPRESSED_FOR_WRITE	integer
Tokudb_PIVOTS_FETCHED_FOR_QUERY	integer
Tokudb_PIVOTS_FETCHED_FOR_QUERY_BYTES	integer
Tokudb_PIVOTS_FETCHED_FOR_QUERY_SECONDS	numeric
Tokudb_PIVOTS_FETCHED_FOR_PREFETCH	integer
Tokudb_PIVOTS_FETCHED_FOR_PREFETCH_BYTES	integer
Tokudb_PIVOTS_FETCHED_FOR_PREFETCH_SECONDS	numeric
Tokudb_PIVOTS_FETCHED_FOR_WRITE	integer
Tokudb_PIVOTS_FETCHED_FOR_WRITE_BYTES	integer
Tokudb_PIVOTS_FETCHED_FOR_WRITE_SECONDS	numeric
Tokudb_BASEMENTS_FETCHED_TARGET_QUERY	integer
Tokudb_BASEMENTS_FETCHED_TARGET_QUERY_BYTES	integer
Tokudb_BASEMENTS_FETCHED_TARGET_QUERY_SECONDS	numeric
Tokudb_BASEMENTS_FETCHED_PRELOCKED_RANGE	integer
Tokudb_BASEMENTS_FETCHED_PRELOCKED_RANGE_BYTES	integer
Tokudb_BASEMENTS_FETCHED_PRELOCKED_RANGE_SECONDS	numeric
Tokudb_BASEMENTS_FETCHED_PREFETCH	integer
Tokudb_BASEMENTS_FETCHED_PREFETCH_BYTES	integer
Tokudb_BASEMENTS_FETCHED_PREFETCH_SECONDS	numeric
Tokudb_BASEMENTS_FETCHED_FOR_WRITE	integer
Tokudb_BASEMENTS_FETCHED_FOR_WRITE_BYTES	integer
Tokudb_BASEMENTS_FETCHED_FOR_WRITE_SECONDS	numeric
Tokudb_BUFFERS_FETCHED_TARGET_QUERY	integer
Tokudb_BUFFERS_FETCHED_TARGET_QUERY_BYTES	integer
Tokudb_BUFFERS_FETCHED_TARGET_QUERY_SECONDS	numeric
Tokudb_BUFFERS_FETCHED_PRELOCKED_RANGE	integer
Tokudb_BUFFERS_FETCHED_PRELOCKED_RANGE_BYTES	integer
Tokudb_BUFFERS_FETCHED_PRELOCKED_RANGE_SECONDS	numeric
Tokudb_BUFFERS_FETCHED_PREFETCH	integer
Tokudb_BUFFERS_FETCHED_PREFETCH_BYTES	integer
Tokudb_BUFFERS_FETCHED_PREFETCH_SECONDS	numeric
Tokudb_BUFFERS_FETCHED_FOR_WRITE	integer
Tokudb_BUFFERS_FETCHED_FOR_WRITE_BYTES	integer
Tokudb_BUFFERS_FETCHED_FOR_WRITE_SECONDS	integer
Tokudb_LEAF_COMPRESSION_TO_MEMORY_SECONDS	numeric
Tokudb_LEAF_SERIALIZATION_TO_MEMORY_SECONDS	numeric
Tokudb_LEAF_DECOMPRESSION_TO_MEMORY_SECONDS	numeric
Tokudb_LEAF_DESERIALIZATION_TO_MEMORY_SECONDS	numeric
Tokudb_NONLEAF_COMPRESSION_TO_MEMORY_SECONDS	numeric
Tokudb_NONLEAF_SERIALIZATION_TO_MEMORY_SECONDS	numeric
Tokudb_NONLEAF_DECOMPRESSION_TO_MEMORY_SECONDS	numeric
Tokudb_NONLEAF_DESERIALIZATION_TO_MEMORY_SECONDS	numeric
Tokudb_PROMOTION_ROOTS_SPLIT	integer
Tokudb_PROMOTION_LEAF_ROOTS_INJECTED_INTO	integer
Tokudb_PROMOTION_H1_ROOTS_INJECTED_INTO	integer
Tokudb_PROMOTION_INJECTIONS_AT_DEPTH_0	integer
Tokudb_PROMOTION_INJECTIONS_AT_DEPTH_1	integer
Tokudb_PROMOTION_INJECTIONS_AT_DEPTH_2	integer
Tokudb_PROMOTION_INJECTIONS_AT_DEPTH_3	integer
Tokudb_PROMOTION_INJECTIONS_LOWER_THAN_DEPTH_3	integer
Tokudb_PROMOTION_STOPPED_NONEMPTY_BUFFER	integer
Tokudb_PROMOTION_STOPPED_AT_HEIGHT_1	integer
Tokudb_PROMOTION_STOPPED_CHILD_LOCKED_OR_NOT_IN_MEMORY	integer
Tokudb_PROMOTION_STOPPED_CHILD_NOT_FULLY_IN_MEMORY	integer
Tokudb_PROMOTION_STOPPED_AFTER_LOCKING_CHILD	integer
Tokudb_BASEMENT_DESERIALIZATION_FIXED_KEY	integer
Tokudb_BASEMENT_DESERIALIZATION_VARIABLE_KEY	integer
Tokudb_PRO_RIGHTMOST_LEAF_SHORTCUT_SUCCESS	integer
Tokudb_PRO_RIGHTMOST_LEAF_SHORTCUT_FAIL_POS	integer
Tokudb_RIGHTMOST_LEAF_SHORTCUT_FAIL_REACTIVE	integer
Tokudb_CURSOR_SKIP_DELETED_LEAF_ENTRY	integer
Tokudb_FLUSHER_CLEANER_TOTAL_NODES	integer
Tokudb_FLUSHER_CLEANER_H1_NODES	integer
Tokudb_FLUSHER_CLEANER_HGT1_NODES	integer
Tokudb_FLUSHER_CLEANER_EMPTY_NODES	integer
Tokudb_FLUSHER_CLEANER_NODES_DIRTIED	integer
Tokudb_FLUSHER_CLEANER_MAX_BUFFER_SIZE	integer
Tokudb_FLUSHER_CLEANER_MIN_BUFFER_SIZE	integer
Tokudb_FLUSHER_CLEANER_TOTAL_BUFFER_SIZE	integer
Tokudb_FLUSHER_CLEANER_MAX_BUFFER_WORKDONE	integer
Tokudb_FLUSHER_CLEANER_MIN_BUFFER_WORKDONE	integer
Tokudb_FLUSHER_CLEANER_TOTAL_BUFFER_WORKDONE	integer
Tokudb_FLUSHER_CLEANER_NUM_LEAF_MERGES_STARTED	integer
Tokudb_FLUSHER_CLEANER_NUM_LEAF_MERGES_RUNNING	integer
Tokudb_FLUSHER_CLEANER_NUM_LEAF_MERGES_COMPLETED	integer
Tokudb_FLUSHER_CLEANER_NUM_DIRTIED_FOR_LEAF_MERGE	integer
Tokudb_FLUSHER_FLUSH_TOTAL	integer
Tokudb_FLUSHER_FLUSH_IN_MEMORY	integer
Tokudb_FLUSHER_FLUSH_NEEDED_IO	integer
Tokudb_FLUSHER_FLUSH_CASCADES	integer
Tokudb_FLUSHER_FLUSH_CASCADES_1	integer
Tokudb_FLUSHER_FLUSH_CASCADES_2	integer
Tokudb_FLUSHER_FLUSH_CASCADES_3	integer
Tokudb_FLUSHER_FLUSH_CASCADES_4	integer
Tokudb_FLUSHER_FLUSH_CASCADES_5	integer
Tokudb_FLUSHER_FLUSH_CASCADES_GT_5	integer
Tokudb_FLUSHER_SPLIT_LEAF	integer
Tokudb_FLUSHER_SPLIT_NONLEAF	integer
Tokudb_FLUSHER_MERGE_LEAF	integer
Tokudb_FLUSHER_MERGE_NONLEAF	integer
Tokudb_FLUSHER_BALANCE_LEAF	integer
Tokudb_HOT_NUM_STARTED	integer
Tokudb_HOT_NUM_COMPLETED	integer
Tokudb_HOT_NUM_ABORTED	integer
Tokudb_HOT_MAX_ROOT_FLUSH_COUNT	integer
Tokudb_TXN_BEGIN	integer
Tokudb_TXN_BEGIN_READ_ONLY	integer
Tokudb_TXN_COMMITS	integer
Tokudb_TXN_ABORTS	integer
Tokudb_LOGGER_NEXT_LSN	integer
Tokudb_LOGGER_WRITES	integer
Tokudb_LOGGER_WRITES_BYTES	integer
Tokudb_LOGGER_WRITES_UNCOMPRESSED_BYTES	integer
Tokudb_LOGGER_WRITES_SECONDS	numeric
Tokudb_LOGGER_WAIT_LONG	integer
Tokudb_LOADER_NUM_CREATED	integer
Tokudb_LOADER_NUM_CURRENT	integer
Tokudb_LOADER_NUM_MAX	integer
Tokudb_MEMORY_MALLOC_COUNT	integer
Tokudb_MEMORY_FREE_COUNT	integer
Tokudb_MEMORY_REALLOC_COUNT	integer
Tokudb_MEMORY_MALLOC_FAIL	integer
Tokudb_MEMORY_REALLOC_FAIL	integer
Tokudb_MEMORY_REQUESTED	integer
Tokudb_MEMORY_USED	integer
Tokudb_MEMORY_FREED	integer
Tokudb_MEMORY_MAX_REQUESTED_SIZE	integer
Tokudb_MEMORY_LAST_FAILED_SIZE	integer
Tokudb_MEM_ESTIMATED_MAXIMUM_MEMORY_FOOTPRINT	integer
Tokudb_MEMORY_MALLOCATOR_VERSION	string
Tokudb_MEMORY_MMAP_THRESHOLD	integer
Tokudb_FILESYSTEM_THREADS_BLOCKED_BY_FULL_DISK	integer
Tokudb_FILESYSTEM_FSYNC_TIME	integer
Tokudb_FILESYSTEM_FSYNC_NUM	integer
Tokudb_FILESYSTEM_LONG_FSYNC_TIME	integer
Tokudb_FILESYSTEM_LONG_FSYNC_NUM	integer

Tokudb_DB_OPENS

This variable shows the number of times an individual PerconaFT dictionary file was opened. This is a not a useful value for a regular user to use for any purpose due to layers of open/close caching on top.

Tokudb_DB_CLOSES

This variable shows the number of times an individual PerconaFT dictionary file was closed. This is a not a useful value for a regular user to use for any purpose due to layers of open/close caching on top.

Tokudb_DB_OPEN_CURRENT

This variable shows the number of currently opened databases.

Tokudb_DB_OPEN_MAX

This variable shows the maximum number of concurrently opened databases.

Tokudb_LEAF_ENTRY_MAX_COMMITTED_XR

This variable shows the maximum number of committed transaction records that were stored on disk in a new or modified row.

Tokudb_LEAF_ENTRY_MAX_PROVISIONAL_XR

This variable shows the maximum number of provisional transaction records that were stored on disk in a new or modified row.

Tokudb_LEAF_ENTRY_EXPANDED

This variable shows the number of times that an expanded memory mechanism was used to store a new or modified row on disk.

Tokudb_LEAF_ENTRY_MAX_MEMSIZE

This variable shows the maximum number of bytes that were stored on disk as a new or modified row. This is the maximum uncompressed size of any row stored in TokuDB that was created or modified since the server started.

Tokudb_LEAF_ENTRY_APPLY_GC_BYTES_IN

This variable shows the total number of bytes of leaf nodes data before performing garbage collection for non-flush events.

Tokudb_LEAF_ENTRY_APPLY_GC_BYTES_OUT

This variable shows the total number of bytes of leaf nodes data after performing garbage collection for non-flush events.

Tokudb_LEAF_ENTRY_NORMAL_GC_BYTES_IN

This variable shows the total number of bytes of leaf nodes data before performing garbage collection for flush events.

Tokudb_LEAF_ENTRY_NORMAL_GC_BYTES_OUT

This variable shows the total number of bytes of leaf nodes data after performing garbage collection for flush events.

Tokudb_CHECKPOINT_PERIOD

This variable shows the interval in seconds between the end of an automatic checkpoint and the beginning of the next automatic checkpoint.

Tokudb_CHECKPOINT_FOOTPRINT

This variable shows at what stage the checkpointer is at. It’s used for debugging purposes only and not a useful value for a normal user.

Tokudb_CHECKPOINT_LAST_BEGAN

This variable shows the time the last checkpoint began. If a checkpoint is currently in progress, then this time may be later than the time the last checkpoint completed. If no checkpoint has ever taken place, then this value will be Dec 31, 1969 on Linux hosts.

Tokudb_CHECKPOINT_LAST_COMPLETE_BEGAN

This variable shows the time the last complete checkpoint started. Any data that changed after this time will not be captured in the checkpoint.

Tokudb_CHECKPOINT_LAST_COMPLETE_ENDED

This variable shows the time the last complete checkpoint ended.

Tokudb_CHECKPOINT_DURATION

This variable shows time (in seconds) required to complete all checkpoints.

Tokudb_CHECKPOINT_DURATION_LAST

This variable shows time (in seconds) required to complete the last checkpoint.

Tokudb_CHECKPOINT_LAST_LSN

This variable shows the last successful checkpoint LSN. Each checkpoint from the time the PerconaFT environment is created has a monotonically incrementing LSN. This is not a useful value for a normal user to use for any purpose other than having some idea of how many checkpoints have occurred since the system was first created.

Tokudb_CHECKPOINT_TAKEN

This variable shows the number of complete checkpoints that have been taken.

Tokudb_CHECKPOINT_FAILED

This variable shows the number of checkpoints that have failed for any reason.

Tokudb_CHECKPOINT_WAITERS_NOW

This variable shows the current number of threads waiting for the checkpoint safe lock. This is a not a useful value for a regular user to use for any purpose.

Tokudb_CHECKPOINT_WAITERS_MAX

This variable shows the maximum number of threads that concurrently waited for the checkpoint safe lock. This is a not a useful value for a regular user to use for any purpose.

Tokudb_CHECKPOINT_CLIENT_WAIT_ON_MO

This variable shows the number of times a non-checkpoint client thread waited for the multi-operation lock. It is an internal rwlock that is similar in nature to the InnoDB kernel mutex, it effectively halts all access to the PerconaFT API when write locked. The begin phase of the checkpoint takes this lock for a brief period.

Tokudb_CHECKPOINT_CLIENT_WAIT_ON_CS

This variable shows the number of times a non-checkpoint client thread waited for the checkpoint-safe lock. This is the lock taken when you SET tokudb_checkpoint_lock=1. If a client trying to lock/postpone the checkpointer has to wait for the currently running checkpoint to complete, that wait time will be reflected here and summed. This is not a useful metric as regular users should never be manipulating the checkpoint lock.

Tokudb_CHECKPOINT_BEGIN_TIME

This variable shows the cumulative time (in microseconds) required to mark all dirty nodes as pending a checkpoint.

Tokudb_CHECKPOINT_LONG_BEGIN_TIME

This variable shows the cumulative actual time (in microseconds) of checkpoint begin stages that took longer than 1 second.

Tokudb_CHECKPOINT_LONG_BEGIN_COUNT

This variable shows the number of checkpoints whose begin stage took longer than 1 second.

Tokudb_CHECKPOINT_END_TIME

This variable shows the time spent in checkpoint end operation in seconds.

Tokudb_CHECKPOINT_LONG_END_TIME

This variable shows the total time of long checkpoints in seconds.

Tokudb_CHECKPOINT_LONG_END_COUNT

This variable shows the number of checkpoints whose end_checkpoint operations exceeded 1 minute.

Tokudb_CACHETABLE_MISS

This variable shows the number of times the application was unable to access the data in the internal cache. A cache miss means that date will need to be read from disk.

Tokudb_CACHETABLE_MISS_TIME

This variable shows the total time, in microseconds, of how long the database has had to wait for a disk read to complete.

Tokudb_CACHETABLE_PREFETCHES

This variable shows the total number of times that a block of memory has been prefetched into the database’s cache. Data is prefetched when the database’s algorithms determine that a block of memory is likely to be accessed by the application.

Tokudb_CACHETABLE_SIZE_CURRENT

This variable shows how much of the uncompressed data, in bytes, is currently in the database’s internal cache.

Tokudb_CACHETABLE_SIZE_LIMIT

This variable shows how much of the uncompressed data, in bytes, will fit in the database’s internal cache.

Tokudb_CACHETABLE_SIZE_WRITING

This variable shows the number of bytes that are currently queued up to be written to disk.

Tokudb_CACHETABLE_SIZE_NONLEAF

This variable shows the amount of memory, in bytes, the current set of non-leaf nodes occupy in the cache.

Tokudb_CACHETABLE_SIZE_LEAF

This variable shows the amount of memory, in bytes, the current set of (decompressed) leaf nodes occupy in the cache.

Tokudb_CACHETABLE_SIZE_ROLLBACK

This variable shows the rollback nodes size, in bytes, in the cache.

Tokudb_CACHETABLE_SIZE_CACHEPRESSURE

This variable shows the number of bytes causing cache pressure (the sum of buffers and work done counters), helps to understand if cleaner threads are keeping up with workload. It should really be looked at as more of a value to use in a ratio of cache pressure / cache table size. The closer that ratio evaluates to 1, the higher the cache pressure.

Tokudb_CACHETABLE_SIZE_CLONED

This variable shows the amount of memory, in bytes, currently used for cloned nodes. During the checkpoint operation, dirty nodes are cloned prior to serialization/compression, then written to disk. After which, the memory for the cloned block is returned for re-use.

Tokudb_CACHETABLE_EVICTIONS

This variable shows the number of blocks evicted from cache. On its own this is not a useful number as its impact on performance depends entirely on the hardware and workload in use. For example, two workloads, one random, one linear for the same starting data set will have two wildly different eviction patterns.

Tokudb_CACHETABLE_CLEANER_EXECUTIONS

This variable shows the total number of times the cleaner thread loop has executed.

Tokudb_CACHETABLE_CLEANER_PERIOD

TokuDB includes a cleaner thread that optimizes indexes in the background. This variable is the time, in seconds, between the completion of a group of cleaner operations and the beginning of the next group of cleaner operations. The cleaner operations run on a background thread performing work that does not need to be done on the client thread.

Tokudb_CACHETABLE_CLEANER_ITERATIONS

This variable shows the number of cleaner operations that are performed every cleaner period.

Tokudb_CACHETABLE_WAIT_PRESSURE_COUNT

This variable shows the number of times a thread was stalled due to cache pressure.

Tokudb_CACHETABLE_WAIT_PRESSURE_TIME

This variable shows the total time, in microseconds, waiting on cache pressure to subside.

Tokudb_CACHETABLE_LONG_WAIT_PRESSURE_COUNT

This variable shows the number of times a thread was stalled for more than one second due to cache pressure.

Tokudb_CACHETABLE_LONG_WAIT_PRESSURE_TIME

This variable shows the total time, in microseconds, waiting on cache pressure to subside for more than one second.

Tokudb_CACHETABLE_POOL_CLIENT_NUM_THREADS

This variable shows the number of threads in the client thread pool.

Tokudb_CACHETABLE_POOL_CLIENT_NUM_THREADS_ACTIVE

This variable shows the number of currently active threads in the client thread pool.

Tokudb_CACHETABLE_POOL_CLIENT_QUEUE_SIZE

This variable shows the number of currently queued work items in the client thread pool.

Tokudb_CACHETABLE_POOL_CLIENT_MAX_QUEUE_SIZE

This variable shows the largest number of queued work items in the client thread pool.

Tokudb_CACHETABLE_POOL_CLIENT_TOTAL_ITEMS_PROCESSED

This variable shows the total number of work items processed in the client thread pool.

Tokudb_CACHETABLE_POOL_CLIENT_TOTAL_EXECUTION_TIME

This variable shows the total execution time of processing work items in the client thread pool.

Tokudb_CACHETABLE_POOL_CACHETABLE_NUM_THREADS

This variable shows the number of threads in the cachetable threadpool.

Tokudb_CACHETABLE_POOL_CACHETABLE_NUM_THREADS_ACTIVE

This variable shows the number of currently active threads in the cachetable thread pool.

Tokudb_CACHETABLE_POOL_CACHETABLE_QUEUE_SIZE

This variable shows the number of currently queued work items in the cachetable thread pool.

Tokudb_CACHETABLE_POOL_CACHETABLE_MAX_QUEUE_SIZE

This variable shows the largest number of queued work items in the cachetable thread pool.

Tokudb_CACHETABLE_POOL_CACHETABLE_TOTAL_ITEMS_PROCESSED

This variable shows the total number of work items processed in the cachetable thread pool.

Tokudb_CACHETABLE_POOL_CACHETABLE_TOTAL_EXECUTION_TIME

This variable shows the total execution time of processing work items in the cachetable thread pool.

Tokudb_CACHETABLE_POOL_CHECKPOINT_NUM_THREADS

This variable shows the number of threads in the checkpoint threadpool.

Tokudb_CACHETABLE_POOL_CHECKPOINT_NUM_THREADS_ACTIVE

This variable shows the number of currently active threads in the checkpoint thread pool.

Tokudb_CACHETABLE_POOL_CHECKPOINT_QUEUE_SIZE

This variable shows the number of currently queued work items in the checkpoint thread pool.

Tokudb_CACHETABLE_POOL_CHECKPOINT_MAX_QUEUE_SIZE

This variable shows the largest number of queued work items in the checkpoint thread pool.

Tokudb_CACHETABLE_POOL_CHECKPOINT_TOTAL_ITEMS_PROCESSED

This variable shows the total number of work items processed in the checkpoint thread pool.

Tokudb_CACHETABLE_POOL_CHECKPOINT_TOTAL_EXECUTION_TIME

This variable shows the total execution time of processing work items in the checkpoint thread pool.

Tokudb_LOCKTREE_MEMORY_SIZE

This variable shows the amount of memory, in bytes, that the locktree is currently using.

Tokudb_LOCKTREE_MEMORY_SIZE_LIMIT

This variable shows the maximum amount of memory, in bytes, that the locktree is allowed to use.

Tokudb_LOCKTREE_ESCALATION_NUM

This variable shows the number of times the locktree needed to run lock escalation to reduce its memory footprint.

Tokudb_LOCKTREE_ESCALATION_SECONDS

This variable shows the total number of seconds spent performing locktree escalation.

Tokudb_LOCKTREE_LATEST_POST_ESCALATION_MEMORY_SIZE

This variable shows the locktree size, in bytes, after most current locktree escalation.

Tokudb_LOCKTREE_OPEN_CURRENT

This variable shows the number of locktrees that are currently opened.

Tokudb_LOCKTREE_PENDING_LOCK_REQUESTS

This variable shows the number of requests waiting for a lock grant.

Tokudb_LOCKTREE_STO_ELIGIBLE_NUM

This variable shows the number of locktrees eligible for Single Transaction optimizations. STO optimization are behaviors that can happen within the locktree when there is exactly one transaction active within the locktree. This is a not a useful value for a regular user to use for any purpose.

Tokudb_LOCKTREE_STO_ENDED_NUM

This variable shows the total number of times a Single Transaction Optimization was ended early due to another transaction starting. STO optimization are behaviors that can happen within the locktree when there is exactly one transaction active within the locktree. This is a not a useful value for a regular user to use for any purpose.

Tokudb_LOCKTREE_STO_ENDED_SECONDS

This variable shows the total number of seconds ending the Single Transaction Optimizations. STO optimization are behaviors that can happen within the locktree when there is exactly one transaction active within the locktree. This is a not a useful value for a regular user to use for any purpose.

Tokudb_LOCKTREE_WAIT_COUNT

This variable shows the number of times that a lock request could not be acquired because of a conflict with some other transaction. PerconaFT lock request cycles to try to obtain a lock, if it can not get a lock, it sleeps/waits and times out, checks to get the lock again, repeat. This value indicates the number of cycles it needed to execute before it obtained the lock.

Tokudb_LOCKTREE_WAIT_TIME

This variable shows the total time, in microseconds, spent by client waiting for a lock conflict to be resolved.

Tokudb_LOCKTREE_LONG_WAIT_COUNT

This variable shows number of lock waits greater than one second in duration.

Tokudb_LOCKTREE_LONG_WAIT_TIME

This variable shows the total time, in microseconds, of the long waits.

Tokudb_LOCKTREE_TIMEOUT_COUNT

This variable shows the number of times that a lock request timed out.

Tokudb_LOCKTREE_WAIT_ESCALATION_COUNT

When the sum of the sizes of locks taken reaches the lock tree limit, we run lock escalation on a background thread. The clients threads need to wait for escalation to consolidate locks and free up memory. This variables shows the number of times a client thread had to wait on lock escalation.

Tokudb_LOCKTREE_WAIT_ESCALATION_TIME

This variable shows the total time, in microseconds, that a client thread spent waiting for lock escalation to free up memory.

Tokudb_LOCKTREE_LONG_WAIT_ESCALATION_COUNT

This variable shows number of times that a client thread had to wait on lock escalation and the wait time was greater than one second.

Tokudb_LOCKTREE_LONG_WAIT_ESCALATION_TIME

This variable shows the total time, in microseconds, of the long waits for lock escalation to free up memory.

Tokudb_DICTIONARY_UPDATES

This variable shows the total number of rows that have been updated in all primary and secondary indexes combined, if those updates have been done with a separate recovery log entry per index.

Tokudb_DICTIONARY_BROADCAST_UPDATES

This variable shows the number of broadcast updates that have been successfully performed. A broadcast update is an update that affects all rows in a dictionary.

Tokudb_DESCRIPTOR_SET

This variable shows the number of time a descriptor was updated when the entire dictionary was updated (for example, when the schema has been changed).

Tokudb_MESSAGES_IGNORED_BY_LEAF_DUE_TO_MSN

This variable shows the number of messages that were ignored by a leaf because it had already been applied.

Tokudb_TOTAL_SEARCH_RETRIES

Internal value that is no use to anyone other than a developer debugging a specific query/search issue.

Tokudb_SEARCH_TRIES_GT_HEIGHT

Internal value that is no use to anyone other than a developer debugging a specific query/search issue.

Tokudb_SEARCH_TRIES_GT_HEIGHTPLUS3

Internal value that is no use to anyone other than a developer debugging a specific query/search issue.

Tokudb_LEAF_NODES_FLUSHED_NOT_CHECKPOINT

This variable shows the number of leaf nodes flushed to disk, not for checkpoint.

Tokudb_LEAF_NODES_FLUSHED_NOT_CHECKPOINT_BYTES

This variable shows the size, in bytes, of leaf nodes flushed to disk, not for checkpoint.

Tokudb_LEAF_NODES_FLUSHED_NOT_CHECKPOINT_UNCOMPRESSED_BYTES

This variable shows the size, in bytes, of uncompressed leaf nodes flushed to disk not for checkpoint.

Tokudb_LEAF_NODES_FLUSHED_NOT_CHECKPOINT_SECONDS

This variable shows the number of seconds waiting for I/O when writing leaf nodes flushed to disk, not for checkpoint

Tokudb_NONLEAF_NODES_FLUSHED_TO_DISK_NOT_CHECKPOINT

This variable shows the number of non-leaf nodes flushed to disk, not for checkpoint.

Tokudb_NONLEAF_NODES_FLUSHED_TO_DISK_NOT_CHECKPOINT_BYTES

This variable shows the size, in bytes, of non-leaf nodes flushed to disk, not for checkpoint.

Tokudb_NONLEAF_NODES_FLUSHED_TO_DISK_NOT_CHECKPOINT_UNCOMPRESSE

This variable shows the size, in bytes, of uncompressed non-leaf nodes flushed to disk not for checkpoint.

Tokudb_NONLEAF_NODES_FLUSHED_TO_DISK_NOT_CHECKPOINT_SECONDS

This variable shows the number of seconds waiting for I/O when writing non-leaf nodes flushed to disk, not for checkpoint

Tokudb_LEAF_NODES_FLUSHED_CHECKPOINT

This variable shows the number of leaf nodes flushed to disk, for checkpoint.

Tokudb_LEAF_NODES_FLUSHED_CHECKPOINT_BYTES

This variable shows the size, in bytes, of leaf nodes flushed to disk, for checkpoint.

Tokudb_LEAF_NODES_FLUSHED_CHECKPOINT_UNCOMPRESSED_BYTES

This variable shows the size, in bytes, of uncompressed leaf nodes flushed to disk for checkpoint.

Tokudb_LEAF_NODES_FLUSHED_CHECKPOINT_SECONDS

This variable shows the number of seconds waiting for I/O when writing leaf nodes flushed to disk for checkpoint

Tokudb_NONLEAF_NODES_FLUSHED_TO_DISK_CHECKPOINT

This variable shows the number of non-leaf nodes flushed to disk, for checkpoint.

Tokudb_NONLEAF_NODES_FLUSHED_TO_DISK_CHECKPOINT_BYTES

This variable shows the size, in bytes, of non-leaf nodes flushed to disk, for checkpoint.

Tokudb_NONLEAF_NODES_FLUSHED_TO_DISK_CHECKPOINT_UNCOMPRESSED_BY

This variable shows the size, in bytes, of uncompressed non-leaf nodes flushed to disk for checkpoint.

Tokudb_NONLEAF_NODES_FLUSHED_TO_DISK_CHECKPOINT_SECONDS

This variable shows the number of seconds waiting for I/O when writing non-leaf nodes flushed to disk for checkpoint

Tokudb_LEAF_NODE_COMPRESSION_RATIO

This variable shows the ratio of uncompressed bytes (in-memory) to compressed bytes (on-disk) for leaf nodes.

Tokudb_NONLEAF_NODE_COMPRESSION_RATIO

This variable shows the ratio of uncompressed bytes (in-memory) to compressed bytes (on-disk) for non-leaf nodes.

Tokudb_OVERALL_NODE_COMPRESSION_RATIO

This variable shows the ratio of uncompressed bytes (in-memory) to compressed bytes (on-disk) for all nodes.

Tokudb_NONLEAF_NODE_PARTIAL_EVICTIONS

This variable shows the number of times a partition of a non-leaf node was evicted from the cache.

Tokudb_NONLEAF_NODE_PARTIAL_EVICTIONS_BYTES

This variable shows the amount, in bytes, of memory freed by evicting partitions of non-leaf nodes from the cache.

Tokudb_LEAF_NODE_PARTIAL_EVICTIONS

This variable shows the number of times a partition of a leaf node was evicted from the cache.

Tokudb_LEAF_NODE_PARTIAL_EVICTIONS_BYTES

This variable shows the amount, in bytes, of memory freed by evicting partitions of leaf nodes from the cache.

Tokudb_LEAF_NODE_FULL_EVICTIONS

This variable shows the number of times a full leaf node was evicted from the cache.

Tokudb_LEAF_NODE_FULL_EVICTIONS_BYTES

This variable shows the amount, in bytes, of memory freed by evicting full leaf nodes from the cache.

Tokudb_NONLEAF_NODE_FULL_EVICTIONS

This variable shows the number of times a full non-leaf node was evicted from the cache.

Tokudb_NONLEAF_NODE_FULL_EVICTIONS_BYTES

This variable shows the amount, in bytes, of memory freed by evicting full non-leaf nodes from the cache.

Tokudb_LEAF_NODES_CREATED

This variable shows the number of created leaf nodes.

Tokudb_NONLEAF_NODES_CREATED

This variable shows the number of created non-leaf nodes.

Tokudb_LEAF_NODES_DESTROYED

This variable shows the number of destroyed leaf nodes.

Tokudb_NONLEAF_NODES_DESTROYED

This variable shows the number of destroyed non-leaf nodes.

Tokudb_MESSAGES_INJECTED_AT_ROOT_BYTES

This variable shows the size, in bytes, of messages injected at root (for all trees).

Tokudb_MESSAGES_FLUSHED_FROM_H1_TO_LEAVES_BYTES

This variable shows the size, in bytes, of messages flushed from h1 nodes to leaves.

Tokudb_MESSAGES_IN_TREES_ESTIMATE_BYTES

This variable shows the estimated size, in bytes, of messages currently in trees.

Tokudb_MESSAGES_INJECTED_AT_ROOT

This variables shows the number of messages that were injected at root node of a tree.

Tokudb_BROADCASE_MESSAGES_INJECTED_AT_ROOT

This variable shows the number of broadcast messages dropped into the root node of a tree. These are things such as the result of OPTIMIZE TABLE and a few other operations. This is not a useful metric for a regular user to use for any purpose.

Tokudb_BASEMENTS_DECOMPRESSED_TARGET_QUERY

This variable shows the number of basement nodes decompressed for queries.

Tokudb_BASEMENTS_DECOMPRESSED_PRELOCKED_RANGE

This variable shows the number of basement nodes aggressively decompressed by queries.

Tokudb_BASEMENTS_DECOMPRESSED_PREFETCH

This variable shows the number of basement nodes decompressed by a prefetch thread.

Tokudb_BASEMENTS_DECOMPRESSED_FOR_WRITE

This variable shows the number of basement nodes decompressed for writes.

Tokudb_BUFFERS_DECOMPRESSED_TARGET_QUERY

This variable shows the number of buffers decompressed for queries.

Tokudb_BUFFERS_DECOMPRESSED_PRELOCKED_RANGE

This variable shows the number of buffers decompressed by queries aggressively.

Tokudb_BUFFERS_DECOMPRESSED_PREFETCH

This variable shows the number of buffers decompressed by a prefetch thread.

Tokudb_BUFFERS_DECOMPRESSED_FOR_WRITE

This variable shows the number of buffers decompressed for writes.

Tokudb_PIVOTS_FETCHED_FOR_QUERY

This variable shows the number of pivot nodes fetched for queries.

Tokudb_PIVOTS_FETCHED_FOR_QUERY_BYTES

This variable shows the number of bytes of pivot nodes fetched for queries.

Tokudb_PIVOTS_FETCHED_FOR_QUERY_SECONDS

This variable shows the number of seconds waiting for I/O when fetching pivot nodes for queries.

Tokudb_PIVOTS_FETCHED_FOR_PREFETCH

This variable shows the number of pivot nodes fetched by a prefetch thread.

Tokudb_PIVOTS_FETCHED_FOR_PREFETCH_BYTES

This variable shows the number of bytes of pivot nodes fetched for queries.

Tokudb_PIVOTS_FETCHED_FOR_PREFETCH_SECONDS

This variable shows the number seconds waiting for I/O when fetching pivot nodes by a prefetch thread.

Tokudb_PIVOTS_FETCHED_FOR_WRITE

This variable shows the number of pivot nodes fetched for writes.

Tokudb_PIVOTS_FETCHED_FOR_WRITE_BYTES

This variable shows the number of bytes of pivot nodes fetched for writes.

Tokudb_PIVOTS_FETCHED_FOR_WRITE_SECONDS

This variable shows the number of seconds waiting for I/O when fetching pivot nodes for writes.

Tokudb_BASEMENTS_FETCHED_TARGET_QUERY

This variable shows the number of basement nodes fetched from disk for queries.

Tokudb_BASEMENTS_FETCHED_TARGET_QUERY_BYTES

This variable shows the number of basement node bytes fetched from disk for queries.

Tokudb_BASEMENTS_FETCHED_TARGET_QUERY_SECONDS

This variable shows the number of seconds waiting for I/O when fetching basement nodes from disk for queries.

Tokudb_BASEMENTS_FETCHED_PRELOCKED_RANGE

This variable shows the number of basement nodes fetched from disk aggressively.

Tokudb_BASEMENTS_FETCHED_PRELOCKED_RANGE_BYTES

This variable shows the number of basement node bytes fetched from disk aggressively.

Tokudb_BASEMENTS_FETCHED_PRELOCKED_RANGE_SECONDS

This variable shows the number of seconds waiting for I/O when fetching basement nodes from disk aggressively.

Tokudb_BASEMENTS_FETCHED_PREFETCH

This variable shows the number of basement nodes fetched from disk by a prefetch thread.

Tokudb_BASEMENTS_FETCHED_PREFETCH_BYTES

This variable shows the number of basement node bytes fetched from disk by a prefetch thread.

Tokudb_BASEMENTS_FETCHED_PREFETCH_SECONDS

This variable shows the number of seconds waiting for I/O when fetching basement nodes from disk by a prefetch thread.

Tokudb_BASEMENTS_FETCHED_FOR_WRITE

This variable shows the number of buffers fetched from disk for writes.

Tokudb_BASEMENTS_FETCHED_FOR_WRITE_BYTES

This variable shows the number of buffer bytes fetched from disk for writes.

Tokudb_BASEMENTS_FETCHED_FOR_WRITE_SECONDS

This variable shows the number of seconds waiting for I/O when fetching buffers from disk for writes.

Tokudb_BUFFERS_FETCHED_TARGET_QUERY

This variable shows the number of buffers fetched from disk for queries.

Tokudb_BUFFERS_FETCHED_TARGET_QUERY_BYTES

This variable shows the number of buffer bytes fetched from disk for queries.

Tokudb_BUFFERS_FETCHED_TARGET_QUERY_SECONDS

This variable shows the number of seconds waiting for I/O when fetching buffers from disk for queries.

Tokudb_BUFFERS_FETCHED_PRELOCKED_RANGE

This variable shows the number of buffers fetched from disk aggressively.

Tokudb_BUFFERS_FETCHED_PRELOCKED_RANGE_BYTES

This variable shows the number of buffer bytes fetched from disk aggressively.

Tokudb_BUFFERS_FETCHED_PRELOCKED_RANGE_SECONDS

This variable shows the number of seconds waiting for I/O when fetching buffers from disk aggressively.

Tokudb_BUFFERS_FETCHED_PREFETCH

This variable shows the number of buffers fetched from disk aggressively.

Tokudb_BUFFERS_FETCHED_PREFETCH_BYTES

This variable shows the number of buffer bytes fetched from disk by a prefetch thread.

Tokudb_BUFFERS_FETCHED_PREFETCH_SECONDS

This variable shows the number of seconds waiting for I/O when fetching buffers from disk by a prefetch thread.

Tokudb_BUFFERS_FETCHED_FOR_WRITE

This variable shows the number of buffers fetched from disk for writes.

Tokudb_BUFFERS_FETCHED_FOR_WRITE_BYTES

This variable shows the number of buffer bytes fetched from disk for writes.

Tokudb_BUFFERS_FETCHED_FOR_WRITE_SECONDS

This variable shows the number of seconds waiting for I/O when fetching buffers from disk for writes.

Tokudb_LEAF_COMPRESSION_TO_MEMORY_SECONDS

This variable shows the total time, in seconds, spent compressing leaf nodes.

Tokudb_LEAF_SERIALIZATION_TO_MEMORY_SECONDS

This variable shows the total time, in seconds, spent serializing leaf nodes.

Tokudb_LEAF_DECOMPRESSION_TO_MEMORY_SECONDS

This variable shows the total time, in seconds, spent decompressing leaf nodes.

Tokudb_LEAF_DESERIALIZATION_TO_MEMORY_SECONDS

This variable shows the total time, in seconds, spent deserializing leaf nodes.

Tokudb_NONLEAF_COMPRESSION_TO_MEMORY_SECONDS

This variable shows the total time, in seconds, spent compressing non leaf nodes.

Tokudb_NONLEAF_SERIALIZATION_TO_MEMORY_SECONDS

This variable shows the total time, in seconds, spent serializing non leaf nodes.

Tokudb_NONLEAF_DECOMPRESSION_TO_MEMORY_SECONDS

This variable shows the total time, in seconds, spent decompressing non leaf nodes.

Tokudb_NONLEAF_DESERIALIZATION_TO_MEMORY_SECONDS

This variable shows the total time, in seconds, spent deserializing non leaf nodes.

Tokudb_PROMOTION_ROOTS_SPLIT

This variable shows the number of times the root split during promotion.

Tokudb_PROMOTION_LEAF_ROOTS_INJECTED_INTO

This variable shows the number of times a message stopped at a root with height 0.

Tokudb_PROMOTION_H1_ROOTS_INJECTED_INTO

This variable shows the number of times a message stopped at a root with height 1.

Tokudb_PROMOTION_INJECTIONS_AT_DEPTH_0

This variable shows the number of times a message stopped at depth 0.

Tokudb_PROMOTION_INJECTIONS_AT_DEPTH_1

This variable shows the number of times a message stopped at depth 1.

Tokudb_PROMOTION_INJECTIONS_AT_DEPTH_2

This variable shows the number of times a message stopped at depth 2.

Tokudb_PROMOTION_INJECTIONS_AT_DEPTH_3

This variable shows the number of times a message stopped at depth 3.

Tokudb_PROMOTION_INJECTIONS_LOWER_THAN_DEPTH_3

This variable shows the number of times a message was promoted past depth 3.

Tokudb_PROMOTION_STOPPED_NONEMPTY_BUFFER

This variable shows the number of times a message stopped because it reached a nonempty buffer.

Tokudb_PROMOTION_STOPPED_AT_HEIGHT_1

This variable shows the number of times a message stopped because it had reached height 1.

Tokudb_PROMOTION_STOPPED_CHILD_LOCKED_OR_NOT_IN_MEMORY

This variable shows the number of times a message stopped because it could not cheaply get access to a child.

Tokudb_PROMOTION_STOPPED_CHILD_NOT_FULLY_IN_MEMORY

This variable shows the number of times a message stopped because it could not cheaply get access to a child.

Tokudb_PROMOTION_STOPPED_AFTER_LOCKING_CHILD

This variable shows the number of times a message stopped before a child which had been locked.

Tokudb_BASEMENT_DESERIALIZATION_FIXED_KEY

This variable shows the number of basement nodes deserialized where all keys had the same size, leaving the basement in a format that is optimal for in-memory workloads.

Tokudb_BASEMENT_DESERIALIZATION_VARIABLE_KEY

This variable shows the number of basement nodes deserialized where all keys did not have the same size, and thus ineligible for an in-memory optimization.

Tokudb_PRO_RIGHTMOST_LEAF_SHORTCUT_SUCCESS

This variable shows the number of times a message injection detected a series of sequential inserts to the rightmost side of the tree and successfully applied an insert message directly to the rightmost leaf node. This is a not a useful value for a regular user to use for any purpose.

Tokudb_PRO_RIGHTMOST_LEAF_SHORTCUT_FAIL_POS

This variable shows the number of times a message injection detected a series of sequential inserts to the rightmost side of the tree and was unable to follow the pattern of directly applying an insert message directly to the rightmost leaf node because the key does not continue the sequence. This is a not a useful value for a regular user to use for any purpose.

Tokudb_RIGHTMOST_LEAF_SHORTCUT_FAIL_REACTIVE

This variable shows the number of times a message injection detected a series of sequential inserts to the rightmost side of the tree and was unable to follow the pattern of directly applying an insert message directly to the rightmost leaf node because the leaf is full. This is a not a useful value for a regular user to use for any purpose.

Tokudb_CURSOR_SKIP_DELETED_LEAF_ENTRY

This variable shows the number of leaf entries skipped during search/scan because the result of message application and reconciliation of the leaf entry MVCC stack reveals that the leaf entry is deleted in the current transactions view. It is a good indicator that there might be excessive garbage in a tree if a range scan seems to take too long.

Tokudb_FLUSHER_CLEANER_TOTAL_NODES

This variable shows the total number of nodes potentially flushed by flusher or cleaner threads. This is a not a useful value for a regular user to use for any purpose.

Tokudb_FLUSHER_CLEANER_H1_NODES

This variable shows the number of height 1 nodes that had messages flushed by flusher or cleaner threads, i.e., internal nodes immediately above leaf nodes. This is a not a useful value for a regular user to use for any purpose.

Tokudb_FLUSHER_CLEANER_HGT1_NODES

This variable shows the number of nodes with height greater than 1 that had messages flushed by flusher or cleaner threads. This is a not a useful value for a regular user to use for any purpose.

Tokudb_FLUSHER_CLEANER_EMPTY_NODES

This variable shows the number of nodes cleaned by flusher or cleaner threads which had empty message buffers. This is a not a useful value for a regular user to use for any purpose.

Tokudb_FLUSHER_CLEANER_NODES_DIRTIED

This variable shows the number of nodes dirtied by flusher or cleaner threads as a result of flushing messages downward. This is a not a useful value for a regular user to use for any purpose.

Tokudb_FLUSHER_CLEANER_MAX_BUFFER_SIZE

This variable shows the maximum bytes in a message buffer flushed by flusher or cleaner threads. This is a not a useful value for a regular user to use for any purpose.

Tokudb_FLUSHER_CLEANER_MIN_BUFFER_SIZE

This variable shows the minimum bytes in a message buffer flushed by flusher or cleaner threads. This is a not a useful value for a regular user to use for any purpose.

Tokudb_FLUSHER_CLEANER_TOTAL_BUFFER_SIZE

This variable shows the total bytes in buffers flushed by flusher and cleaner threads. This is a not a useful value for a regular user to use for any purpose.

Tokudb_FLUSHER_CLEANER_MAX_BUFFER_WORKDONE

This variable shows the maximum bytes worth of work done in a message buffer flushed by flusher or cleaner threads. This is a not a useful value for a regular user to use for any purpose.

Tokudb_FLUSHER_CLEANER_MIN_BUFFER_WORKDONE

This variable shows the minimum bytes worth of work done in a message buffer flushed by flusher or cleaner threads. This is a not a useful value for a regular user to use for any purpose.

Tokudb_FLUSHER_CLEANER_TOTAL_BUFFER_WORKDONE

This variable shows the total bytes worth of work done in buffers flushed by flusher or cleaner threads. This is a not a useful value for a regular user to use for any purpose.

Tokudb_FLUSHER_CLEANER_NUM_LEAF_MERGES_STARTED

This variable shows the number of times flusher and cleaner threads tried to merge two leafs. This is a not a useful value for a regular user to use for any purpose.

Tokudb_FLUSHER_CLEANER_NUM_LEAF_MERGES_RUNNING

This variable shows the number of flusher and cleaner threads leaf merges in progress. This is a not a useful value for a regular user to use for any purpose.

Tokudb_FLUSHER_CLEANER_NUM_LEAF_MERGES_COMPLETED

This variable shows the number of successful flusher and cleaner threads leaf merges. This is a not a useful value for a regular user to use for any purpose.

Tokudb_FLUSHER_CLEANER_NUM_DIRTIED_FOR_LEAF_MERGE

This variable shows the number of nodes dirtied by flusher or cleaner threads performing leaf node merges. This is a not a useful value for a regular user to use for any purpose.

Tokudb_FLUSHER_FLUSH_TOTAL

This variable shows the total number of flushes done by flusher threads or cleaner threads. This is a not a useful value for a regular user to use for any purpose.

Tokudb_FLUSHER_FLUSH_IN_MEMORY

This variable shows the number of in memory flushes (required no disk reads) by flusher or cleaner threads. This is a not a useful value for a regular user to use for any purpose.

Tokudb_FLUSHER_FLUSH_NEEDED_IO

This variable shows the number of flushes that read something off disk by flusher or cleaner threads. This is a not a useful value for a regular user to use for any purpose.

Tokudb_FLUSHER_FLUSH_CASCADES

This variable shows the number of flushes that triggered a flush in child node by flusher or cleaner threads. This is a not a useful value for a regular user to use for any purpose.

Tokudb_FLUSHER_FLUSH_CASCADES_1

This variable shows the number of flushes that triggered one cascading flush by flusher or cleaner threads. This is a not a useful value for a regular user to use for any purpose.

Tokudb_FLUSHER_FLUSH_CASCADES_2

This variable shows the number of flushes that triggered two cascading flushes by flusher or cleaner threads. This is a not a useful value for a regular user to use for any purpose.

Tokudb_FLUSHER_FLUSH_CASCADES_3

This variable shows the number of flushes that triggered three cascading flushes by flusher or cleaner threads. This is a not a useful value for a regular user to use for any purpose.

Tokudb_FLUSHER_FLUSH_CASCADES_4

This variable shows the number of flushes that triggered four cascading flushes by flusher or cleaner threads. This is a not a useful value for a regular user to use for any purpose.

Tokudb_FLUSHER_FLUSH_CASCADES_5

This variable shows the number of flushes that triggered five cascading flushes by flusher or cleaner threads. This is a not a useful value for a regular user to use for any purpose.

Tokudb_FLUSHER_FLUSH_CASCADES_GT_5

This variable shows the number of flushes that triggered more than five cascading flushes by flusher or cleaner threads. This is a not a useful value for a regular user to use for any purpose.

Tokudb_FLUSHER_SPLIT_LEAF

This variable shows the total number of leaf node splits done by flusher threads or cleaner threads. This is a not a useful value for a regular user to use for any purpose.

Tokudb_FLUSHER_SPLIT_NONLEAF

This variable shows the total number of non-leaf node splits done by flusher threads or cleaner threads. This is a not a useful value for a regular user to use for any purpose.

Tokudb_FLUSHER_MERGE_LEAF

This variable shows the total number of leaf node merges done by flusher threads or cleaner threads. This is a not a useful value for a regular user to use for any purpose.

Tokudb_FLUSHER_MERGE_NONLEAF

This variable shows the total number of non-leaf node merges done by flusher threads or cleaner threads. This is a not a useful value for a regular user to use for any purpose.

Tokudb_FLUSHER_BALANCE_LEAF

This variable shows the number of times two adjacent leaf nodes were rebalanced or had their content redistributed evenly by flusher or cleaner threads. This is a not a useful value for a regular user to use for any purpose.

Tokudb_HOT_NUM_STARTED

This variable shows the number of hot operations started (OPTIMIZE TABLE). This is a not a useful value for a regular user to use for any purpose.

Tokudb_HOT_NUM_COMPLETED

This variable shows the number of hot operations completed (OPTIMIZE TABLE). This is a not a useful value for a regular user to use for any purpose.

Tokudb_HOT_NUM_ABORTED

This variable shows the number of hot operations aborted (OPTIMIZE TABLE). This is a not a useful value for a regular user to use for any purpose.

Tokudb_HOT_MAX_ROOT_FLUSH_COUNT

This variable shows the maximum number of flushes from root ever required to optimize trees. This is a not a useful value for a regular user to use for any purpose.

Tokudb_TXN_BEGIN

This variable shows the number of transactions that have been started.

Tokudb_TXN_BEGIN_READ_ONLY

This variable shows the number of read-only transactions started.

Tokudb_TXN_COMMITS

This variable shows the total number of transactions that have been committed.

Tokudb_TXN_ABORTS

This variable shows the total number of transactions that have been aborted.

Tokudb_LOGGER_NEXT_LSN

This variable shows the recovery logger next LSN. This is a not a useful value for a regular user to use for any purpose.

Tokudb_LOGGER_WRITES

This variable shows the number of times the logger has written to disk.

Tokudb_LOGGER_WRITES_BYTES

This variable shows the number of bytes the logger has written to disk.

Tokudb_LOGGER_WRITES_UNCOMPRESSED_BYTES

This variable shows the number of uncompressed bytes the logger has written to disk.

Tokudb_LOGGER_WRITES_SECONDS

This variable shows the number of seconds waiting for IO when writing logs to disk.

Tokudb_LOGGER_WAIT_LONG

This variable shows the number of times a logger write operation required 100ms or more.

Tokudb_LOADER_NUM_CREATED

This variable shows the number of times one of our internal objects, a loader, has been created.

Tokudb_LOADER_NUM_CURRENT

This variable shows the number of loaders that currently exist.

Tokudb_LOADER_NUM_MAX

This variable shows the maximum number of loaders that ever existed simultaneously.

Tokudb_MEMORY_MALLOC_COUNT

This variable shows the number of malloc operations by PerconaFT.

Tokudb_MEMORY_FREE_COUNT

This variable shows the number of free operations by PerconaFT.

Tokudb_MEMORY_REALLOC_COUNT

This variable shows the number of realloc operations by PerconaFT.

Tokudb_MEMORY_MALLOC_FAIL

This variable shows the number of malloc operations that failed by PerconaFT.

Tokudb_MEMORY_REALLOC_FAIL

This variable shows the number of realloc operations that failed by PerconaFT.

Tokudb_MEMORY_REQUESTED

This variable shows the number of bytes requested by PerconaFT.

Tokudb_MEMORY_USED

This variable shows the number of bytes used (requested + overhead) by PerconaFT.

Tokudb_MEMORY_FREED

This variable shows the number of bytes freed by PerconaFT.

Tokudb_MEMORY_MAX_REQUESTED_SIZE

This variable shows the largest attempted allocation size by PerconaFT.

Tokudb_MEMORY_LAST_FAILED_SIZE

This variable shows the size of the last failed allocation attempt by PerconaFT.

Tokudb_MEM_ESTIMATED_MAXIMUM_MEMORY_FOOTPRINT

This variable shows the maximum memory footprint of the storage engine, the max value of (used - freed).

Tokudb_MEMORY_MALLOCATOR_VERSION

This variable shows the version of the memory allocator library detected by PerconaFT.

Tokudb_MEMORY_MMAP_THRESHOLD

This variable shows the mmap threshold in PerconaFT, anything larger than this gets mmap'ed.

Tokudb_FILESYSTEM_THREADS_BLOCKED_BY_FULL_DISK

This variable shows the number of threads that are currently blocked because they are attempting to write to a full disk. This is normally zero. If this value is non-zero, then a warning will appear in the disk free space field.

Tokudb_FILESYSTEM_FSYNC_TIME

This variable shows the total time, in microseconds, used to fsync to disk.

Tokudb_FILESYSTEM_FSYNC_NUM

This variable shows the total number of times the database has flushed the operating system’s file buffers to disk.

Tokudb_FILESYSTEM_LONG_FSYNC_TIME

This variable shows the total time, in microseconds, used to fsync to dis k when the operation required more than one second.

Tokudb_FILESYSTEM_LONG_FSYNC_NUM

This variable shows the total number of times the database has flushed the operating system’s file buffers to disk and this operation required more than one second.

Contact us

For free technical help, visit the Percona Community Forum.

To report bugs or submit feature requests, open a JIRA ticket.

For paid support and managed or consulting services , contact Percona Sales.

---

Last update: 2023-01-12