losfair / losfair/mvsqlite

In-memory content cache decreases performance on YCSB workloadc

Open
#94 0 comments 1 reaction 0 assignees View on GitHub

Nobody has claimed this yet.

performance
Dominant language
Rust
Stars
1.6k
Forks
48
PR merge metrics
No merged PRs in 30d

Description

Related: https://github.com/losfair/mvsqlite/pull/92

It is strange that enabling content cache causes performance decrease over time: (this is with a hot cache that has almost all pages)

```
READ - Takes(s): 10.0, Count: 103349, OPS: 10344.3, Avg(us): 6159, Min(us): 1108, Max(us): 51167, 99th(us): 11775, 99.9th(us): 48703, 99.99th(us): 50719
...
READ - Takes(s): 160.0, Count: 1057188, OPS: 6607.8, Avg(us): 9661, Min(us): 797, Max(us): 55519, 99th(us): 50719, 99.9th(us): 53823, 99.99th(us): 55199
```

while on the same cluster, with content cache disabled:

```
READ - Takes(s): 190.0, Count: 1730079, OPS: 9106.2, Avg(us): 7006, Min(us): 809, Max(us): 51423, 99th(us): 12815, 99.9th(us): 47007, 99.99th(us): 50847
```

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reviewing the related pull request 92 and the YCSB workload results in this issue, then locate the in-memory content-cache implementation. Reproduce the comparison with the cache enabled and disabled; done means identifying and correcting the cache-related performance regression and verifying the workload improves.

Written by the indexing model from the issue text.

Assessment

Tech stack
rust, sqlite
Domain
databases, performance
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.