Because we, the MariaDB developers, don't want to add a lot of new features or big code changes to a stable release, not all TokuDB features are merged at once into MariaDB. Instead they are added in stages.

On this page we list all the known differences between the TokuDB from Tokutek and the default MariaDB version from MariaDB.org:

All MariaDB versions

• TokuDB is not the default storage engine.

  • If you want to enable this, you have to start mysqld with: --default-storage-engine=tokudb.

• Auto increment for second part of a key behaves as documented (and as it does in MyISAM and other storage engines).

• The DDL syntax is different. While binaries from Tokutek have the patched SQL parser, TokuDB in MariaDB uses the special . Thus in Tokutek binaries you write CLUSTERED KEY (columns) and, for example, ROW_FORMAT=TOKUDB_LZMA. And in MariaDB you write KEY (columns) CLUSTERING=YES and COMPRESSION=TOKUDB_LZMA.

Features missing in

• No online .

  • All alter table that changes data or indexes requires a table copy.

• No online .

• No INSERT NOAR or UPDATE NOAR

Features missing in

(starting from 10.0.5) has online . So the features missing are:

• No INSERT NOAR or UPDATE NOAR commands.

  • We are working with Tokutek to improve this feature before adding it to MariaDB.

• No online before (r4199)

Version of the TokuDB plugin included on MariaDB

This is found on the page.

_{This page is licensed: CC BY-SA / Gnu FDL}

The TokuDB storage engine is for use in high-performance and write-intensive environments, offering increased compression and better performance.

It is available in an open-source version, included with 64-bit MariaDB (but not enabled by default), and an Enterprise edition available from Tokutek.

Note that the default value of tokudb_pk_insert_mode will prevent row-based replication from working. To use RBR, change the value of this variable.

The version of TokuDB in your local MariaDB is available by querying the tokudb_version status variable:

SHOW VARIABLES LIKE 'tokudb_version';

In the MariaDB binary tarballs, only the ones labeled "glibc_214" have TokuDB.

1. ↑ with this version, TokuDB now follows the version numbering of Percona XtraDB

This page contains links to various online resources for TokuDB.

Website

Tokutek was the primary developer of TokuDB before being acquired by Percona. Their website.

Percona's TokuDB Documentation

Mailing Lists

There were two TokuDB specific mailing lists run by Tokutek:

• - a mailing list for users of TokuDB

• - a mailing list TokuDB contributors

These were discontinued and redirected to .

IRC

Tokutek has a #tokutek IRC channel on .

The following link will take you to the #tokutek channel using Freenode's web IRC client:

See Also

The Where to find other MariaDB users and developers page has many great MariaDB resources listed.

_{This page is licensed: CC BY-SA / Gnu FDL}

Note that ha_tokudb is not included in binaries built with the "old" glibc. Binaries built with glibc 2.14+ do include it.

The following sections detail how to install and enable TokuDB.

Installing TokuDB

Until MariaDB versions 5.5.39 and 10.0.13, before upgrading TokuDB, the server needed to be cleanly shut down. If the server was not cleanly shut down, TokuDB would fail to start. Since 5.5.40 and 10.0.14, this has no longer been necessary. See MDEV-6173.

TokuDB has been included with MariaDB since and and does not require separate installation. Proceed straight to Check for Transparent HugePage Support on Linux. For older versions, see the distro-specific instructions below.

Installing TokuDB on Fedora, RedHat, & CentOS

In , , and starting from TokuDB is in a separate RPM package called MariaDB-tokudb-engine and is installed as follows:

Installing TokuDB on Ubuntu & Debian

On Ubuntu, TokuDB is available on the 64-bit versions of Ubuntu 12.10 and newer. On Debian, TokuDB is available on the 64-bit versions of Debian 7 "Wheezy" and newer.

The package is installed as follows:

In some earlier versions, from and , TokuDB is in a separate package calledmariadb-tokudb-engine-x.x, where x.x is the MariaDB series (5.5 or10.0). The package is installed, for example on 5.5, as follows:

libjemalloc

TokuDB requires the libjemalloc library (currently version 3.3.0 or greater).

