W3cubDocs

/MariaDB

TokuDB Status Variables

This page documents status variables related to the TokuDB storage engine. See Server Status Variables for a complete list of status variables that can be viewed with SHOW STATUS.

See also the Full list of MariaDB options, system and status variables.

Tokudb_basement_deserialization_fixed_key

  • Description: Number of deserialized basement nodes where all keys were the same size. This leaves the basement in an optimal format for in-memory workloads.

Tokudb_basement_deserialization_variable_key

  • Description: Number of deserialized basement nodes where all keys had different size keys, which are not eligible for in-memory optimization.

Tokudb_basements_decompressed_for_write

  • Description: Number of basement nodes decompressed for write operations.

Tokudb_basements_decompressed_prefetch


Tokudb_basements_decompressed_prelocked_range

  • Description: Number of basement nodes aggressively decompressed by queries.

Tokudb_basements_decompressed_target_query

  • Description: Number of basement nodes decompressed for queries

Tokudb_basements_fetched_for_write

  • Description: Number of basement nodes fetched for writes off the disk.

Tokudb_basements_fetched_for_write_bytes

  • Description: Total basement node bytes fetched for writes off the disk.

Tokudb_basements_fetched_for_write_seconds

  • Description: Time in seconds spent waiting for IO while fetching basement nodes from disk for writes.

Tokudb_basements_fetched_prefetch

  • Description: Number of basement nodes fetched off the disk by a prefetch thread.

Tokudb_basements_fetched_prefetch_bytes

  • Description: Total basement node bytes fetched off the disk by a prefetch thread..

Tokudb_basements_fetched_prefetch_seconds

  • Description: Time in seconds spent waiting for IO while fetching off the disk by a prefetch thread.

Tokudb_basements_fetched_prelocked_range

  • Description: Number of basement nodes aggressively fetched from disk.

Tokudb_basements_fetched_prelocked_range_bytes

  • Description: Total basement node bytes aggressively fetched off the disk.

Tokudb_basements_fetched_prelocked_range_seconds

  • Description: Time in seconds spent waiting for IO while aggressively fetching basement nodes from disk.

Tokudb_basements_fetched_target_query

  • Description: Number of basement nodes fetched for queries off the disk.

Tokudb_basements_fetched_target_query_bytes

  • Description: Total basement node bytes fetched for queries off the disk.

Tokudb_basements_fetched_target_query_seconds

  • Description: Time in seconds spent waiting for IO while fetching basement nodes from disk for queries.

Tokudb_broadcase_messages_injected_at_root

  • Description: Number of broadcast messages injected at root.

Tokudb_buffers_decompressed_for_write

  • Description: Number of buffers decompressed for writes.

Tokudb_buffers_decompressed_prefetch

  • Description: Number of buffers decompressed by a prefetch thread.

Tokudb_buffers_decompressed_prelocked_range

  • Description: Number of buffers decompressed for queries.

Tokudb_buffers_decompressed_target_query

  • Description: Number of buffers aggressively decompressed by queries.

Tokudb_buffers_fetched_for_write

  • Description: Number of buffers fetched for write off the disk.

Tokudb_buffers_fetched_for_write_bytes

  • Description: Total buffer bytes fetched for writes off the disk.

Tokudb_buffers_fetched_for_write_seconds

  • Description: Time in seconds spent waiting for IO while fetching buffers from disk for writes.

Tokudb_buffers_fetched_prefetch

  • Description: Number of buffers fetched for queries off the disk by a prefetch thread.

Tokudb_buffers_fetched_prefetch_bytes

  • Description: Total buffer bytes fetched for queries off the disk by a prefetch thread.

Tokudb_buffers_fetched_prefetch_seconds

  • Description: Time in seconds spent waiting for IO while fetching buffers from disk for queries by a prefetch thread.

Tokudb_buffers_fetched_prelocked_range

  • Description: Number of buffers aggressively fetched for queries off the disk.

Tokudb_buffers_fetched_prelocked_range_bytes

  • Description: Total buffer bytes aggressively fetched for queries off the disk.

Tokudb_buffers_fetched_prelocked_range_seconds

  • Description: Time in seconds spent waiting for IO while aggressively fetching buffers from disk for queries.

Tokudb_buffers_fetched_target_query

  • Description: Number of buffers fetched for queries off the disk.

Tokudb_buffers_fetched_target_query_bytes

  • Description: Total buffer bytes fetched for queries off the disk.

Tokudb_buffers_fetched_target_query_seconds

  • Description: Time in seconds spent waiting for IO while fetching buffers from disk for queries.

Tokudb_cachetable_cleaner_executions

  • Description: Number of times the cleaner thread loop has executed.

Tokudb_cachetable_cleaner_iterations

  • Description: Number of cleaner operations performed each cleaner period.

Tokudb_cachetable_cleaner_period

  • Description: Time in seconds between the end of a group of cleaner operations and the beginning of the next. The TokuDB cleaner thread runs in the background, optimizing indexes and performing work not needing to be done by the client thread.

Tokudb_cachetable_evictions

  • Description: Number of blocks evicted from the cache.

Tokudb_cachetable_long_wait_pressure_count

  • Description: Number of times a thread was stalled for more than one second due to cache pressure.

Tokudb_cachetable_long_wait_pressure_time

  • Description: Time in microseconds spent waiting for more than one second for cache pressure to ease.

Tokudb_cachetable_miss

  • Description: Number of times the system failed to access data in the internal cache.

Tokudb_cachetable_miss_time

  • Description: Total time in microseconds spent waiting for disk reads (when the cache could not supply the data) to finish.

Tokudb_cachetable_prefetches

  • Description: Total number of times that a block of memory was prefetched into the database cache. This happens when it's determined that a block of memory is likely to be accessed by the application.

Tokudb_cachetable_size_cachepressure

  • Description: Size in bytes of data causing cache pressure, or the sum of the buffers and workdone counters.

Tokudb_cachetable_size_cloned

  • Description: Memory in bytes currently used for cloned nodes. Dirty nodes are cloned before serialization/compression during checkpoint operations, after which they are written to disk and the memory freed for re-use.

Tokudb_cachetable_size_current

  • Description: Size in bytes of the uncompressed data in the cache.

Tokudb_cachetable_size_leaf

  • Description: Size in bytes of the leaf nodes in the cache.

Tokudb_cachetable_size_limit

  • Description: Size in bytes of the uncompressed data that could fit in the cache.

Tokudb_cachetable_size_nonleaf

  • Description: Size in bytes of the nonleaf nodes in the cache.

Tokudb_cachetable_size_rollback

  • Description: Size in bytes of the rollback nodes in the cache.

Tokudb_cachetable_size_writing

  • Description: Size in bytes currently queued to be written to disk.

Tokudb_cachetable_wait_pressure_count

  • Description: Number of times a thread was stalled due to cache pressure.

Tokudb_cachetable_wait_pressure_time

  • Description: Time in microseconds spent waiting for cache pressure to ease.

Tokudb_checkpoint_begin_time

  • Description: Cumulative time in microseconds needed to mark all dirty nodes as pending a checkpoint.

Tokudb_checkpoint_duration

  • Description: Time in seconds needed to complete all checkpoints.

Tokudb_checkpoint_duration_last

  • Description: Time in seconds needed to complete the last checkpoint.

Tokudb_checkpoint_failed

  • Description: Total number of checkpoints failed.

Tokudb_checkpoint_last_began

  • Description: Date and time the most recent checkpoint began, for example Wed May 14 11:26:42 2014 Will be Dec 31, 1969 on Linux if no checkpoint has ever begun.

Tokudb_checkpoint_last_complete_began

  • Description: Date and time the last complete checkpoint started.

Tokudb_checkpoint_last_complete_ended

  • Description: Date and time the last complete checkpoint ended.

Tokudb_checkpoint_long_begin_count

  • Description: Number of long checkpoint begins (checkpoint begins taking more than 1 second).

Tokudb_checkpoint_long_begin_time

  • Description: Total time in microseconds of long checkpoint begins (checkpoint begins taking more than 1 second).

Tokudb_checkpoint_period

  • Description: Time in seconds between the end of one automatic checkpoint and the beginning of the next.

Tokudb_checkpoint_taken

  • Description: Total number of checkpoints taken.

Tokudb_cursor_skip_deleted_leaf_entry

  • Description: Deleted leaf entries skipped during a range scan.
  • Introduced: TokuDB 7.5.4

Tokudb_db_closes

  • Description: Number of db_close operations.

Tokudb_db_open_current

  • Description: Number of databases currently open.

Tokudb_db_open_max

  • Description: Maximum of number of databases open at the same time.

Tokudb_db_opens

  • Description: Number of db_open operations.

Tokudb_descriptor_set

  • Description: Number of times a descriptor was updated when the entire dictionary was updated.

