The TokuDB storage engine has been removed from MariaDB.
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.
tokudb_alter_print_errorDescription: Print errors for alter table operations.
Scope: Global, Session
Dynamic: Yes
Data Type: boolean
tokudb_analyze_timeDescription: 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_sizeDescription: 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_fetchDescription: 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_sizeDescription: 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_jemallocDescription: Check if jemalloc is linked.
Scope: Global
Dynamic: Yes
Data Type: numeric
tokudb_checkpoint_lockDescription: 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_logsDescription: TokuDB checkpoint on flush logs.
Scope: Global
Dynamic: Yes
Data Type: boolean
tokudb_checkpointing_periodDescription: 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_iterationsDescription: 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_periodDescription: 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_syncDescription: 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_onlineDescription: 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_dirDescription: 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_debugDescription: Setting to a non-zero value turns on various TokuDB debug traces.
Scope: Global
Dynamic: Yes
Data Type: numeric
tokudb_directioDescription: 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_alterDescription: If set to ON (OFF is default), hot alter table is disabled.
Scope: Global, Session
Dynamic: Yes
Data Type: boolean
tokudb_disable_prefetchingDescription: 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_alterDescription: 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_scanDescription: 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_percentDescription: 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_periodDescription: 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_formatDescription: Hide the default row format.
Scope: Global, Session
Dynamic: Yes
Data Type: boolean
tokudb_killed_timeDescription: Control lock tree kill callback frequency.
Scope: Global, Session
Dynamic: Yes
Data Type: numeric
tokudb_last_lock_timeoutDescription: 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_spaceDescription: 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_sizeDescription: 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_timeoutDescription: 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_debugDescription: 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_dirDescription: 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_memoryDescription: Max memory for locks.
Scope: Global, Session
Dynamic: No
Data Type: numeric
tokudb_optimize_index_fractionDescription: 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_nameDescription: 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_throttleDescription: 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_modeDescription: 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_emptyDescription: 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_sizeDescription: 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_sizeDescription: 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_frequencyDescription: 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_formatDescription: 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_readonlyDescription: 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_rowsDescription: 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_delayDescription: 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_checksDescription: 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_delayDescription: 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_xaDescription: Whether or not the prepare phase of an XA transaction performs an fsync().
Scope: Global, Session
Dynamic: Yes
Data Type: boolean
tokudb_tmp_dirDescription: 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_versionDescription: The TokuDB version of the plugin included on MariaDB.
Dynamic: No
Data Type: string
tokudb_write_status_frequencyDescription: 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
OFFDefault Value: 5
Range: 0 to 4294967295
Default Value: 4194304 (4MB)
Range: 0 to 18446744073709551615
Default Value: ON
Default Value: Half of the total system memory
1Valid Values: 0 and 1
Default Value: OFF
OFF60Range: 0 to 4294967295
Default Value: 5
Range: 0 to 18446744073709551615
Default Value: 1
Range: 0 to 18446744073709551615
Default Value: ON
Default Value: ON
0Range: 0 to 18446744073709551615
Default Value: OFF
Default Value: OFF
Default Value: OFF
Default Value: rl
Valid Values: lr, rl, disabled
Default Value: 5
Default Value: 0
Range: 0 to 18446744073709551615
ON4000Range: 0 to 18446744073709551615
Introduced: TokuDB 7.1.5
Default Value: Empty
Default Value: ON
Default Value: 100000000 (100M)
Range: 0 to 18446744073709551615
Default Value: 4000 (4 seconds)
Range: 0 to 18446744073709551615
Default Value: 1
130653952Default Value: 1.000000
Range: 0.0 to 1.0
Introduced: TokuDB 7.5.5
Introduced: TokuDB 7.5.5
Default Value: 0
Range: 0 to 18446744073709551615
Introduced: TokuDB 7.5.5
2: Slow inserts. Triggers and row-based replication work normally.
Scope: Global, Session
Dynamic: Yes
Data Type: enumerated
Default Value: 1
Valid Values: 0, 1, 2
Data Type: boolean
Default Value: ON
Default Value: 65536 (64KB)
Range: 4096 to 4294967295
Default Value: 131072 (128KB)
Range: 0 to 1048576
Default Value: 10000
Range: 0 to 4294967295
tokudb_quicklztokudb_small, tokudb_lzma: Use the lzma library. the highest compression and highest CPU usage
tokudb_uncompressed: No compression is used.
Scope: Global, Session
Dynamic: Yes
Data Type: enumerated
Default Value: tokudb_zlib
Valid Values: tokudb_default, tokudb_fast, tokudb_small, tokudb_zlib, tokudb_quicklz, tokudb_lzma, tokudb_uncompressed
Default Value: ON
Data Type: boolean
Default Value: ON
Default Value: 0
Data Type: boolean
Default Value: ON
Default Value: 0
ONDefault Value: Empty (the MariaDB datadir is used)
Default Value: 1000
Range: 0 to 4294967295
TokuDB has been deprecated by its upstream maintainer. It is disabled from MariaDB 10.5 and has been removed in MariaDB 10.6 - MDEV-19780. We recommend MyRocks as a long-term migration path.