Determine ideal defaults for MyRocks/RocksDB options

Description

  • 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

Environment

None

Smart Checklist

Activity

Show:

George Lorch October 25, 2018 at 7:15 PM

Done as

Done

Details

Assignee

Reporter

Components

Fix versions

Affects versions

Priority

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