Tokudb_dictionary_broadcast_updates

  • Description: Number of successful broadcast updates (an update that affects all rows in a dictionary).

Tokudb_dictionary_updates

  • Description: Total number of rows updated in all primary and secondary indexes that have been done with a separate recovery log entry per index.

Tokudb_filesystem_fsync_num

  • Description: Total number of times the database has flushed the operating system’s file buffers to disk.

Tokudb_filesystem_fsync_time

  • Description: Total time in microseconds used to fsync to disk.

Tokudb_filesystem_long_fsync_num

  • Description: Total number of times the database has flushed the operating system’s file buffers to disk when the operation took more than one second.

Tokudb_filesystem_long_fsync_time

  • Description: Total time in microseconds used to fsync to disk when the operation took more than one second.

Tokudb_filesystem_threads_blocked_by_full_disk

  • Description: Number of threads currently blocked due to attempting to write to a full disk. A warning appears in the disk free space field if not zero.

Tokudb_leaf_compression_to_memory_seconds

  • Description: Time in seconds spent on compressing leaf nodes.

Tokudb_leaf_decompression_to_memory_seconds

  • Description: Time in seconds spent on decompressing leaf nodes.

Tokudb_leaf_deserialization_to_memory_seconds

  • Description: Time in seconds spent on deserializing leaf nodes.

Tokudb_leaf_node_compression_ratio

  • Description: Ratio of uncompressed bytes in-memory to compressed bytes on-disk for leaf nodes.

Tokudb_leaf_node_full_evictions

  • Description: Number of times a full leaf node was evicted from the cache.

Tokudb_leaf_node_full_evictions_bytes

  • Description: Total bytes freed when a full leaf node was evicted from the cache.

Tokudb_leaf_node_partial_evictions

  • Description: Number of times part of a leaf node (a partition) was evicted from the cache.

Tokudb_leaf_node_partial_evictions_bytes

  • Description: Total bytes freed when part of a leaf node (a partition) was evicted from the cache.

Tokudb_leaf_nodes_created

  • Description: Total number of leaf nodes created.

Tokudb_leaf_nodes_destroyed

  • Description: Total number of leaf nodes destroyed.

Tokudb_leaf_nodes_flushed_checkpoint

  • Description: Number of leaf nodes flushed to disk as part of a checkpoint.

Tokudb_leaf_nodes_flushed_checkpoint_bytes

  • Description: Size in bytes of leaf nodes flushed to disk as part of a checkpoint.

Tokudb_leaf_nodes_flushed_checkpoint_seconds

  • Description: Time in seconds spent waiting for IO while writing leaf nodes flushed to disk as part of a checkpoint.

Tokudb_leaf_nodes_flushed_checkpoint_uncompressed_bytes

  • Description: Size in uncompressed bytes of leaf nodes flushed to disk as part of a checkpoint.

Tokudb_leaf_nodes_flushed_not_checkpoint

  • Description: Number of leaf nodes flushed to disk not as part of a checkpoint.

Tokudb_leaf_nodes_flushed_not_checkpoint_bytes

  • Description: Size in bytes of leaf nodes flushed to disk not as part of a checkpoint.

Tokudb_leaf_nodes_flushed_not_checkpoint_seconds

  • Description: Time in seconds spent waiting for IO while writing leaf nodes flushed to disk not as part of a checkpoint.

Tokudb_leaf_nodes_flushed_not_checkpoint_uncompressed_bytes

  • Description: Size in uncompressed bytes of leaf nodes flushed to disk not as part of a checkpoint.

Tokudb_leaf_serialization_to_memory_seconds

  • Description: Time in seconds spent on serializing leaf nodes.

Tokudb_loader_num_created

  • Description: Number of times a loader has been created.

Tokudb_loader_num_current

  • Description: Number of currently existing loaders.

Tokudb_loader_num_max

  • Description: Maximum number of loaders that existed at one time.

Tokudb_locktree_escalation_num

  • Description: Number of times the locktree needed reduce its memory footprint by running lock escalation.

Tokudb_locktree_escalation_seconds

  • Description: Time in seconds spent performing locktree escalation.

Tokudb_locktree_latest_post_escalation_memory_size

  • Description: Memory size in bytes of the locktree after most recent locktree escalation.

Tokudb_locktree_long_wait_count

  • Description: Number of times of more than one second duration that a lock could not be acquired as a result of a conflict with another transaction.

Tokudb_locktree_long_wait_escalation_count

  • Description: Number of times a client thread waited for more than one second for lock escalation to free up memory.

Tokudb_locktree_long_wait_escalation_time

  • Description: Time in microseconds of long waits (more than one second) for lock escalation to free up memory.

Tokudb_locktree_long_wait_time

  • Description:Total time in microseconds spent by clients waiting for more than one second for a lock conflict to be resolved.

Tokudb_locktree_memory_size

  • Description: Memory in bytes currently being used by the locktree.

Tokudb_locktree_memory_size_limit

  • Description: Maximum memory in bytes the locktree can use.

Tokudb_locktree_open_current

  • Description: Number of currently open locktrees.

Tokudb_locktree_pending_lock_requests

  • Description: Number of requests waiting for a lock to be granted.

Tokudb_locktree_sto_eligible_num

  • Description: Number of locktrees eligible for single transaction optimizations.

Tokudb_locktree_sto_ended_num

  • Description: Total number of times a single transaction optimization completed early as a result of another transaction beginning.

Tokudb_locktree_sto_ended_seconds

  • Description: Time in seconds spent ending single transaction optimizations.

Tokudb_locktree_timeout_count

  • Description: Number of times a lock request timed out.

Tokudb_locktree_wait_count

  • Description: Number of times a lock could not be acquired as a result of a conflict with another transaction.

Tokudb_locktree_wait_escalation_count

  • Description: Number of times a client thread has waited on lock escalation. Lock escalation is run on a background thread when the sum of the acquired lock sizes reaches the lock tree limit.

Tokudb_locktree_wait_escalation_time

  • Description: Time in microseconds that a client thread spent waiting for lock escalation.

Tokudb_locktree_wait_time

  • Description: Total time in microseconds spent by clients waiting for a lock conflict to be resolved.

Tokudb_logger_wait_long

  • Description:

Tokudb_logger_writes

  • Description: Number of times the logger has written to disk.

Tokudb_logger_writes_bytes

  • Description: Total bytes the logger has written to disk.

Tokudb_logger_writes_seconds

  • Description: Time in seconds spent waiting for IO while writing logs to disk.

Tokudb_logger_writes_uncompressed_bytes

  • Description: Total uncompressed bytes the logger has written to disk.

Tokudb_mem_estimated_maximum_memory_footprint

  • Description:

Tokudb_messages_flushed_from_h1_to_leaves_bytes

  • Description: Total bytes of the messages flushed from h1 nodes to leaves.

Tokudb_messages_ignored_by_leaf_due_to_msn

  • Description: Number of messages ignored by a leaf because it had already been applied.

Tokudb_messages_in_trees_estimate_bytes

  • Description: Estimate of the total bytes of messages currently in trees.

Tokudb_messages_injected_at_root

  • Description: Number of messages injected at root.

Tokudb_messages_injected_at_root_bytes

  • Description: Total bytes of messages injected at root for all trees.

Tokudb_nonleaf_compression_to_memory_seconds

  • Description: Time in seconds spent on compressing non-leaf nodes.

Tokudb_nonleaf_decompression_to_memory_seconds

  • Description: Time in seconds spent on decompressing non-leaf nodes.

Tokudb_nonleaf_deserialization_to_memory_seconds

  • Description: Time in seconds spent on deserializing non-leaf nodes.

Tokudb_nonleaf_node_compression_ratio

  • Description: Ratio of uncompressed bytes in-memory to compressed bytes on-disk for nonleaf nodes.

Tokudb_nonleaf_node_full_evictions

  • Description: Number of times a full non-leaf node was evicted from the cache.

Tokudb_nonleaf_node_full_evictions_bytes

  • Description: Total bytes freed when a full non-leaf node was evicted from the cache.

Tokudb_nonleaf_node_partial_evictions

  • Description: Number of times part of a non-leaf node (a partition) was evicted from the cache.

Tokudb_nonleaf_node_partial_evictions_bytes

  • Description: Total bytes freed when part of a non-leaf node (a partition) was evicted from the cache.

Tokudb_nonleaf_nodes_created

  • Description: Total number of non-leaf nodes created.

Tokudb_nonleaf_nodes_destroyed

  • Description: Total number of non-leaf nodes destroyed.

Tokudb_nonleaf_nodes_flushed_to_disk_checkpoint

  • Description: Number of non-leaf nodes flushed to disk as part of a checkpoint.

Tokudb_nonleaf_nodes_flushed_to_disk_checkpoint_bytes

  • Description: Size in bytes of non-leaf nodes flushed to disk as part of a checkpoint.

Tokudb_nonleaf_nodes_flushed_to_disk_checkpoint_seconds

  • Description: Time in seconds spent waiting for IO while writing non-leaf nodes flushed to disk as part of a checkpoint.

Tokudb_nonleaf_nodes_flushed_to_disk_checkpoint_uncompressed_bytes

  • Description: Size in uncompressed bytes of non-leaf nodes flushed to disk as part of a checkpoint.

Tokudb_nonleaf_nodes_flushed_to_disk_not_checkpoint

  • Description: Number of non-leaf nodes flushed to disk not as part of a checkpoint.

Tokudb_nonleaf_nodes_flushed_to_disk_not_checkpoint_bytes

  • Description: Size in bytes of non-leaf nodes flushed to disk not as part of a checkpoint.

Tokudb_nonleaf_nodes_flushed_to_disk_not_checkpoint_seconds

  • Description: Time in seconds spent waiting for IO while writing non-leaf nodes flushed to disk not as part of a checkpoint.

Tokudb_nonleaf_nodes_flushed_to_disk_not_checkpoint_uncompressed_bytes

  • Description: Size in uncompressed bytes of non-leaf nodes flushed to disk not as part of a checkpoint.

Tokudb_nonleaf_serialization_to_memory_seconds

  • Description: Time in seconds spent on serializing nonleaf nodes.

Tokudb_overall_node_compression_ratio

  • Description: Ratio of uncompressed bytes in-memory to compressed bytes on-disk for all nodes.

Tokudb_pivots_fetched_for_query

  • Description: Total number of pivot nodes fetched for queries.

Tokudb_pivots_fetched_for_query_bytes

  • Description: Number of bytes of pivot nodes fetched for queries.

Tokudb_pivots_fetched_for_query_seconds

  • Description: Time in seconds spent waiting for IO while fetching pivot nodes for queries.

Tokudb_pivots_fetched_for_prefetch

  • Description: Total number of pivot nodes fetched by a prefetch thread.

Tokudb_pivots_fetched_for_prefetch_bytes

  • Description: Number of bytes of pivot nodes fetched by a prefetch thread.

Tokudb_pivots_fetched_for_prefetch_seconds

  • Description: Time in seconds spent waiting for IO while fetching pivot nodes by a prefetch thread.

Tokudb_pivots_fetched_for_write

  • Description: Total number of pivot nodes fetched for writes.

Tokudb_pivots_fetched_for_write_bytes

  • Description: Number of bytes of pivot nodes fetched for writes.

Tokudb_pivots_fetched_for_write_seconds

  • Description: Time in seconds spent waiting for IO while fetching pivot nodes for writes.

Tokudb_promotion_h1_roots_injected_into

  • Description: Number of times a message stopped at a root with a height of 1.

Tokudb_promotion_injections_at_depth_0

  • Description: Number of times a message stopped at a depth of zero.

Tokudb_promotion_injections_at_depth_1

  • Description: Number of times a message stopped at a depth of one.

Tokudb_promotion_injections_at_depth_2

  • Description: Number of times a message stopped at a depth of two.

Tokudb_promotion_injections_at_depth_3

  • Description: Number of times a message stopped at a depth of three.

Tokudb_promotion_injections_lower_than_depth_3

  • Description: Number of times a message stopped at a depth of greater than three.

Tokudb_promotion_leaf_roots_injected_into

  • Description: Number of times a message stopped at a root with a height of 0.

Tokudb_promotion_roots_split

  • Description: Number of times the root split during promotion.

Tokudb_promotion_stopped_after_locking_child

  • Description: Number of times a message stopped before a locked child.

Tokudb_promotion_stopped_at_height_1

  • Description: Number of times a message stopped due to reaching a height of one.

Tokudb_promotion_stopped_child_locked_or_not_in_memory

  • Description: Number of times a message stopped due to being unable to cheaply access (locked or not stored in memory) a child.

Tokudb_promotion_stopped_child_not_fully_in_memory

  • Description: Number of times a message stopped due to being unable to cheaply access (not fully stored in memory) a child.

Tokudb_promotion_stopped_nonempty_buffer

  • Description: Number of times a message stopped due to reaching a buffer that wasn't empty.

Tokudb_txn_aborts

  • Description: Number of transactions that have been aborted.

Tokudb_txn_begin

  • Description: Number of transactions that have been started.

Tokudb_txn_begin_read_only

  • Description: Number of read-only transactions that have been started.

Tokudb_txn_commits

  • Description: Number of transactions that have been committed.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/tokudb-status-variables/