Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
TokuDB 5.7.17 my.cnf
[mysqld]
pid-file=/var/run/mysqld/mysqld.pid
log-error=/var/log/mysqld.log
sql_mode=no_engine_substitution,no_unsigned_subtraction
default_tmp_storage_engine=MyISAM
tmpdir=/data/mysql/toku
query_cache_size=0
query_cache_type=0
slow_query_log_file=/data/mysql/toku/slow.log
long_query_time=5
max_binlog_size=128M
sync_binlog=0
server_id=77
datadir=/data/mysql/toku/data
tokudb_directio = OFF
tokudb_empty_scan = disabled
tokudb_read_block_size = 16K
tokudb_commit_sync = OFF
tokudb_checkpointing_period = 300
tokudb_block_size = 4M
tokudb_cleaner_iterations = 10000
tokudb_enable_partial_eviction = OFF
tokudb_fsync_log_period = 1000
default-storage-engine = tokudb
#skip-innodb
default-tmp-storage-engine=MyISAM
log_bin=/binlogs/myrocks/bl
binlog_format=row
tokudb_disable_prefetching = ON
slow_query_log = ON
long_query_time=1
# TODO set this
tokudb_cache_size = 10G or 150G
# TODO select one of these
#tokudb_row_format = tokudb_zlib
#tokudb_row_format = tokudb_uncompressed
[mysqld-safe]
malloc-lib=/usr/lib64/libjemalloc.so.1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment