Optimal RocksDB configuration for use as secondary "cache"

Question

I am looking at using RocksDB (from Java in my case) as a secondary "cache" behind a RAM based first level cache. I do not expect any items in RocksDB to be dramatically more commonly accessed than others (all the really frequently used items will be in the first level cache) and there will be no "locality" (if there is such a concept in RocksDB?) as the "next" key in sequence is no more likely to be accessed next than any other so I would like to optimize RocksDB for "truly random access" by for instance reading as little data as possible each time, not have any "cache" in Rocks etc. All suggestions of configurations are appreciated!

Answer 1

The defaults should be more than enough for your use case - but you can increase the block size and pin index and filter blocks

You can also call optimizeForPointLookup if you only are going to do puts and gets to optimize even further