libjemalloc should automatically be installed when using a package manager, and is loaded by restarting MariaDB.

It can be enabled, if not already done, by adding the following to the my.cnf configuration file:

If you don't do the above, you will get an error similar to the following one in your error file

Check for Transparent HugePage Support on Linux

Transparent hugepages is a feature in newer linux kernel versions that causes problems for the memory usage tracking calculations in TokuKV and can lead to memory overcommit. If you have this feature enabled, TokuKV will not start, and you should turn it off.

You can check the status of Transparent Hugepages as follows:

If the path does not exist, Transparent Hugepages are not enabled and you may continue.

Alternatively, the following are returned:

indicating Transparent Hugepages are not enabled and you may continue. If the following is returned:

Transparent Hugepages are enabled, and you will need to disable them.

To disable them, pass "transparent_hugepage=never" to the kernel in your bootloader (grub, lilo, etc.). For example, for SUSE, add transparent_hugepage=never to Optional Kernel Command Line Parameter at the end, such as after "showopts", and press OK. The setting will take effect on the next reboot.

You can also disable with:

On Centos or RedHat you can do:

Add line GRUB_CMDLINE_LINUX_DEFAULT="transparent_hugepage=never" to file /etc/default/grub

Update grub (boot loader):

For more information, see

Enabling TokuDB

Attempting to enable TokuDB while Linux Transparent HugePages are enabled will fail with an error such as:

See the section above; .

The before attempting to enable TokuDB. Strictly speaking, the XA code requires two XA-capable storage engines, and this is checked at startup. In practice, this requires InnoDB and the binary log to be active. If it isn't, the following warning are returned and XA features are disabled:

MariaDB's default my.cnf files come with a section for TokuDB. To enable TokuDB just remove the '#' comment markers from the options in the TokuDB section.

A typical TokuDB section looks like the following:

By default, the plugin-load option is commented out. Simply un-comment it as in the example above.

Don't forget to also enable jemalloc in the config file.

With these changes done, you can restart MariaDB to activate TokuDB.

Enabling TokuDB on Fedora

Instead of putting the TokuDB section in the main my.cnf file, it is placed in a separate file located at: /etc/my.cnf.d/tokudb.cnf

Enabling TokuDB on Ubuntu & Debian

Instead of putting the TokuDB section in the main my.cnf file, it is placed in a separate file located at: /etc/mysql/conf.d/tokudb.cnf

Enabling TokuDB Manually From the mysql Command Line

Generally, it is recommended to use one of the above methods to enable the TokuDB storage engine, but it is also possible to enable it manually as with other plugins. To do so, launch the mysql command-line client and connect to MariaDB as a user with the SUPER privilege and execute the following command:

TokuDB are installed until someone executes .

Temporarily Enabling TokuDB When Starting MariaDB

If you just want to test TokuDB, you can start the mysqld server with TokuDB with the following command:

See Also

• .

_{This page is licensed: CC BY-SA / Gnu FDL}

This page lists system variables that are related to TokuDB.

See Server System Variables for a complete list of system variables and instructions on setting them, and Full list of MariaDB options, system and status variables for a complete list of all options, statis variable and system variables in MariaDB.

System Variables

tokudb_alter_print_error

• Description: Print errors for alter table operations.

• Scope: Global, Session

• Dynamic: Yes

• Data Type: boolean

tokudb_analyze_time

• Description: Time in seconds that operations spend on each index when calculating cardinality. Accurate cardinality helps in particular with the performance of complex queries. If no analyzes are run, cardinality are 1 for primary indexes, and unknown (NULL) for other types of indexes.

• Scope: Global, Session

• Dynamic: Yes

• Data Type: numeric

tokudb_block_size

• Description: Uncompressed size of internal fractal tree and leaf nodes. Changing will only affect tables created after the new setting is in effect. Existing tables will keep the setting they were created with unless the table is dumped and reloaded.

• Scope: Global, Session

• Dynamic: Yes

• Data Type: numeric

tokudb_bulk_fetch

• Description: If set to 1 (the default), the bulk fetch algorithm is used for SELECT's and DELETE's, including related statements such as INSERT INTO.

