[Feature] LMQ Optimization: Revamp on top of RocksDB

[lizhanhui]

Is Your Feature Request Related to a Problem?

LMQ is supposed to be light-weight in terms of resource cost and lifecycle. Current implementation is still based on file queue and does not scale as expected

Describe the Solution You'd Like

Provide a key-value based implementation

Describe Alternatives You've Considered

In-place optimization is not a viable option in the long run.

Additional Context

No response