I've used RocksDB as an ephemeral datastore for event streaming platforms processing billions of requests a day, and as backing for high-scale http APIs that have served hundreds of thousands of requests per second.
This repo has a slide deck explaining the externals of RocksDB. It also includes tuning suggestions that I've found useful.