Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Created March 3, 2017 19:20
Show Gist options
  • Save mdcallag/08c374cb36e007b71ec8f33330067bf1 to your computer and use it in GitHub Desktop.
Save mdcallag/08c374cb36e007b71ec8f33330067bf1 to your computer and use it in GitHub Desktop.
[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_block_size = 1M
tokudb_cleaner_iterations = 10000
tokudb_enable_partial_eviction = OFF
# tokudb_fanout = 32
# tokudb_checkpoint_pool_threads = 2
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
tokudb_cache_size = 2G
# choose one
#tokudb_row_format = tokudb_zlib
#tokudb_row_format = tokudb_snappy
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