Last active
October 19, 2019 13:29
-
-
Save mdcallag/cd9ef5a189025892b5317a6834c30e6e to your computer and use it in GitHub Desktop.
myrocks march 17 and later my.cnf
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
[mysqld] | |
sql_mode=no_engine_substitution,no_unsigned_subtraction | |
default_tmp_storage_engine=MyISAM | |
sync_relay_log_info=100 | |
relay_log_recovery=1 | |
relay_log_info_repository=FILE | |
eq_range_index_dive_limit=1000 | |
gtid_mode=OFF | |
enforce_gtid_consistency=ON | |
lock_wait_timeout=60 | |
part_scan_max=1000 | |
ssl=0 | |
plugin_load= | |
skip_temp_pool=0 | |
long_query_time=10 | |
wait_timeout=10 | |
interactive_timeout=120 | |
max_allowed_packet=128M | |
slave_max_allowed_packet=256M | |
skip_name_resolve | |
back_log=4096 | |
max_connections=5000 | |
max_user_connections=4000 | |
max_connect_errors=3000 | |
key_buffer_size=16M | |
myisam_sort_buffer_size=256M | |
max_tmp_tables=64 | |
read_buffer_size=1M | |
read_rnd_buffer_size=1M | |
sort_buffer_size=2M | |
table_open_cache=50000 | |
table_definition_cache=60000 | |
query_cache_limit=4M | |
query_cache_size=0 | |
query_cache_type=0 | |
thread_cache_size=500 | |
thread_stack=196608 | |
open_files_limit=32767 | |
net_read_timeout=15 | |
net_write_timeout=30 | |
tmp_table_size=64M | |
max_heap_table_size=512M | |
log_slow_extra=1 | |
group_concat_max_len=1024 | |
datadir=/data/mysql/myrocks/data | |
socket=/data/mysql/myrocks/var/mysql.sock | |
max_binlog_size=1G | |
binlog_cache_size=262144 | |
max_binlog_cache_size=666G | |
tmpdir=/tmp | |
slave_load_tmpdir=/tmp | |
slow_query_log_file=/data/mysql/myrocks/slow.log | |
slow_query_log=1 | |
log_slow_slave_statements=1 | |
collation-server=latin1_bin | |
default-storage-engine=rocksdb | |
skip-innodb | |
default-tmp-storage-engine=MyISAM | |
rocksdb | |
long_query_time=10 | |
log_bin=/binlogs/myrocks/bl | |
sync_binlog=0 | |
binlog_format=row | |
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 | |
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 | |
#TODO select one of these | |
# with compression, with kMinOverlappingRatio | |
#rocksdb_default_cf_options=write_buffer_size=64m;target_file_size_base=32m;max_bytes_for_level_base=512m;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=kZSTDNotFinalCompression;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;compaction_pri=kMinOverlappigRatio | |
# with compression, without kMinOverlappingRatio | |
#rocksdb_default_cf_options=write_buffer_size=64m;target_file_size_base=32m;max_bytes_for_level_base=512m;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=kZSTDNotFinalCompression;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 | |
# without compression, with kMinOverlappingRatio | |
#rocksdb_default_cf_options=write_buffer_size=64m;target_file_size_base=32m;max_bytes_for_level_base=512m;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:kNoCompression:kNoCompression:kNoCompression;bottommost_compression=kNoCompression;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;compaction_pri=kMinOverlappingRatio | |
# without compression, without kMinOverlappingRatio | |
#rocksdb_default_cf_options=write_buffer_size=64m;target_file_size_base=32m;max_bytes_for_level_base=512m;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:kNoCompression:kNoCompression:kNoCompression;bottommost_compression=kNoCompression;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 | |
#TODO - set this | |
rocksdb_block_cache_size=10g or 150g | |
rocksdb_flush_log_at_trx_commit=2 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment