Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement