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_errorOFF tokudb_analyze_time5 0 to 4294967295 tokudb_block_size4194304 (4MB) 0 to 18446744073709551615 tokudb_bulk_fetch1 (the default), the bulk fetch algorithm is used for SELECT's and DELETE's, including related statements such as INSERT INTO. ON tokudb_cache_sizemy.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_jemalloc1 0 and 1 tokudb_checkpoint_lock1, TokuDB checkpoints are locked out. Setting to 0, or disconnecting the client, releases the lock. OFF tokudb_checkpoint_on_flush_logsOFF tokudb_checkpointing_period60 0 to 4294967295 tokudb_cleaner_iterations0 turns off cleaner threads. 5 0 to 18446744073709551615 tokudb_cleaner_period0 turns off cleaner threads. 1 0 to 18446744073709551615 tokudb_commit_syncON tokudb_create_index_onlineON tokudb_data_dirtokudb_debug0 0 to 18446744073709551615 tokudb_directioOFF tokudb_disable_hot_alterON (OFF is default), hot alter table is disabled. OFF tokudb_disable_prefetchingOFF tokudb_disable_slow_alterALTER TABLE t1 ADD COLUMN c1 int, DROP COLUMN c2. OFF tokudb_empty_scandisabled will reduce this overhead. rl lr, rl, disabled tokudb_fs_reserve_percent5 tokudb_fsync_log_period0, 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_formatON tokudb_killed_time4000 0 to 18446744073709551615 tokudb_last_lock_timeouttokudb_load_save_space1, the default, bulk loader intermediate data is compressed, otherwise it is uncompressed. Also see tokudb_tmp_dir. ON tokudb_loader_memory_size100000000 (100M) 0 to 18446744073709551615 tokudb_lock_timeoutlock wait timeout error (-30994). Setting to 0 disables lock waits. 4000 (4 seconds) 0 to 18446744073709551615 tokudb_lock_timeout_debug1), 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_dirtokudb_max_lock_memory130653952 tokudb_optimize_index_fraction0.0 to 1.0 (indicating the whole tree). 1.000000 0.0 to 1.0 tokudb_optimize_index_nametokudb_optimize_throttle0, the default, imposes no limit. 0 0 to 18446744073709551615 tokudb_pk_insert_modePRIMARY 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_empty0 (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_size65536 (64KB) 4096 to 4294967295 tokudb_read_buf_size0 disables bulk fetching. 131072 (128KB) 0 to 1048576 tokudb_read_status_frequency1 to examine slow queries. 10000 0 to 4294967295 tokudb_row_formattokudb_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_readonlyOFF 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_rowsOFF (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_delay0 tokudb_rpl_unique_checksOFF (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_delay0 tokudb_support_xaON tokudb_tmp_dirERROR 1030 (HY000): Got error 1 from storage engine could indicate that the disk has run out of space. directory name tokudb_versionstring tokudb_write_status_frequency1 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/