Determine ideal defaults for MyRocks/RocksDB options
General
Escalation
General
Escalation
Description
Environment
None
100% Done
Smart Checklist
Activity
Show:

George Lorch October 25, 2018 at 7:15 PM
Done as
Done
Details
Details
Assignee

Reporter

Components
Fix versions
Affects versions
Priority
Smart Checklist
Open Smart Checklist
Smart Checklist

Open Smart Checklist
Created December 13, 2016 at 10:50 PM
Updated December 27, 2018 at 6:29 PM
Resolved October 25, 2018 at 7:15 PM
default_cf_options - change from nullptr and set rational column family option defaults, specifically default compression plan.
rocksdb_max_open_files - must be lowered from infinite to sensible amount like 1000. Possibly do some auto-tune like InnoDB does if == 0 as well as limit to be no larger than open_tables_limit.
rocksdb_max_row_locks - should be lowered to limit memory used per transaction until https://github.com/facebook/mysql-5.6/issues/692 is fixed.
rocksdb_write_batch_max_bytes - When pulled in as part of MYR-47 should be lowered to limit memory used per transaction until https://github.com/facebook/mysql-5.6/issues/692 is fixed.
rocksdb_block_size - Needs rational lower limit in bytes, probably 4096 like TokuDB, see MYR-190