• Scope: Global, Session

• Dynamic: Yes

• Data Type: boolean

tokudb_cache_size

• Description: Size in bytes of the TokuDB cache. This variable is read-only and cannot be changed dynamically. To change the value, either set the value in the my.cnf file prior to loading TokuDB or restart MariaDB after modifying the configuration. If you have loaded the plugin but not used TokuDB yet, you can unload the plugin then reload it and MariaDB will reload the plugin with the setting from the configuration file. Setting to at least half of the available memory is recommended, although if using directIO instead of buffered IO (see ) , up to 80% of the available memory is recommended. Decrease if other applications require significant memory or swapping is degrading performance.

• Dynamic: No

• Data Type: numeric

tokudb_check_jemalloc

• Description: Check if jemalloc is linked.

• Scope: Global

• Dynamic: Yes

• Data Type: numeric

tokudb_checkpoint_lock

• Description: Mechanism to lock out TokuDB checkpoints. When set to 1, TokuDB checkpoints are locked out. Setting to 0, or disconnecting the client, releases the lock.

• Scope: Global, Session

• Dynamic: Yes

tokudb_checkpoint_on_flush_logs

• Description: TokuDB checkpoint on flush logs.

• Scope: Global

• Dynamic: Yes

• Data Type: boolean

tokudb_checkpointing_period

• Description: Time in seconds between the beginning of each checkpoint. It is recommended to leave this at the default setting of 1 minute.

• Scope: Global

• Dynamic: Yes

• Data Type: numeric

tokudb_cleaner_iterations

• Description: Number of internal nodes processed in each cleaner thread period (see ). Setting to 0 turns off cleaner threads.

• Scope: Global

• Dynamic: Yes

• Data Type: numeric

tokudb_cleaner_period

• Description: Frequency in seconds for the running of the cleaner thread. Setting to 0 turns off cleaner threads.

• Scope: Global

• Dynamic: Yes

• Data Type: numeric

tokudb_commit_sync

• Description: Whether or not the transaction log is flushed upon transaction commit. Flushing has a minor performance penalty, but switching it off means that committed transactions may not survive a server crash.

• Scope: Global, Session

• Dynamic: Yes

• Data Type: boolean

tokudb_create_index_online

• Description: Whether indexes are hot or not. Hot, or online, indexes (the default) mean that the table is available for inserting and updates while the index is being created. It is slower to create hot indexes.

• Scope: Global, Session

• Dynamic: Yes

• Data Type: boolean

tokudb_data_dir

• Description: Directory where the TokuDB data is stored. By default the variable is empty, in which case the regular is used.

• Dynamic: No

• Data Type: string

• Default Value: Empty (the MariaDB datadir is used)

tokudb_debug

• Description: Setting to a non-zero value turns on various TokuDB debug traces.

• Scope: Global

• Dynamic: Yes

• Data Type: numeric

tokudb_directio

• Description: When set to ON, TokuDB writes use Direct IO instead of Buffered IO. should be adjusted when using DirectIO.

• Dynamic: No

• Data Type: boolean

• Default Value: OFF

tokudb_disable_hot_alter

• Description: If set to ON (OFF is default), hot alter table is disabled.

• Scope: Global, Session

• Dynamic: Yes

• Data Type: boolean

tokudb_disable_prefetching

• Description: If prefetching is not disabled (the default), range queries usually benefit from aggressive prefetching of blocks of rows. For range queries with LIMIT clauses, this can create unnecessary IO, and so prefetching can be disabled if these make up a majority of range queries.

• Scope: Global, Session

• Dynamic: Yes

• Data Type: boolean

tokudb_disable_slow_alter

• Description: Usually, TokuDB permits column addition, deletion, expansion, and renaming with minimal locking, very quickly. This variable determines whether certain slow [alter|ALTER]] table statements that cannot take advantage of this feature are permitted. Statements that are slow are those that include a mix of column additions, deletions or expansions, for example, ALTER TABLE t1 ADD COLUMN c1 int, DROP COLUMN c2.

• Scope: Global, Session

• Dynamic: Yes

tokudb_empty_scan

• Description: TokuDB algorithm to check if the table is empty when opened. Setting to disabled will reduce this overhead.

• Scope: Global, Session

• Dynamic: Yes

• Data Type: enum

tokudb_fs_reserve_percent

• Description: If this percentage of the filesystem is not free, inserts are prohibited. Recommended value is half the size of the available memory. Once disabled, inserts are re-enabled once twice the reserve is available. TokuDB will freeze entirely if the disk becomes entirely full.

• Scope: Global

• Dynamic: No

• Data Type: numeric

tokudb_fsync_log_period

• Description: fsync() operations frequency in milliseconds. If set to 0, the default, control fsync() behavior.

• Scope: Global, Session

• Dynamic: Yes

• Data Type: numeric

Warning: currently values in the 1000-2000 range seem to cause server crashes, see

tokudb_hide_default_row_format

• Description: Hide the default row format.

• Scope: Global, Session

• Dynamic: Yes

• Data Type: boolean

tokudb_killed_time

• Description: Control lock tree kill callback frequency.

• Scope: Global, Session

• Dynamic: Yes

• Data Type: numeric

tokudb_last_lock_timeout

• Description: Empty by default, when a lock deadlock is detected, or a lock request times out, set to a JSON document describing the most recent lock conflict. Only set when the first bit of is set.

• Scope: Global, Session

• Dynamic: Yes

• Data Type: text

tokudb_load_save_space

• Description: If set to 1, the default, bulk loader intermediate data is compressed, otherwise it is uncompressed. Also see .

• Scope: Global, Session

• Dynamic: Yes

• Data Type: boolean

tokudb_loader_memory_size

• Description: Memory limit for each loader instance used by the TokuDB bulk loader. Memory is taken from the TokuDB cache (), so current cache data may need to be cleared for the loader to begin. Increase if tables are very larger, with multiple secondary indexes.

• Scope: Global, Session

• Dynamic: Yes

• Data Type: numeric

tokudb_lock_timeout

• Description: Time in milliseconds that a transaction will wait for a lock held by another transaction to be released before timing out with a lock wait timeout error (-30994). Setting to 0 disables lock waits.

• Scope: Global, Session

• Dynamic: Yes

tokudb_lock_timeout_debug

• Description: When bit zero is set (default 1), a JSON document describing the most recent lock conflict is reported to . When set to 0, no lock conflicts are reported. When bit one is set, the JSON document is printed to the .

• Scope: Global, Session

• Dynamic: Yes

tokudb_log_dir

• Description: Directory where the TokuDB log files are stored. By default the variable is empty, in which case the regular is used.

• Dynamic: No

• Data Type: string

• Default Value: Empty (the MariaDB datadir is used)

tokudb_max_lock_memory

• Description: Max memory for locks.

• Scope: Global, Session

• Dynamic: No

• Data Type: numeric

tokudb_optimize_index_fraction

• Description: When deleting a percentage of the tree (useful when the left side of the tree has many deletions, such as a pattern with increasing ids or dates), it's possible to optimize a subset of the fractal tree, as determined by the value of this variable, which ranges from 0.0 to 1.0 (indicating the whole tree).

• Scope: Global, Session

• Dynamic: Yes

tokudb_optimize_index_name

• Description: If set to an index name, will optimize that single index in a table. Empty by default.

• Scope: Global, Session

• Dynamic: Yes

• Data Type: string

tokudb_optimize_throttle

• Description: Table optimization utilizes all available resources by default. This variable allows the table optimization speed to be limited in order to reduce the overall resources used. The limit places an upper bound on the number of fractal tree leaf nodes that are optimized per second. 0, the default, imposes no limit.

• Scope: Global, Session

• Dynamic: Yes

• Data Type: numeric

tokudb_pk_insert_mode

• Description: Mode for primary key inserts using either REPLACE INTO or on tables with no secondary index, or where all columns in the secondary index are in the primary key. For example PRIMARY KEY (a,b,c), key (b,c)

  • 0: Fast inserts. may not work, and will not work

  • 1: Fast inserts if no triggers are defined, otherwise inserts may be slow. Row-based replication will not work.

tokudb_prelock_empty

• Description: If set to 0 (1 is default), fast bulk loading are switched off. Usually, TokuDB obtains a table lock on empty tables. If, as is usual, only one transaction is loading the table, this speeds up the inserts. However, if many transactions are loading, only one can have access at a time, so setting this to 0, avoiding the lock, will speed inserts up in that situation.

• Scope: Global, Session

• Dynamic: Yes

tokudb_read_block_size

• Description: Uncompressed size in bytes of the read blocks of the fractal tree leaves. Changing will only affect tables created after the new setting is in effect. Existing tables will keep the setting they were created with unless the table is dumped and reloaded. Larger values are better for large range scans and higher compressions, while smaller values are better for point and small range scans.

• Scope: Global, Session

• Dynamic: Yes

• Data Type: numeric

tokudb_read_buf_size

• Description: Per-client size in bytes of the buffer used for storing bulk fetched values as part of a large range query. Reduce if there are many simultaneous clients. Setting to 0 disables bulk fetching.

• Scope: Global, Session

• Dynamic: Yes

• Data Type: numeric

tokudb_read_status_frequency

• Description: Progress is measured every this many reads for display by . Useful to set to 1 to examine slow queries.

• Scope: Global,

• Dynamic: Yes

• Data Type: numeric

tokudb_row_format

• Description: Compression algorithm used by default to compress data. Can be overridden by a row format specified in the statement. note that the library can be specified directly, or an alias used, the mapping of which may change in future. Note that in , and before , the compression type did not default to this value. See .

  • tokudb_default, tokudb_zlib: Use the zlib library,

  • tokudb_fast

tokudb_rpl_check_readonly

• Description: By default, when the slave is in read only mode, row events are run from the binary log using TokuDB's read-free replication (RFR). Setting this variable to OFF turns off the slave read only check, allowing RFR to run when the slave is not read-only. Be careful that you understand the consequences if setting this variable.

• Scope: Global, Session

• Dynamic: Yes

• Data Type: boolean

tokudb_rpl_lookup_rows

• Description: If set to OFF (ON is default), and to ROW and to ON, TokuDB replication slaves will not perform row lookups for update or delete row log events, removing the need for the associated IO.

• Scope: Global, Session

• Dynamic: Yes

tokudb_rpl_lookup_rows_delay

• Description: Can be used to simulate long disk reads by sleeping for the specified time, in microseconds, before the row lookup query. Only useful to change in a test environment.

• Scope: Global, Session

• Dynamic: Yes

• Data Type: numeric

tokudb_rpl_unique_checks

• Description: If set to OFF (ON is default), and to ROW and to ON, TokuDB replication slaves will skip uniqueness checks on inserts and updates, removing the associated IO.

• Scope: Global, Session

• Dynamic: Yes

tokudb_rpl_unique_checks_delay

• Description: Can be used to simulate long disk reads by sleeping for the specified time, in microseconds, before the row lookup query. Only useful to change in a test environment.

• Scope: Global, Session

• Dynamic: Yes

• Data Type: numeric

tokudb_support_xa

• Description: Whether or not the prepare phase of an XA transaction performs an fsync().

• Scope: Global, Session

• Dynamic: Yes

• Data Type: boolean

tokudb_tmp_dir

• Description: Directory where the TokuDB bulk loaders temporary files are stored. Can be very large, and useful to place on a separate disk. By default the variable is empty, in which case the regular is used. determines whether the data is compressed or not. The error message ERROR 1030 (HY000): Got error 1 from storage engine could indicate that the disk has run out of space.

• Dynamic: No

• Data Type: directory name

tokudb_version

• Description: The TokuDB version of the plugin included on MariaDB.

• Dynamic: No

• Data Type: string

tokudb_write_status_frequency

• Description: Progress is measured every this many writes for display by . Useful to set to 1 to examine slow queries.

• Scope: Global,

• Dynamic: Yes

• Data Type: numeric

_{This page is licensed: CC BY-SA / Gnu FDL}

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

• Description: Number of basement nodes decompressed by a prefetch thread. See .

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.

_{This page is licensed: CC BY-SA / Gnu FDL}