Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Done
-
None
Description
Start with re-running the benchmark from MDEV-18856
Attachments
Issue Links
- relates to
-
MDEV-15603 Gap Lock support in MyRocks
-
- Stalled
-
-
MDEV-18856 Benchmark range locking
-
- Closed
-
-
MDEV-21314 Range Locking: individual rows are locked when scanning PK
-
- Open
-
-
MDEV-25161 Benchmark range locking - 2021
-
- Closed
-
Results for two tables, each index in its own Column Family:
Threads orig-2t2cf rl-2t2cf X/Y*100
1 21064.12 21310.59 101.17
5 94306.66 89324.75 94.72
10 146055.7 141178.98 96.66
20 158258.87 157948.36 99.80
40 176671 173845.97 98.40
60 176492.18 168174.68 95.29
80 175106.98 172390.58 98.45
100 174936.57 171553.95 98.07
That is, using range locking gives a 2% slowdown.