Created
February 23, 2017 00:16
-
-
Save mdcallag/605eebca8fc77a96cdddac22ca0a9cba to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Default my.cnf for myrocks | |
[mysqld_safe] | |
malloc-lib=/usr/lib/x86_64-linux-gnu/libjemalloc.so | |
mdcallag@nuc2:~/b/myrocks.feb9.04a329$ cat etc/my.cnf | |
my.cnf my.cnf.def my.cnf.opt | |
mdcallag@nuc2:~/b/myrocks.feb9.04a329$ cat etc/my.cnf.def | |
[mysqld] | |
sql_mode=no_engine_substitution,no_unsigned_subtraction | |
default_tmp_storage_engine=MyISAM | |
tmpdir=/data/m/my/data | |
query_cache_size=0 | |
query_cache_type=0 | |
# slow_query_log_file=/data/m/my/slow.log | |
long_query_time=5 | |
# skip_log_bin | |
log_bin=/data/m/my/binlogs/bl | |
max_binlog_size=128M | |
sync_binlog=0 | |
server_id=77 | |
datadir=/data/m/my/data | |
rocksdb | |
default-storage-engine=rocksdb | |
skip-innodb | |
default-tmp-storage-engine=MyISAM | |
binlog_format=ROW | |
collation-server=latin1_bin | |
rocksdb_wal_dir=/data/m/my/txlogs | |
[mysqld_safe] | |
malloc-lib=/usr/lib/x86_64-linux-gnu/libjemalloc.so | |
------------------- | |
# optimized my.cnf for myrocks | |
[mysqld] | |
sql_mode=no_engine_substitution,no_unsigned_subtraction | |
default_tmp_storage_engine=MyISAM | |
tmpdir=/data/m/my/data | |
query_cache_size=0 | |
query_cache_type=0 | |
# slow_query_log_file=/data/m/my/slow.log | |
long_query_time=5 | |
# skip_log_bin | |
log_bin=/data/m/my/binlogs/bl | |
max_binlog_size=128M | |
sync_binlog=0 | |
server_id=77 | |
datadir=/data/m/my/data | |
rocksdb | |
default-storage-engine=rocksdb | |
skip-innodb | |
default-tmp-storage-engine=MyISAM | |
binlog_format=ROW | |
collation-server=latin1_bin | |
rocksdb_wal_dir=/data/m/my/txlogs | |
transaction-isolation=READ-COMMITTED | |
rocksdb_max_open_files=-1 | |
rocksdb_base_background_compactions=1 | |
rocksdb_max_background_compactions=8 | |
rocksdb_max_total_wal_size=4G | |
rocksdb_max_background_flushes=4 | |
rocksdb_block_size=16384 | |
rocksdb_table_cache_numshardbits=6 | |
# rate limiter | |
rocksdb_bytes_per_sync=4194304 | |
rocksdb_wal_bytes_per_sync=4194304 | |
# triggering compaction if there are many sequential deletes | |
rocksdb_compaction_sequential_deletes_count_sd=1 | |
rocksdb_compaction_sequential_deletes=199999 | |
rocksdb_compaction_sequential_deletes_window=200000 | |
rocksdb_default_cf_options=write_buffer_size=32m;target_file_size_base=32m;max_bytes_for_level_base=256m;level0_file_num_compaction_trigger=4;level0_slowdown_writes_trigger=20;level0_stop_writes_trigger=30;max_write_buffer_number=4;compression_per_level=kNoCompression:kNoCompression:kNoCompression:kLZ4Compression:kLZ4Compression:kLZ4Compression;bottommost_compression=kZlibCompression;compression_opts=-14:1:0;block_based_table_factory={cache_index_and_filter_blocks=1;filter_policy=bloomfilter:10:false;whole_key_filtering=1};level_compaction_dynamic_level_bytes=true;optimize_filters_for_hits=true | |
rocksdb_block_cache_size=2G | |
[mysqld_safe] | |
malloc-lib=/usr/lib/x86_64-linux-gnu/libjemalloc.so |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment