1 of 1

MyRocks Performance Troubleshooting

A guide to diagnosing and resolving performance issues in MyRocks using status variables, `SHOW ENGINE ROCKSDB STATUS`, and RocksDB performance context.

MyRocks exposes its performance metrics through several interfaces:

Status variables
SHOW ENGINE ROCKSDB STATUS
RocksDB's perf context

the contents slightly overlap, but each source has its own unique information, so be sure to check all three.

Status Variables

Check the output of

See for more information.

SHOW ENGINE ROCKSDB STATUS

This produces a lot of information.

One particularly interesting part is compaction statistics. It shows the amount of data on each SST level and other details:

Performance Context

RocksDB has an internal mechanism called "perf context". The counter values are exposed through two tables:

- global counters
- Per-table/partition counters

By default statistics are NOT collected. One needs to set to some value (e.g. 3) to enable collection.

_{This page is licensed: CC BY-SA / Gnu FDL}