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_error
OFF
tokudb_analyze_time
5
0
to 4294967295
tokudb_block_size
4194304
(4MB) 0
to 18446744073709551615
tokudb_bulk_fetch
1
(the default), the bulk fetch algorithm is used for SELECT's and DELETE's, including related statements such as INSERT INTO. ON
tokudb_cache_size
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 tokudb_directio) , up to 80% of the available memory is recommended. Decrease if other applications require significant memory or swapping is degrading performance. tokudb_check_jemalloc
1
0
and 1
tokudb_checkpoint_lock
1
, TokuDB checkpoints are locked out. Setting to 0
, or disconnecting the client, releases the lock. OFF
tokudb_checkpoint_on_flush_logs
OFF
tokudb_checkpointing_period
60
0
to 4294967295
tokudb_cleaner_iterations
0
turns off cleaner threads. 5
0
to 18446744073709551615
tokudb_cleaner_period
0
turns off cleaner threads. 1
0
to 18446744073709551615
tokudb_commit_sync
ON
tokudb_create_index_online
ON
tokudb_data_dir
tokudb_debug
0
0
to 18446744073709551615
tokudb_directio
OFF
tokudb_disable_hot_alter
ON
(OFF
is default), hot alter table is disabled. OFF
tokudb_disable_prefetching
OFF
tokudb_disable_slow_alter
ALTER TABLE t1 ADD COLUMN c1 int, DROP COLUMN c2
. OFF
tokudb_empty_scan
disabled
will reduce this overhead. rl
lr
, rl
, disabled
tokudb_fs_reserve_percent
5
tokudb_fsync_log_period
0
, the default, tokudb_commit_sync control fsync() behavior. 0
0
to 18446744073709551615
Warning: currently values in the 1000-2000 range seem to cause server crashes, see MDEV-16732
tokudb_hide_default_row_format
ON
tokudb_killed_time
4000
0
to 18446744073709551615
tokudb_last_lock_timeout
tokudb_load_save_space
1
, the default, bulk loader intermediate data is compressed, otherwise it is uncompressed. Also see tokudb_tmp_dir. ON
tokudb_loader_memory_size
100000000
(100M) 0
to 18446744073709551615
tokudb_lock_timeout
lock wait timeout
error (-30994). Setting to 0
disables lock waits. 4000
(4 seconds) 0
to 18446744073709551615
tokudb_lock_timeout_debug
1
), a JSON document describing the most recent lock conflict is reported to tokudb_last_lock_timeout. When set to 0
, no lock conflicts are reported. When bit one is set, the JSON document is printed to the error log. 1
tokudb_log_dir
tokudb_max_lock_memory
130653952
tokudb_optimize_index_fraction
0.0
to 1.0
(indicating the whole tree). 1.000000
0.0
to 1.0
tokudb_optimize_index_name
tokudb_optimize_throttle
0
, the default, imposes no limit. 0
0
to 18446744073709551615
tokudb_pk_insert_mode
PRIMARY KEY (a,b,c), key (b,c)
0
: Fast inserts. Triggers may not work, and row-based replication will not work 1
: Fast inserts if no triggers are defined, otherwise inserts may be slow. Row-based replication will not work. 2
: Slow inserts. Triggers and row-based replication work normally. 1
0
, 1
, 2
tokudb_prelock_empty
0
(1
is default), fast bulk loading will be 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. ON
tokudb_read_block_size
65536
(64KB) 4096
to 4294967295
tokudb_read_buf_size
0
disables bulk fetching. 131072
(128KB) 0
to 1048576
tokudb_read_status_frequency
1
to examine slow queries. 10000
0
to 4294967295
tokudb_row_format
tokudb_default
, tokudb_zlib
: Use the zlib library, tokudb_fast
, tokudb_quicklz
: Use the quicklz library, the lightest compression with low CPU usage, tokudb_small
, tokudb_lzma
: Use the lzma library. the highest compression and highest CPU usage tokudb_uncompressed
: No compression is used. tokudb_zlib
tokudb_default
, tokudb_fast
, tokudb_small
, tokudb_zlib
, tokudb_quicklz
, tokudb_lzma
, tokudb_uncompressed
tokudb_rpl_check_readonly
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. ON
tokudb_rpl_lookup_rows
OFF
(ON
is default), and binlog_format to ROW
and read_only to ON
, TokuDB replication slaves will not perform row lookups for update or delete row log events, removing the need for the associated IO. ON
tokudb_rpl_lookup_rows_delay
0
tokudb_rpl_unique_checks
OFF
(ON
is default), and binlog_format to ROW
and read_only to ON
, TokuDB replication slaves will skip uniqueness checks on inserts and updates, removing the associated IO. ON
tokudb_rpl_unique_checks_delay
0
tokudb_support_xa
ON
tokudb_tmp_dir
ERROR 1030 (HY000): Got error 1 from storage engine
could indicate that the disk has run out of space. directory name
tokudb_version
string
tokudb_write_status_frequency
1
to examine slow queries. numeric
1000
0
to 4294967295
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/tokudb-system-variables/