This is an automated email from the ASF dual-hosted git repository.
dongjoon-hyun pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/spark.git
The following commit(s) were added to refs/heads/master by this push:
new cc2ba064838a [SPARK-52610][BUILD] Upgrade rocksdbjni to 10.10.1.1
cc2ba064838a is described below
commit cc2ba064838a4673aaade1851ec2089edfc1f1ad
Author: YangJie <[email protected]>
AuthorDate: Thu May 28 08:19:31 2026 -0700
[SPARK-52610][BUILD] Upgrade rocksdbjni to 10.10.1.1
### What changes were proposed in this pull request?
The pr aims to upgrade `rocksdbjni` from 9.8.4 to 10.2.1.
### Why are the changes needed?
New version bring some bug fixes, the full release notes:
- https://github.com/facebook/rocksdb/releases/tag/v10.10.1
- https://github.com/facebook/rocksdb/releases/tag/v10.9.1
- https://github.com/facebook/rocksdb/releases/tag/v10.8.3
- https://github.com/facebook/rocksdb/releases/tag/v10.7.5
- https://github.com/facebook/rocksdb/releases/tag/v10.6.2
- https://github.com/facebook/rocksdb/releases/tag/v10.5.1
- https://github.com/facebook/rocksdb/releases/tag/v10.4.2
- https://github.com/facebook/rocksdb/releases/tag/v10.2.1
- https://github.com/facebook/rocksdb/releases/tag/v10.1.3
- https://github.com/facebook/rocksdb/releases/tag/v10.0.1
### Does this PR introduce _any_ user-facing change?
No.
### How was this patch tested?
Pass Github Actions.
### Was this patch authored or co-authored using generative AI tooling?
No.
Closes #56136 from LuciferYang/SPARK-52610-10.2.1.
Authored-by: YangJie <[email protected]>
Signed-off-by: Dongjoon Hyun <[email protected]>
---
dev/deps/spark-deps-hadoop-3-hive-2.3 | 2 +-
pom.xml | 2 +-
...StoreBasicOperationsBenchmark-jdk21-results.txt | 152 ++++++++++-----------
...StoreBasicOperationsBenchmark-jdk25-results.txt | 120 ++++++++--------
.../StateStoreBasicOperationsBenchmark-results.txt | 152 ++++++++++-----------
5 files changed, 214 insertions(+), 214 deletions(-)
diff --git a/dev/deps/spark-deps-hadoop-3-hive-2.3
b/dev/deps/spark-deps-hadoop-3-hive-2.3
index 1038ca5657a3..6e1458207b65 100644
--- a/dev/deps/spark-deps-hadoop-3-hive-2.3
+++ b/dev/deps/spark-deps-hadoop-3-hive-2.3
@@ -258,7 +258,7 @@
proto-google-common-protos/2.59.2//proto-google-common-protos-2.59.2.jar
py4j/0.10.9.9//py4j-0.10.9.9.jar
reactive-streams/1.0.3//reactive-streams-1.0.3.jar
remotetea-oncrpc/1.1.2//remotetea-oncrpc-1.1.2.jar
-rocksdbjni/9.8.4//rocksdbjni-9.8.4.jar
+rocksdbjni/10.10.1.1//rocksdbjni-10.10.1.1.jar
scala-compiler/2.13.18//scala-compiler-2.13.18.jar
scala-library/2.13.18//scala-library-2.13.18.jar
scala-parallel-collections_2.13/1.2.0//scala-parallel-collections_2.13-1.2.0.jar
diff --git a/pom.xml b/pom.xml
index c16c813a7a27..f985ace87ee3 100644
--- a/pom.xml
+++ b/pom.xml
@@ -772,7 +772,7 @@
<dependency>
<groupId>org.rocksdb</groupId>
<artifactId>rocksdbjni</artifactId>
- <version>9.8.4</version>
+ <version>10.10.1.1</version>
</dependency>
<dependency>
<groupId>${leveldbjni.group}</groupId>
diff --git
a/sql/core/benchmarks/StateStoreBasicOperationsBenchmark-jdk21-results.txt
b/sql/core/benchmarks/StateStoreBasicOperationsBenchmark-jdk21-results.txt
index ac60700d4581..207d4fc19539 100644
--- a/sql/core/benchmarks/StateStoreBasicOperationsBenchmark-jdk21-results.txt
+++ b/sql/core/benchmarks/StateStoreBasicOperationsBenchmark-jdk21-results.txt
@@ -2,143 +2,143 @@
put rows
================================================================================================
-OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
-AMD EPYC 7763 64-Core Processor
+OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1015-azure
+AMD EPYC 9V74 80-Core Processor
putting 10000 rows (10000 rows to overwrite - rate 100): Best Time(ms) Avg
Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
---------------------------------------------------------------------------------------------------------------------------------------
-In-memory 9
10 1 1.1 927.2 1.0X
-RocksDB (trackTotalNumberOfRows: true) 45
46 1 0.2 4476.9 0.2X
-RocksDB (trackTotalNumberOfRows: false) 17
18 0 0.6 1692.0 0.5X
+In-memory 9
11 1 1.1 924.8 1.0X
+RocksDB (trackTotalNumberOfRows: true) 45
47 1 0.2 4523.6 0.2X
+RocksDB (trackTotalNumberOfRows: false) 18
19 1 0.6 1794.0 0.5X
-OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
-AMD EPYC 7763 64-Core Processor
+OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1015-azure
+AMD EPYC 9V74 80-Core Processor
putting 10000 rows (5000 rows to overwrite - rate 50): Best Time(ms) Avg
Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
-------------------------------------------------------------------------------------------------------------------------------------
-In-memory 10
11 1 1.0 956.6 1.0X
-RocksDB (trackTotalNumberOfRows: true) 47
48 1 0.2 4652.1 0.2X
-RocksDB (trackTotalNumberOfRows: false) 17
18 1 0.6 1696.6 0.6X
+In-memory 8
9 1 1.2 839.0 1.0X
+RocksDB (trackTotalNumberOfRows: true) 38
39 1 0.3 3764.5 0.2X
+RocksDB (trackTotalNumberOfRows: false) 18
19 1 0.6 1770.5 0.5X
-OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
-AMD EPYC 7763 64-Core Processor
+OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1015-azure
+AMD EPYC 9V74 80-Core Processor
putting 10000 rows (1000 rows to overwrite - rate 10): Best Time(ms) Avg
Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
-------------------------------------------------------------------------------------------------------------------------------------
-In-memory 9
10 1 1.1 901.4 1.0X
-RocksDB (trackTotalNumberOfRows: true) 46
48 1 0.2 4647.7 0.2X
-RocksDB (trackTotalNumberOfRows: false) 17
18 1 0.6 1672.1 0.5X
+In-memory 8
9 1 1.2 813.0 1.0X
+RocksDB (trackTotalNumberOfRows: true) 32
33 1 0.3 3172.5 0.3X
+RocksDB (trackTotalNumberOfRows: false) 18
19 1 0.6 1769.4 0.5X
-OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
-AMD EPYC 7763 64-Core Processor
+OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1015-azure
+AMD EPYC 9V74 80-Core Processor
putting 10000 rows (0 rows to overwrite - rate 0): Best Time(ms) Avg
Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
---------------------------------------------------------------------------------------------------------------------------------
-In-memory 9
11 1 1.1 913.2 1.0X
-RocksDB (trackTotalNumberOfRows: true) 47
49 1 0.2 4702.8 0.2X
-RocksDB (trackTotalNumberOfRows: false) 17
18 1 0.6 1740.9 0.5X
+In-memory 8
9 1 1.2 817.9 1.0X
+RocksDB (trackTotalNumberOfRows: true) 30
32 1 0.3 3045.6 0.3X
+RocksDB (trackTotalNumberOfRows: false) 18
19 1 0.5 1831.5 0.4X
================================================================================================
merge rows
================================================================================================
-OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
-AMD EPYC 7763 64-Core Processor
+OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1015-azure
+AMD EPYC 9V74 80-Core Processor
merging 10000 rows with 10 values per key (10000 rows to overwrite - rate
100): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns)
Relative
--------------------------------------------------------------------------------------------------------------------------------------------------------------
-RocksDB (trackTotalNumberOfRows: true)
569 591 8 0.0 56923.9 1.0X
-RocksDB (trackTotalNumberOfRows: false)
192 199 3 0.1 19216.5 3.0X
+RocksDB (trackTotalNumberOfRows: true)
566 582 6 0.0 56623.0 1.0X
+RocksDB (trackTotalNumberOfRows: false)
195 202 3 0.1 19454.1 2.9X
-OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
-AMD EPYC 7763 64-Core Processor
+OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1015-azure
+AMD EPYC 9V74 80-Core Processor
merging 10000 rows with 10 values per key (5000 rows to overwrite - rate 50):
Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------------------------------------------
-RocksDB (trackTotalNumberOfRows: true)
503 516 5 0.0 50331.9 1.0X
-RocksDB (trackTotalNumberOfRows: false)
189 196 3 0.1 18923.8 2.7X
+RocksDB (trackTotalNumberOfRows: true)
485 497 5 0.0 48523.1 1.0X
+RocksDB (trackTotalNumberOfRows: false)
194 200 3 0.1 19447.4 2.5X
-OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
-AMD EPYC 7763 64-Core Processor
+OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1015-azure
+AMD EPYC 9V74 80-Core Processor
merging 10000 rows with 10 values per key (1000 rows to overwrite - rate 10):
Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------------------------------------------
-RocksDB (trackTotalNumberOfRows: true)
446 458 4 0.0 44565.8 1.0X
-RocksDB (trackTotalNumberOfRows: false)
192 199 3 0.1 19193.4 2.3X
+RocksDB (trackTotalNumberOfRows: true)
418 431 5 0.0 41816.9 1.0X
+RocksDB (trackTotalNumberOfRows: false)
193 199 2 0.1 19283.2 2.2X
-OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
-AMD EPYC 7763 64-Core Processor
+OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1015-azure
+AMD EPYC 9V74 80-Core Processor
merging 10000 rows with 10 values per key (0 rows to overwrite - rate 0):
Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
--------------------------------------------------------------------------------------------------------------------------------------------------------
-RocksDB (trackTotalNumberOfRows: true)
430 441 4 0.0 43020.1 1.0X
-RocksDB (trackTotalNumberOfRows: false)
194 199 2 0.1 19424.4 2.2X
+RocksDB (trackTotalNumberOfRows: true)
402 412 5 0.0 40179.3 1.0X
+RocksDB (trackTotalNumberOfRows: false)
193 199 3 0.1 19278.1 2.1X
================================================================================================
delete rows
================================================================================================
-OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
-AMD EPYC 7763 64-Core Processor
+OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1015-azure
+AMD EPYC 9V74 80-Core Processor
trying to delete 10000 rows from 10000 rows(10000 rows are non-existing - rate
100): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns)
Relative
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-In-memory
1 1 0 8.0 125.2
1.0X
-RocksDB (trackTotalNumberOfRows: true)
47 48 1 0.2 4688.5
0.0X
-RocksDB (trackTotalNumberOfRows: false)
17 17 0 0.6 1688.6
0.1X
+In-memory
0 1 0 24.1 41.6
1.0X
+RocksDB (trackTotalNumberOfRows: true)
29 30 1 0.3 2915.2
0.0X
+RocksDB (trackTotalNumberOfRows: false)
16 17 0 0.6 1636.1
0.0X
-OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
-AMD EPYC 7763 64-Core Processor
+OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1015-azure
+AMD EPYC 9V74 80-Core Processor
trying to delete 10000 rows from 10000 rows(5000 rows are non-existing - rate
50): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns)
Relative
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
-In-memory
9 10 0 1.1 885.4
1.0X
-RocksDB (trackTotalNumberOfRows: true)
47 49 1 0.2 4743.4
0.2X
-RocksDB (trackTotalNumberOfRows: false)
17 18 1 0.6 1712.1
0.5X
+In-memory
7 8 1 1.4 693.8
1.0X
+RocksDB (trackTotalNumberOfRows: true)
37 38 1 0.3 3663.5
0.2X
+RocksDB (trackTotalNumberOfRows: false)
17 18 0 0.6 1664.2
0.4X
-OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
-AMD EPYC 7763 64-Core Processor
+OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1015-azure
+AMD EPYC 9V74 80-Core Processor
trying to delete 10000 rows from 10000 rows(1000 rows are non-existing - rate
10): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns)
Relative
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
-In-memory
11 12 0 0.9 1060.9
1.0X
-RocksDB (trackTotalNumberOfRows: true)
46 48 1 0.2 4623.5
0.2X
-RocksDB (trackTotalNumberOfRows: false)
17 18 0 0.6 1709.4
0.6X
+In-memory
8 10 1 1.3 768.8
1.0X
+RocksDB (trackTotalNumberOfRows: true)
42 44 1 0.2 4241.9
0.2X
+RocksDB (trackTotalNumberOfRows: false)
16 17 0 0.6 1632.5
0.5X
-OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
-AMD EPYC 7763 64-Core Processor
+OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1015-azure
+AMD EPYC 9V74 80-Core Processor
trying to delete 10000 rows from 10000 rows(0 rows are non-existing - rate 0):
Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
-------------------------------------------------------------------------------------------------------------------------------------------------------------
-In-memory
10 12 1 1.0 1046.8 1.0X
-RocksDB (trackTotalNumberOfRows: true)
46 47 1 0.2 4567.2 0.2X
-RocksDB (trackTotalNumberOfRows: false)
17 18 0 0.6 1736.0 0.6X
+In-memory
8 9 1 1.3 762.7 1.0X
+RocksDB (trackTotalNumberOfRows: true)
44 45 1 0.2 4373.6 0.2X
+RocksDB (trackTotalNumberOfRows: false)
17 17 0 0.6 1673.3 0.5X
================================================================================================
evict rows
================================================================================================
-OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
-AMD EPYC 7763 64-Core Processor
+OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1015-azure
+AMD EPYC 9V74 80-Core Processor
evicting 10000 rows (maxTimestampToEvictInMillis: 9999) from 10000 rows: Best
Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
-------------------------------------------------------------------------------------------------------------------------------------------------------
-In-memory
8 9 1 1.2 825.1 1.0X
-RocksDB (trackTotalNumberOfRows: true)
44 45 1 0.2 4372.7 0.2X
-RocksDB (trackTotalNumberOfRows: false)
17 18 0 0.6 1720.1 0.5X
+In-memory
8 8 1 1.3 755.2 1.0X
+RocksDB (trackTotalNumberOfRows: true)
41 42 1 0.2 4102.9 0.2X
+RocksDB (trackTotalNumberOfRows: false)
17 17 0 0.6 1674.9 0.5X
-OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
-AMD EPYC 7763 64-Core Processor
+OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1015-azure
+AMD EPYC 9V74 80-Core Processor
evicting 5000 rows (maxTimestampToEvictInMillis: 4999) from 10000 rows: Best
Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------------------------------------
-In-memory
8 8 0 1.3 773.0 1.0X
-RocksDB (trackTotalNumberOfRows: true)
23 24 0 0.4 2346.2 0.3X
-RocksDB (trackTotalNumberOfRows: false)
10 11 0 1.0 1037.9 0.7X
+In-memory
7 8 1 1.4 702.0 1.0X
+RocksDB (trackTotalNumberOfRows: true)
22 23 1 0.5 2218.7 0.3X
+RocksDB (trackTotalNumberOfRows: false)
10 10 0 1.0 1018.1 0.7X
-OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
-AMD EPYC 7763 64-Core Processor
+OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1015-azure
+AMD EPYC 9V74 80-Core Processor
evicting 1000 rows (maxTimestampToEvictInMillis: 999) from 10000 rows: Best
Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
-----------------------------------------------------------------------------------------------------------------------------------------------------
-In-memory
7 8 0 1.4 725.3 1.0X
-RocksDB (trackTotalNumberOfRows: true)
8 8 0 1.3 760.0 1.0X
-RocksDB (trackTotalNumberOfRows: false)
5 5 0 2.0 493.0 1.5X
+In-memory
6 7 0 1.6 628.3 1.0X
+RocksDB (trackTotalNumberOfRows: true)
7 7 0 1.4 710.8 0.9X
+RocksDB (trackTotalNumberOfRows: false)
5 5 0 2.1 470.1 1.3X
-OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
-AMD EPYC 7763 64-Core Processor
+OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1015-azure
+AMD EPYC 9V74 80-Core Processor
evicting 0 rows (maxTimestampToEvictInMillis: -1) from 10000 rows: Best
Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
-------------------------------------------------------------------------------------------------------------------------------------------------
-In-memory
0 1 0 21.7 46.1 1.0X
-RocksDB (trackTotalNumberOfRows: true)
4 4 0 2.9 350.1 0.1X
-RocksDB (trackTotalNumberOfRows: false)
4 4 0 2.8 351.0 0.1X
+In-memory
0 1 0 21.2 47.2 1.0X
+RocksDB (trackTotalNumberOfRows: true)
3 3 0 3.2 314.6 0.2X
+RocksDB (trackTotalNumberOfRows: false)
3 3 0 3.2 316.0 0.1X
diff --git
a/sql/core/benchmarks/StateStoreBasicOperationsBenchmark-jdk25-results.txt
b/sql/core/benchmarks/StateStoreBasicOperationsBenchmark-jdk25-results.txt
index 4cc48772488f..cf293be59ec7 100644
--- a/sql/core/benchmarks/StateStoreBasicOperationsBenchmark-jdk25-results.txt
+++ b/sql/core/benchmarks/StateStoreBasicOperationsBenchmark-jdk25-results.txt
@@ -2,143 +2,143 @@
put rows
================================================================================================
-OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
+OpenJDK 64-Bit Server VM 25.0.3+9-LTS on Linux 6.17.0-1015-azure
AMD EPYC 7763 64-Core Processor
putting 10000 rows (10000 rows to overwrite - rate 100): Best Time(ms) Avg
Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
---------------------------------------------------------------------------------------------------------------------------------------
-In-memory 10
12 1 1.0 1007.1 1.0X
-RocksDB (trackTotalNumberOfRows: true) 44
46 1 0.2 4433.7 0.2X
-RocksDB (trackTotalNumberOfRows: false) 17
18 1 0.6 1712.2 0.6X
+In-memory 8
9 1 1.3 797.2 1.0X
+RocksDB (trackTotalNumberOfRows: true) 46
47 1 0.2 4586.3 0.2X
+RocksDB (trackTotalNumberOfRows: false) 17
18 1 0.6 1710.2 0.5X
-OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
+OpenJDK 64-Bit Server VM 25.0.3+9-LTS on Linux 6.17.0-1015-azure
AMD EPYC 7763 64-Core Processor
putting 10000 rows (5000 rows to overwrite - rate 50): Best Time(ms) Avg
Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
-------------------------------------------------------------------------------------------------------------------------------------
-In-memory 11
12 1 0.9 1053.4 1.0X
-RocksDB (trackTotalNumberOfRows: true) 46
48 1 0.2 4647.3 0.2X
-RocksDB (trackTotalNumberOfRows: false) 17
18 1 0.6 1722.0 0.6X
+In-memory 8
9 1 1.2 820.8 1.0X
+RocksDB (trackTotalNumberOfRows: true) 38
39 1 0.3 3799.8 0.2X
+RocksDB (trackTotalNumberOfRows: false) 17
18 1 0.6 1690.7 0.5X
-OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
+OpenJDK 64-Bit Server VM 25.0.3+9-LTS on Linux 6.17.0-1015-azure
AMD EPYC 7763 64-Core Processor
putting 10000 rows (1000 rows to overwrite - rate 10): Best Time(ms) Avg
Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
-------------------------------------------------------------------------------------------------------------------------------------
-In-memory 11
12 1 0.9 1055.3 1.0X
-RocksDB (trackTotalNumberOfRows: true) 47
48 1 0.2 4703.6 0.2X
-RocksDB (trackTotalNumberOfRows: false) 17
18 1 0.6 1723.5 0.6X
+In-memory 8
9 0 1.2 803.6 1.0X
+RocksDB (trackTotalNumberOfRows: true) 32
33 1 0.3 3177.6 0.3X
+RocksDB (trackTotalNumberOfRows: false) 17
18 1 0.6 1695.9 0.5X
-OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
+OpenJDK 64-Bit Server VM 25.0.3+9-LTS on Linux 6.17.0-1015-azure
AMD EPYC 7763 64-Core Processor
putting 10000 rows (0 rows to overwrite - rate 0): Best Time(ms) Avg
Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
---------------------------------------------------------------------------------------------------------------------------------
-In-memory 11
12 1 0.9 1090.7 1.0X
-RocksDB (trackTotalNumberOfRows: true) 46
48 1 0.2 4623.5 0.2X
-RocksDB (trackTotalNumberOfRows: false) 17
18 1 0.6 1686.2 0.6X
+In-memory 8
9 0 1.3 797.7 1.0X
+RocksDB (trackTotalNumberOfRows: true) 30
31 1 0.3 2973.5 0.3X
+RocksDB (trackTotalNumberOfRows: false) 17
17 1 0.6 1683.4 0.5X
================================================================================================
merge rows
================================================================================================
-OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
+OpenJDK 64-Bit Server VM 25.0.3+9-LTS on Linux 6.17.0-1015-azure
AMD EPYC 7763 64-Core Processor
merging 10000 rows with 10 values per key (10000 rows to overwrite - rate
100): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns)
Relative
--------------------------------------------------------------------------------------------------------------------------------------------------------------
-RocksDB (trackTotalNumberOfRows: true)
563 578 7 0.0 56330.0 1.0X
-RocksDB (trackTotalNumberOfRows: false)
191 198 3 0.1 19085.8 3.0X
+RocksDB (trackTotalNumberOfRows: true)
578 591 6 0.0 57761.1 1.0X
+RocksDB (trackTotalNumberOfRows: false)
188 194 3 0.1 18832.2 3.1X
-OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
+OpenJDK 64-Bit Server VM 25.0.3+9-LTS on Linux 6.17.0-1015-azure
AMD EPYC 7763 64-Core Processor
merging 10000 rows with 10 values per key (5000 rows to overwrite - rate 50):
Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------------------------------------------
-RocksDB (trackTotalNumberOfRows: true)
491 506 7 0.0 49129.4 1.0X
-RocksDB (trackTotalNumberOfRows: false)
189 194 3 0.1 18878.6 2.6X
+RocksDB (trackTotalNumberOfRows: true)
490 503 5 0.0 48995.7 1.0X
+RocksDB (trackTotalNumberOfRows: false)
188 193 2 0.1 18782.1 2.6X
-OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
+OpenJDK 64-Bit Server VM 25.0.3+9-LTS on Linux 6.17.0-1015-azure
AMD EPYC 7763 64-Core Processor
merging 10000 rows with 10 values per key (1000 rows to overwrite - rate 10):
Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------------------------------------------
-RocksDB (trackTotalNumberOfRows: true)
436 445 5 0.0 43595.1 1.0X
-RocksDB (trackTotalNumberOfRows: false)
190 196 3 0.1 18980.9 2.3X
+RocksDB (trackTotalNumberOfRows: true)
421 431 4 0.0 42148.5 1.0X
+RocksDB (trackTotalNumberOfRows: false)
188 193 2 0.1 18784.4 2.2X
-OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
+OpenJDK 64-Bit Server VM 25.0.3+9-LTS on Linux 6.17.0-1015-azure
AMD EPYC 7763 64-Core Processor
merging 10000 rows with 10 values per key (0 rows to overwrite - rate 0):
Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
--------------------------------------------------------------------------------------------------------------------------------------------------------
-RocksDB (trackTotalNumberOfRows: true)
421 431 4 0.0 42101.7 1.0X
-RocksDB (trackTotalNumberOfRows: false)
190 194 2 0.1 18979.7 2.2X
+RocksDB (trackTotalNumberOfRows: true)
399 409 4 0.0 39889.5 1.0X
+RocksDB (trackTotalNumberOfRows: false)
185 190 2 0.1 18454.2 2.2X
================================================================================================
delete rows
================================================================================================
-OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
+OpenJDK 64-Bit Server VM 25.0.3+9-LTS on Linux 6.17.0-1015-azure
AMD EPYC 7763 64-Core Processor
trying to delete 10000 rows from 10000 rows(10000 rows are non-existing - rate
100): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns)
Relative
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-In-memory
0 1 0 20.4 49.1
1.0X
-RocksDB (trackTotalNumberOfRows: true)
46 47 2 0.2 4590.3
0.0X
-RocksDB (trackTotalNumberOfRows: false)
17 17 0 0.6 1656.1
0.0X
+In-memory
0 1 0 23.6 42.4
1.0X
+RocksDB (trackTotalNumberOfRows: true)
29 31 1 0.3 2946.4
0.0X
+RocksDB (trackTotalNumberOfRows: false)
17 17 0 0.6 1654.2
0.0X
-OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
+OpenJDK 64-Bit Server VM 25.0.3+9-LTS on Linux 6.17.0-1015-azure
AMD EPYC 7763 64-Core Processor
trying to delete 10000 rows from 10000 rows(5000 rows are non-existing - rate
50): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns)
Relative
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
-In-memory
8 9 0 1.2 819.1
1.0X
-RocksDB (trackTotalNumberOfRows: true)
46 47 1 0.2 4609.9
0.2X
-RocksDB (trackTotalNumberOfRows: false)
17 18 2 0.6 1696.3
0.5X
+In-memory
6 7 0 1.6 638.0
1.0X
+RocksDB (trackTotalNumberOfRows: true)
37 38 1 0.3 3717.0
0.2X
+RocksDB (trackTotalNumberOfRows: false)
16 17 0 0.6 1572.3
0.4X
-OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
+OpenJDK 64-Bit Server VM 25.0.3+9-LTS on Linux 6.17.0-1015-azure
AMD EPYC 7763 64-Core Processor
trying to delete 10000 rows from 10000 rows(1000 rows are non-existing - rate
10): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns)
Relative
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
-In-memory
9 10 1 1.1 900.0
1.0X
-RocksDB (trackTotalNumberOfRows: true)
45 47 1 0.2 4515.5
0.2X
-RocksDB (trackTotalNumberOfRows: false)
17 18 0 0.6 1700.8
0.5X
+In-memory
7 7 0 1.4 691.0
1.0X
+RocksDB (trackTotalNumberOfRows: true)
43 44 0 0.2 4338.9
0.2X
+RocksDB (trackTotalNumberOfRows: false)
16 17 0 0.6 1594.7
0.4X
-OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
+OpenJDK 64-Bit Server VM 25.0.3+9-LTS on Linux 6.17.0-1015-azure
AMD EPYC 7763 64-Core Processor
trying to delete 10000 rows from 10000 rows(0 rows are non-existing - rate 0):
Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
-------------------------------------------------------------------------------------------------------------------------------------------------------------
-In-memory
10 11 1 1.1 952.4 1.0X
-RocksDB (trackTotalNumberOfRows: true)
46 47 1 0.2 4585.3 0.2X
-RocksDB (trackTotalNumberOfRows: false)
18 18 1 0.6 1761.6 0.5X
+In-memory
7 8 0 1.4 693.2 1.0X
+RocksDB (trackTotalNumberOfRows: true)
44 46 1 0.2 4449.0 0.2X
+RocksDB (trackTotalNumberOfRows: false)
16 17 1 0.6 1572.7 0.4X
================================================================================================
evict rows
================================================================================================
-OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
+OpenJDK 64-Bit Server VM 25.0.3+9-LTS on Linux 6.17.0-1015-azure
AMD EPYC 7763 64-Core Processor
evicting 10000 rows (maxTimestampToEvictInMillis: 9999) from 10000 rows: Best
Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
-------------------------------------------------------------------------------------------------------------------------------------------------------
-In-memory
10 11 1 1.0 1002.4 1.0X
-RocksDB (trackTotalNumberOfRows: true)
43 44 1 0.2 4283.2 0.2X
-RocksDB (trackTotalNumberOfRows: false)
17 18 1 0.6 1719.0 0.6X
+In-memory
7 7 0 1.5 687.1 1.0X
+RocksDB (trackTotalNumberOfRows: true)
44 45 1 0.2 4366.2 0.2X
+RocksDB (trackTotalNumberOfRows: false)
17 18 0 0.6 1720.3 0.4X
-OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
+OpenJDK 64-Bit Server VM 25.0.3+9-LTS on Linux 6.17.0-1015-azure
AMD EPYC 7763 64-Core Processor
evicting 5000 rows (maxTimestampToEvictInMillis: 4999) from 10000 rows: Best
Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------------------------------------
-In-memory
9 10 1 1.2 862.9 1.0X
-RocksDB (trackTotalNumberOfRows: true)
23 24 1 0.4 2295.3 0.4X
-RocksDB (trackTotalNumberOfRows: false)
10 10 0 1.0 1008.8 0.9X
+In-memory
6 7 0 1.6 634.8 1.0X
+RocksDB (trackTotalNumberOfRows: true)
23 24 1 0.4 2334.2 0.3X
+RocksDB (trackTotalNumberOfRows: false)
10 11 0 1.0 1026.8 0.6X
-OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
+OpenJDK 64-Bit Server VM 25.0.3+9-LTS on Linux 6.17.0-1015-azure
AMD EPYC 7763 64-Core Processor
evicting 1000 rows (maxTimestampToEvictInMillis: 999) from 10000 rows: Best
Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
-----------------------------------------------------------------------------------------------------------------------------------------------------
-In-memory
8 9 1 1.2 801.3 1.0X
-RocksDB (trackTotalNumberOfRows: true)
7 8 0 1.4 731.0 1.1X
-RocksDB (trackTotalNumberOfRows: false)
5 5 0 2.1 472.5 1.7X
+In-memory
6 6 0 1.8 564.1 1.0X
+RocksDB (trackTotalNumberOfRows: true)
8 8 0 1.3 755.6 0.7X
+RocksDB (trackTotalNumberOfRows: false)
5 5 0 2.0 491.5 1.1X
-OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
+OpenJDK 64-Bit Server VM 25.0.3+9-LTS on Linux 6.17.0-1015-azure
AMD EPYC 7763 64-Core Processor
evicting 0 rows (maxTimestampToEvictInMillis: -1) from 10000 rows: Best
Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
-------------------------------------------------------------------------------------------------------------------------------------------------
-In-memory
0 1 0 24.4 41.0 1.0X
-RocksDB (trackTotalNumberOfRows: true)
3 3 0 3.0 332.0 0.1X
-RocksDB (trackTotalNumberOfRows: false)
3 3 0 3.0 331.6 0.1X
+In-memory
0 0 0 25.0 39.9 1.0X
+RocksDB (trackTotalNumberOfRows: true)
3 4 0 2.9 348.0 0.1X
+RocksDB (trackTotalNumberOfRows: false)
3 4 0 2.9 348.7 0.1X
diff --git a/sql/core/benchmarks/StateStoreBasicOperationsBenchmark-results.txt
b/sql/core/benchmarks/StateStoreBasicOperationsBenchmark-results.txt
index c271653cdc23..844d5c92d8f3 100644
--- a/sql/core/benchmarks/StateStoreBasicOperationsBenchmark-results.txt
+++ b/sql/core/benchmarks/StateStoreBasicOperationsBenchmark-results.txt
@@ -2,143 +2,143 @@
put rows
================================================================================================
-OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
-Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
+OpenJDK 64-Bit Server VM 17.0.19+10-LTS on Linux 6.17.0-1013-azure
+AMD EPYC 9V74 80-Core Processor
putting 10000 rows (10000 rows to overwrite - rate 100): Best Time(ms) Avg
Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
---------------------------------------------------------------------------------------------------------------------------------------
-In-memory 7
8 1 1.3 748.1 1.0X
-RocksDB (trackTotalNumberOfRows: true) 45
47 1 0.2 4538.7 0.2X
-RocksDB (trackTotalNumberOfRows: false) 17
18 1 0.6 1730.3 0.4X
+In-memory 9
10 1 1.2 869.2 1.0X
+RocksDB (trackTotalNumberOfRows: true) 46
48 1 0.2 4588.3 0.2X
+RocksDB (trackTotalNumberOfRows: false) 18
20 1 0.5 1840.6 0.5X
-OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
-Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
+OpenJDK 64-Bit Server VM 17.0.19+10-LTS on Linux 6.17.0-1013-azure
+AMD EPYC 9V74 80-Core Processor
putting 10000 rows (5000 rows to overwrite - rate 50): Best Time(ms) Avg
Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
-------------------------------------------------------------------------------------------------------------------------------------
-In-memory 7
8 1 1.4 733.5 1.0X
-RocksDB (trackTotalNumberOfRows: true) 47
48 1 0.2 4696.3 0.2X
-RocksDB (trackTotalNumberOfRows: false) 17
18 1 0.6 1694.2 0.4X
+In-memory 9
10 1 1.2 866.2 1.0X
+RocksDB (trackTotalNumberOfRows: true) 38
40 1 0.3 3833.2 0.2X
+RocksDB (trackTotalNumberOfRows: false) 18
19 0 0.5 1831.1 0.5X
-OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
-Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
+OpenJDK 64-Bit Server VM 17.0.19+10-LTS on Linux 6.17.0-1013-azure
+AMD EPYC 9V74 80-Core Processor
putting 10000 rows (1000 rows to overwrite - rate 10): Best Time(ms) Avg
Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
-------------------------------------------------------------------------------------------------------------------------------------
-In-memory 7
8 0 1.4 712.5 1.0X
-RocksDB (trackTotalNumberOfRows: true) 47
48 1 0.2 4697.9 0.2X
-RocksDB (trackTotalNumberOfRows: false) 17
18 1 0.6 1669.6 0.4X
+In-memory 8
9 1 1.2 834.1 1.0X
+RocksDB (trackTotalNumberOfRows: true) 33
34 1 0.3 3265.3 0.3X
+RocksDB (trackTotalNumberOfRows: false) 18
20 1 0.5 1844.5 0.5X
-OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
-Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
+OpenJDK 64-Bit Server VM 17.0.19+10-LTS on Linux 6.17.0-1013-azure
+AMD EPYC 9V74 80-Core Processor
putting 10000 rows (0 rows to overwrite - rate 0): Best Time(ms) Avg
Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
---------------------------------------------------------------------------------------------------------------------------------
-In-memory 7
8 0 1.4 710.6 1.0X
-RocksDB (trackTotalNumberOfRows: true) 47
48 1 0.2 4662.1 0.2X
-RocksDB (trackTotalNumberOfRows: false) 17
18 1 0.6 1671.4 0.4X
+In-memory 8
10 1 1.2 839.2 1.0X
+RocksDB (trackTotalNumberOfRows: true) 31
32 2 0.3 3058.7 0.3X
+RocksDB (trackTotalNumberOfRows: false) 18
19 1 0.6 1811.1 0.5X
================================================================================================
merge rows
================================================================================================
-OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
-Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
+OpenJDK 64-Bit Server VM 17.0.19+10-LTS on Linux 6.17.0-1013-azure
+AMD EPYC 9V74 80-Core Processor
merging 10000 rows with 10 values per key (10000 rows to overwrite - rate
100): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns)
Relative
--------------------------------------------------------------------------------------------------------------------------------------------------------------
-RocksDB (trackTotalNumberOfRows: true)
592 602 4 0.0 59211.0 1.0X
-RocksDB (trackTotalNumberOfRows: false)
191 196 2 0.1 19128.3 3.1X
+RocksDB (trackTotalNumberOfRows: true)
569 584 9 0.0 56882.8 1.0X
+RocksDB (trackTotalNumberOfRows: false)
200 207 4 0.1 19975.3 2.8X
-OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
-Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
+OpenJDK 64-Bit Server VM 17.0.19+10-LTS on Linux 6.17.0-1013-azure
+AMD EPYC 9V74 80-Core Processor
merging 10000 rows with 10 values per key (5000 rows to overwrite - rate 50):
Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------------------------------------------
-RocksDB (trackTotalNumberOfRows: true)
519 531 5 0.0 51897.1 1.0X
-RocksDB (trackTotalNumberOfRows: false)
186 191 3 0.1 18640.4 2.8X
+RocksDB (trackTotalNumberOfRows: true)
495 507 7 0.0 49487.6 1.0X
+RocksDB (trackTotalNumberOfRows: false)
202 208 4 0.0 20176.7 2.5X
-OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
-Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
+OpenJDK 64-Bit Server VM 17.0.19+10-LTS on Linux 6.17.0-1013-azure
+AMD EPYC 9V74 80-Core Processor
merging 10000 rows with 10 values per key (1000 rows to overwrite - rate 10):
Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------------------------------------------
-RocksDB (trackTotalNumberOfRows: true)
457 467 4 0.0 45714.3 1.0X
-RocksDB (trackTotalNumberOfRows: false)
186 191 2 0.1 18596.1 2.5X
+RocksDB (trackTotalNumberOfRows: true)
431 444 8 0.0 43111.3 1.0X
+RocksDB (trackTotalNumberOfRows: false)
200 207 4 0.1 19961.4 2.2X
-OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
-Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
+OpenJDK 64-Bit Server VM 17.0.19+10-LTS on Linux 6.17.0-1013-azure
+AMD EPYC 9V74 80-Core Processor
merging 10000 rows with 10 values per key (0 rows to overwrite - rate 0):
Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
--------------------------------------------------------------------------------------------------------------------------------------------------------
-RocksDB (trackTotalNumberOfRows: true)
441 451 6 0.0 44139.3 1.0X
-RocksDB (trackTotalNumberOfRows: false)
187 191 2 0.1 18667.9 2.4X
+RocksDB (trackTotalNumberOfRows: true)
410 421 7 0.0 40973.1 1.0X
+RocksDB (trackTotalNumberOfRows: false)
199 205 3 0.1 19939.5 2.1X
================================================================================================
delete rows
================================================================================================
-OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
-Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
+OpenJDK 64-Bit Server VM 17.0.19+10-LTS on Linux 6.17.0-1013-azure
+AMD EPYC 9V74 80-Core Processor
trying to delete 10000 rows from 10000 rows(10000 rows are non-existing - rate
100): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns)
Relative
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-In-memory
0 1 0 21.9 45.6
1.0X
-RocksDB (trackTotalNumberOfRows: true)
46 47 0 0.2 4611.7
0.0X
-RocksDB (trackTotalNumberOfRows: false)
16 17 1 0.6 1631.2
0.0X
+In-memory
0 1 0 23.7 42.2
1.0X
+RocksDB (trackTotalNumberOfRows: true)
30 31 1 0.3 2989.3
0.0X
+RocksDB (trackTotalNumberOfRows: false)
18 18 1 0.6 1763.9
0.0X
-OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
-Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
+OpenJDK 64-Bit Server VM 17.0.19+10-LTS on Linux 6.17.0-1013-azure
+AMD EPYC 9V74 80-Core Processor
trying to delete 10000 rows from 10000 rows(5000 rows are non-existing - rate
50): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns)
Relative
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
-In-memory
6 6 0 1.8 569.8
1.0X
-RocksDB (trackTotalNumberOfRows: true)
47 48 1 0.2 4653.5
0.1X
-RocksDB (trackTotalNumberOfRows: false)
17 18 0 0.6 1690.5
0.3X
+In-memory
7 9 1 1.4 718.8
1.0X
+RocksDB (trackTotalNumberOfRows: true)
37 39 1 0.3 3745.8
0.2X
+RocksDB (trackTotalNumberOfRows: false)
17 18 1 0.6 1749.8
0.4X
-OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
-Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
+OpenJDK 64-Bit Server VM 17.0.19+10-LTS on Linux 6.17.0-1013-azure
+AMD EPYC 9V74 80-Core Processor
trying to delete 10000 rows from 10000 rows(1000 rows are non-existing - rate
10): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns)
Relative
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
-In-memory
6 7 0 1.6 620.0
1.0X
-RocksDB (trackTotalNumberOfRows: true)
45 46 2 0.2 4487.9
0.1X
-RocksDB (trackTotalNumberOfRows: false)
17 18 0 0.6 1722.2
0.4X
+In-memory
7 8 0 1.4 740.5
1.0X
+RocksDB (trackTotalNumberOfRows: true)
43 44 1 0.2 4267.4
0.2X
+RocksDB (trackTotalNumberOfRows: false)
17 18 1 0.6 1733.6
0.4X
-OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
-Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
+OpenJDK 64-Bit Server VM 17.0.19+10-LTS on Linux 6.17.0-1013-azure
+AMD EPYC 9V74 80-Core Processor
trying to delete 10000 rows from 10000 rows(0 rows are non-existing - rate 0):
Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
-------------------------------------------------------------------------------------------------------------------------------------------------------------
-In-memory
6 7 0 1.6 645.0 1.0X
-RocksDB (trackTotalNumberOfRows: true)
45 46 0 0.2 4482.8 0.1X
-RocksDB (trackTotalNumberOfRows: false)
16 17 1 0.6 1606.7 0.4X
+In-memory
8 8 1 1.3 750.6 1.0X
+RocksDB (trackTotalNumberOfRows: true)
44 46 1 0.2 4427.8 0.2X
+RocksDB (trackTotalNumberOfRows: false)
17 18 1 0.6 1720.8 0.4X
================================================================================================
evict rows
================================================================================================
-OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
-Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
+OpenJDK 64-Bit Server VM 17.0.19+10-LTS on Linux 6.17.0-1013-azure
+AMD EPYC 9V74 80-Core Processor
evicting 10000 rows (maxTimestampToEvictInMillis: 9999) from 10000 rows: Best
Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
-------------------------------------------------------------------------------------------------------------------------------------------------------
-In-memory
6 7 0 1.6 631.8 1.0X
-RocksDB (trackTotalNumberOfRows: true)
45 46 0 0.2 4495.7 0.1X
-RocksDB (trackTotalNumberOfRows: false)
18 18 0 0.6 1787.7 0.4X
+In-memory
7 8 0 1.4 731.3 1.0X
+RocksDB (trackTotalNumberOfRows: true)
42 43 1 0.2 4189.1 0.2X
+RocksDB (trackTotalNumberOfRows: false)
17 18 0 0.6 1746.0 0.4X
-OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
-Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
+OpenJDK 64-Bit Server VM 17.0.19+10-LTS on Linux 6.17.0-1013-azure
+AMD EPYC 9V74 80-Core Processor
evicting 5000 rows (maxTimestampToEvictInMillis: 4999) from 10000 rows: Best
Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------------------------------------
-In-memory
6 6 0 1.7 578.6 1.0X
-RocksDB (trackTotalNumberOfRows: true)
25 25 0 0.4 2491.4 0.2X
-RocksDB (trackTotalNumberOfRows: false)
11 12 0 0.9 1109.9 0.5X
+In-memory
7 7 0 1.5 685.9 1.0X
+RocksDB (trackTotalNumberOfRows: true)
23 24 1 0.4 2286.2 0.3X
+RocksDB (trackTotalNumberOfRows: false)
11 11 0 0.9 1061.3 0.6X
-OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
-Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
+OpenJDK 64-Bit Server VM 17.0.19+10-LTS on Linux 6.17.0-1013-azure
+AMD EPYC 9V74 80-Core Processor
evicting 1000 rows (maxTimestampToEvictInMillis: 999) from 10000 rows: Best
Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
-----------------------------------------------------------------------------------------------------------------------------------------------------
-In-memory
5 6 0 2.0 507.3 1.0X
-RocksDB (trackTotalNumberOfRows: true)
8 9 0 1.2 806.0 0.6X
-RocksDB (trackTotalNumberOfRows: false)
5 6 0 1.9 532.7 1.0X
+In-memory
6 7 0 1.6 624.0 1.0X
+RocksDB (trackTotalNumberOfRows: true)
7 8 1 1.4 719.4 0.9X
+RocksDB (trackTotalNumberOfRows: false)
5 5 0 2.1 473.6 1.3X
-OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.14.0-1017-azure
-Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
+OpenJDK 64-Bit Server VM 17.0.19+10-LTS on Linux 6.17.0-1013-azure
+AMD EPYC 9V74 80-Core Processor
evicting 0 rows (maxTimestampToEvictInMillis: -1) from 10000 rows: Best
Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
-------------------------------------------------------------------------------------------------------------------------------------------------
-In-memory
1 1 0 19.2 52.2 1.0X
-RocksDB (trackTotalNumberOfRows: true)
4 4 0 2.7 370.1 0.1X
-RocksDB (trackTotalNumberOfRows: false)
4 4 0 2.7 368.8 0.1X
+In-memory
0 1 0 20.0 49.9 1.0X
+RocksDB (trackTotalNumberOfRows: true)
3 3 0 3.2 313.0 0.2X
+RocksDB (trackTotalNumberOfRows: false)
3 3 0 3.2 313.9 0.2X
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
