Create a gist now

Instantly share code, notes, and snippets.

[mysqld]
max_connections=5000
table_open_cache=50000
table_definition_cache=60000
query_cache_type=0
log_slow_extra=1
skip_log_bin
binlog-format=ROW
sync-binlog=0
# log_bin=/ssd1/scratch/data.mdcallag/binlogs/bl
slow_query_log_file=/ssd1/scratch/data.mdcallag/slow.log
slow_query_log=1
long_query_time=2
join_buffer_size=32K
sort_buffer_size=32K
datadir=/ssd1/scratch/data.mdcallag/data
rocksdb
default-storage-engine=rocksdb
skip-innodb
default-tmp-storage-engine=MyISAM
rocksdb_wal_dir=/ssd1/scratch/data.mdcallag/txlogs
rocksdb_max_open_files=-1
rocksdb_max_background_compactions=16
rocksdb_max_total_wal_size=4G
rocksdb_max_background_flushes=4
rocksdb_block_size=8192
rocksdb_block_cache_size=40G
rocksdb_table_cache_numshardbits=6
# rate limiter
rocksdb_bytes_per_sync=4194304
rocksdb_wal_bytes_per_sync=4194304
# rocksdb_rate_limiter_bytes_per_sec=104857600
# triggering compaction if there are many sequential deletes
rocksdb_compaction_sequential_deletes=1800
rocksdb_compaction_sequential_deletes_window=2000
rocksdb_write_sync=0
rocksdb_default_cf_options=write_buffer_size=128m;target_file_size_base=32m;max_bytes_for_level_base=512m;level0_file_num_compaction_trigger=4;level0_slowdown_writes_trigger=10;level0_stop_writes_trigger=15;max_write_buffer_number=4;compression_per_level=kNoCompression:kNoCompression:kNoCompression:kZlibCompression:kZlibCompression:kZlibCompression:kZlibCompression;compression_opts=-14:1:0;block_based_table_factory={cache_index_and_filter_blocks=1;filter_policy=bloomfilter:10:false;whole_key_filtering=0};level_compaction_dynamic_level_bytes=true;optimize_filters_for_hits=true;memtable_prefix_bloom_bits=41943040;memtable_prefix_bloom_probes=6;prefix_extractor=capped:12
# enabling row checksums for 5% keys/values
# rocksdb_store_checksums=1
# rocksdb_verify_checksums=1
# rocksdb_checksums_pct=5
[mysqld_safe]
malloc-lib=/usr/lib64/libjemalloc.so
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment