ddd

Intel Core i9-13900K testing with a ASUS PRIME Z790-P WIFI (0812 BIOS) and AMD Radeon RX 7700S/7600S/7600M XT 8GB on Ubuntu 22.04 via the Phoronix Test Suite.

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2309098-PTS-DDD9785724
Jump To Table - Results

View

Do Not Show Noisy Results
Do Not Show Results With Incomplete Data
Do Not Show Results With Little Change/Spread
List Notable Results
Show Result Confidence Charts

Statistics

Show Overall Harmonic Mean(s)
Show Overall Geometric Mean
Show Wins / Losses Counts (Pie Chart)
Normalize Results
Remove Outliers Before Calculating Averages

Graph Settings

Force Line Graphs Where Applicable
Convert To Scalar Where Applicable
Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Highlight
Result
Hide
Result
Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
a
September 07 2023
  10 Hours, 41 Minutes
b
September 08 2023
  9 Hours, 50 Minutes
c
September 08 2023
  2 Hours, 9 Minutes
d
September 08 2023
  2 Hours, 1 Minute
e
September 09 2023
  2 Hours, 9 Minutes
Invert Hiding All Results Option
  5 Hours, 22 Minutes

Only show results where is faster than
Only show results matching title/arguments (delimit multiple options with a comma):
Do not show results matching title/arguments (delimit multiple options with a comma):

a

Kernel Notes: Transparent Huge Pages: madvise
Processor Notes: Scaling Governor: intel_pstate powersave (EPP: balance_performance) - CPU Microcode: 0x119 - Thermald 2.4.9
Java Notes: OpenJDK Runtime Environment (build 11.0.20.1+1-post-Ubuntu-0ubuntu122.04)
Security Notes: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced / Automatic IBRS IBPB: conditional RSB filling PBRSB-eIBRS: SW sequence + srbds: Not affected + tsx_async_abort: Not affected

b

c

d

e

Processor: Intel Core i9-13900K @ 5.50GHz (24 Cores / 32 Threads), Motherboard: ASUS PRIME Z790-P WIFI (0812 BIOS), Chipset: Intel Device 7a27, Memory: 32GB, Disk: 1000GB Western Digital WDS100T1X0E-00AFY0, Graphics: AMD Radeon RX 7700S/7600S/7600M XT 8GB (1940/1124MHz), Audio: Realtek ALC897, Monitor: ASUS VP28U

OS: Ubuntu 22.04, Kernel: 6.4.6-060406-generic (x86_64), Desktop: GNOME Shell 42.9, Display Server: X Server 1.21.1.4 + Wayland, OpenGL: 4.6 Mesa 23.3~git2308070600.777734~oibaf~j (git-7777349 2023-08-07 jammy-oibaf-ppa) (LLVM 15.0.7 DRM 3.52), OpenCL: OpenCL 1.1 Mesa 23.3~git2308020600.4de7e0~oibaf~j (git-4de7e00 2023-08-02 jammy-oibaf-ppa) + OpenCL 3.0, Vulkan: 1.3.258, Compiler: GCC 11.4.0 + Clang 16.0.6 + LLVM 16.0.6, File-System: ext4, Screen Resolution: 3840x2160

dddOpenBenchmarking.orgPhoronix Test SuiteIntel Core i9-13900K @ 5.50GHz (24 Cores / 32 Threads)ASUS PRIME Z790-P WIFI (0812 BIOS)Intel Device 7a2732GB1000GB Western Digital WDS100T1X0E-00AFY0AMD Radeon RX 7700S/7600S/7600M XT 8GB (1940/1124MHz)Realtek ALC897ASUS VP28UUbuntu 22.046.4.6-060406-generic (x86_64)GNOME Shell 42.9X Server 1.21.1.4 + Wayland4.6 Mesa 23.3~git2308070600.777734~oibaf~j (git-7777349 2023-08-07 jammy-oibaf-ppa) (LLVM 15.0.7 DRM 3.52)OpenCL 1.1 Mesa 23.3~git2308020600.4de7e0~oibaf~j (git-4de7e00 2023-08-02 jammy-oibaf-ppa) + OpenCL 3.01.3.258GCC 11.4.0 + Clang 16.0.6 + LLVM 16.0.6ext43840x2160ProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorOSKernelDesktopDisplay ServerOpenGLOpenCLVulkanCompilerFile-SystemScreen ResolutionDdd BenchmarksSystem Logs- Transparent Huge Pages: madvise- Scaling Governor: intel_pstate powersave (EPP: balance_performance) - CPU Microcode: 0x119 - Thermald 2.4.9- OpenJDK Runtime Environment (build 11.0.20.1+1-post-Ubuntu-0ubuntu122.04)- itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced / Automatic IBRS IBPB: conditional RSB filling PBRSB-eIBRS: SW sequence + srbds: Not affected + tsx_async_abort: Not affected

abcdeLogarithmic Result OverviewPhoronix Test SuiteApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopTiDB Community ServerTiDB Community ServerApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopFile Status - 100 - 1000000Open - 100 - 1000000Open - 500 - 100000File Status - 500 - 100000File Status - 50 - 100000File Status - 100 - 100000File Status - 20 - 1000000File Status - 50 - 1000000File Status - 500 - 1000000Open - 100 - 100000Open - 50 - 100000Open - 500 - 1000000Rename - 50 - 100000Open - 20 - 1000000Delete - 100 - 1000000Rename - 500 - 100000Delete - 500 - 100000Open - 50 - 1000000Rename - 100 - 100000Open - 20 - 100000Delete - 100 - 100000Create - 500 - 100000File Status - 20 - 100000Delete - 500 - 1000000Rename - 500 - 1000000Rename - 100 - 1000000Create - 100 - 100000Delete - 50 - 100000Delete - 20 - 1000000Delete - 20 - 100000Delete - 50 - 1000000Create - 500 - 1000000Rename - 50 - 1000000oltp_point_select - 1oltp_read_write - 64Create - 50 - 100000Rename - 20 - 1000000Rename - 20 - 100000Create - 20 - 100000Create - 100 - 1000000Create - 20 - 1000000Create - 50 - 1000000

dddtidb: oltp_read_write - 16hadoop: Rename - 50 - 100000hadoop: Delete - 100 - 1000000hadoop: Delete - 500 - 100000hadoop: Rename - 100 - 100000hadoop: Create - 500 - 100000hadoop: Delete - 500 - 1000000hadoop: Rename - 500 - 1000000tidb: oltp_update_index - 1hadoop: Rename - 100 - 1000000hadoop: Create - 100 - 100000hadoop: Delete - 50 - 100000hadoop: Delete - 20 - 1000000hadoop: Delete - 20 - 100000hadoop: Delete - 50 - 1000000hadoop: Create - 500 - 1000000hadoop: Rename - 50 - 1000000tidb: oltp_point_select - 1tidb: oltp_read_write - 64tidb: oltp_update_non_index - 64hadoop: Create - 50 - 100000tidb: oltp_read_write - 1tidb: oltp_update_index - 32tidb: oltp_point_select - 32hadoop: Rename - 20 - 1000000hadoop: Rename - 20 - 100000hadoop: Create - 20 - 100000tidb: oltp_point_select - 16hadoop: Create - 100 - 1000000tidb: oltp_point_select - 64tidb: oltp_read_write - 32hadoop: Create - 20 - 1000000tidb: oltp_update_non_index - 32tidb: oltp_update_non_index - 1hadoop: Create - 50 - 1000000tidb: oltp_update_index - 16tidb: oltp_update_index - 64hadoop: File Status - 500 - 1000000hadoop: File Status - 100 - 1000000hadoop: File Status - 500 - 100000hadoop: File Status - 50 - 1000000hadoop: File Status - 20 - 1000000hadoop: File Status - 100 - 100000hadoop: File Status - 50 - 100000hadoop: File Status - 20 - 100000hadoop: Rename - 500 - 100000hadoop: Delete - 100 - 100000hadoop: Open - 500 - 1000000hadoop: Open - 100 - 1000000hadoop: Open - 500 - 100000hadoop: Open - 50 - 1000000hadoop: Open - 20 - 1000000hadoop: Open - 100 - 100000hadoop: Open - 50 - 100000hadoop: Open - 20 - 100000tidb: oltp_update_non_index - 16abcde41637887371560201378261036697196614796910529741510691579154953974664045783101420847219013526937881920927744627703160292416664174639411111533920111884804102552286424426216327248658821053241125556264515526442871207762107212513125071021961444891795184143284985879519551261870450836613953358105260568308994116093113546110740169817148242100460397107389793049699445378459719856984647900202666782742140574628114015944041936416973946911042792142649694073410441868301631825335111762981114325627038572323924115909512092261386155100078141379159144515441498988461865586178385484615198354910595406841359297974514267413587099206746831401741032203981086138183398814462884597798290841968832426438012275075115916152941360413913912491592189475652824094010427519866632754821435920952381238663526109668849561282051133333391743139470185185219193866578951926782200000084033610989011086957883391457731250001062706988114734110463539911175782508993054669046019101122854999022026367914121401752451151782241971418593903292498653484089110500864902739726298507565789530120482538071106383086956513888899514713774117006804046944672902032520203252090909194339611363646472365159132415299913175210000072993143988100361110278797459708746845445831007968670090654270078684212787593011451590854180841929393709181119010765458408805208678342593039514304878010416672849003305810410101011010101131578991575147710179533218691598620691926782195694799009910101011111111OpenBenchmarking.org

TiDB Community Server

This is a PingCAP TiDB Community Server benchmark facilitated using the sysbench OLTP database benchmarks. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_read_write - Threads: 16ace9K18K27K36K45KSE +/- 172.53, N = 3416373592936515

Test: oltp_read_write - Threads: 16

b: The test quit with a non-zero exit status. E: FATAL: Thread initialization failed!

d: The test quit with a non-zero exit status. E: FATAL: Thread initialization failed!

Apache Hadoop

This is a benchmark of the Apache Hadoop making use of its built-in name-node throughput benchmark (NNThroughputBenchmark). Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 50 - Files: 100000abcde20K40K60K80K100KSE +/- 489.92, N = 3SE +/- 756.16, N = 38873789941797458833991324

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 100 - Files: 1000000abcde30K60K90K120K150KSE +/- 1735.70, N = 5SE +/- 1016.01, N = 3156020160931142674145773152999

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 500 - Files: 100000abcde30K60K90K120K150KSE +/- 1218.17, N = 3SE +/- 1197.30, N = 3137826135461135870125000131752

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 100 - Files: 100000abcde20K40K60K80K100KSE +/- 1485.49, N = 3SE +/- 1239.01, N = 310366910740199206106270100000

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 500 - Files: 100000abcde16K32K48K64K80KSE +/- 918.61, N = 3SE +/- 113.81, N = 37196669817746836988172993

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 500 - Files: 1000000abcde30K60K90K120K150KSE +/- 1877.02, N = 3SE +/- 1795.54, N = 3147969148242140174147341143988

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 500 - Files: 1000000abcde20K40K60K80K100KSE +/- 788.38, N = 11SE +/- 649.94, N = 3105297100460103220104635100361

TiDB Community Server

This is a PingCAP TiDB Community Server benchmark facilitated using the sysbench OLTP database benchmarks. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_index - Threads: 1abcd90180270360450SE +/- 5.96, N = 4SE +/- 0.09, N = 2415397398399

Test: oltp_update_index - Threads: 1

e: The test quit with a non-zero exit status. E: FATAL: Thread initialization failed!

Apache Hadoop

This is a benchmark of the Apache Hadoop making use of its built-in name-node throughput benchmark (NNThroughputBenchmark). Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 100 - Files: 1000000abcde20K40K60K80K100KSE +/- 889.38, N = 15SE +/- 722.51, N = 15106915107389108613111757110278

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 100 - Files: 100000abcde20K40K60K80K100KSE +/- 878.95, N = 3SE +/- 960.46, N = 37915479304818338250879745

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 50 - Files: 100000abcde20K40K60K80K100KSE +/- 1343.10, N = 3SE +/- 196.10, N = 39539796994988149930597087

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 20 - Files: 1000000abcde10K20K30K40K50KSE +/- 153.67, N = 3SE +/- 122.94, N = 34664045378462884669046845

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 20 - Files: 100000abcde10K20K30K40K50KSE +/- 224.98, N = 3SE +/- 141.32, N = 34578345971459774601944583

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 50 - Files: 1000000abcde20K40K60K80K100KSE +/- 115.94, N = 3SE +/- 1235.91, N = 31014209856998290101122100796

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 500 - Files: 1000000abcde20K40K60K80K100KSE +/- 655.90, N = 13SE +/- 510.57, N = 38472184647841968549986700

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 50 - Files: 1000000abcde20K40K60K80K100KSE +/- 452.79, N = 3SE +/- 498.27, N = 39013590020883249022090654

TiDB Community Server

This is a PingCAP TiDB Community Server benchmark facilitated using the sysbench OLTP database benchmarks. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_point_select - Threads: 1abcde6001200180024003000SE +/- 4.28, N = 2SE +/- 8.07, N = 326932666264326362700

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_read_write - Threads: 64abcde20K40K60K80K100KSE +/- 255.80, N = 2SE +/- 133.87, N = 37881978274801227914178684

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_non_index - Threads: 64abde5K10K15K20K25KSE +/- 110.67, N = 320927214052140121278

Test: oltp_update_non_index - Threads: 64

c: The test quit with a non-zero exit status. E: FATAL: Thread initialization failed!

Apache Hadoop

This is a benchmark of the Apache Hadoop making use of its built-in name-node throughput benchmark (NNThroughputBenchmark). Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 50 - Files: 100000abcde16K32K48K64K80KSE +/- 254.81, N = 3SE +/- 178.83, N = 37446274628750757524575930

TiDB Community Server

This is a PingCAP TiDB Community Server benchmark facilitated using the sysbench OLTP database benchmarks. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_read_write - Threads: 1bcde2004006008001000SE +/- 8.35, N = 31140115911511145

Test: oltp_read_write - Threads: 1

a: The test quit with a non-zero exit status. E: FATAL: Thread initialization failed!

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_index - Threads: 32ad2K4K6K8K10K77037822

Test: oltp_update_index - Threads: 32

b: The test quit with a non-zero exit status. E: FATAL: Thread initialization failed!

c: The test quit with a non-zero exit status. E: FATAL: Thread initialization failed!

e: The test quit with a non-zero exit status. E: FATAL: Thread initialization failed!

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_point_select - Threads: 32abce30K60K90K120K150KSE +/- 424.67, N = 2SE +/- 666.16, N = 2160292159440161529159085

Test: oltp_point_select - Threads: 32

d: The test quit with a non-zero exit status. E: FATAL: Thread initialization failed!

Apache Hadoop

This is a benchmark of the Apache Hadoop making use of its built-in name-node throughput benchmark (NNThroughputBenchmark). Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 20 - Files: 1000000abcde9K18K27K36K45KSE +/- 287.29, N = 3SE +/- 35.15, N = 34166641936413604197141808

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 20 - Files: 100000abcde9K18K27K36K45KSE +/- 283.79, N = 3SE +/- 192.52, N = 34174641697413914185941929

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 20 - Files: 100000abcde8K16K24K32K40KSE +/- 18.67, N = 3SE +/- 18.72, N = 33941139469391243903239370

TiDB Community Server

This is a PingCAP TiDB Community Server benchmark facilitated using the sysbench OLTP database benchmarks. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_point_select - Threads: 16ab20K40K60K80K100KSE +/- 547.96, N = 2111533110427

Test: oltp_point_select - Threads: 16

c: The test quit with a non-zero exit status. E: FATAL: Thread initialization failed!

d: The test quit with a non-zero exit status. E: FATAL: Thread initialization failed!

e: The test quit with a non-zero exit status. E: FATAL: Thread initialization failed!

Apache Hadoop

This is a benchmark of the Apache Hadoop making use of its built-in name-node throughput benchmark (NNThroughputBenchmark). Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 100 - Files: 1000000abcde20K40K60K80K100KSE +/- 413.29, N = 3SE +/- 445.15, N = 39201192142915929249891811

TiDB Community Server

This is a PingCAP TiDB Community Server benchmark facilitated using the sysbench OLTP database benchmarks. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_point_select - Threads: 64ace40K80K120K160K200KSE +/- 410.42, N = 3188480189475190107

Test: oltp_point_select - Threads: 64

b: The test quit with a non-zero exit status. E: FATAL: Thread initialization failed!

d: The test quit with a non-zero exit status. E: FATAL: Thread initialization failed!

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_read_write - Threads: 32bcde14K28K42K56K70KSE +/- 87.23, N = 364969652826534865458

Test: oltp_read_write - Threads: 32

a: The test quit with a non-zero exit status. E: FATAL: Thread initialization failed!

Apache Hadoop

This is a benchmark of the Apache Hadoop making use of its built-in name-node throughput benchmark (NNThroughputBenchmark). Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 20 - Files: 1000000abcde9K18K27K36K45KSE +/- 30.63, N = 3SE +/- 87.73, N = 34102540734409404089140880

TiDB Community Server

This is a PingCAP TiDB Community Server benchmark facilitated using the sysbench OLTP database benchmarks. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_non_index - Threads: 32bcd2K4K6K8K10KSE +/- 12.84, N = 2104411042710500

Test: oltp_update_non_index - Threads: 32

a: The test quit with a non-zero exit status. E: FATAL: Thread initialization failed!

e: The test quit with a non-zero exit status. E: FATAL: Thread initialization failed!

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_non_index - Threads: 1ace110220330440550SE +/- 4.87, N = 3522519520

Test: oltp_update_non_index - Threads: 1

b: The test quit with a non-zero exit status. E: FATAL: Thread initialization failed!

d: The test quit with a non-zero exit status. E: FATAL: Thread initialization failed!

Apache Hadoop

This is a benchmark of the Apache Hadoop making use of its built-in name-node throughput benchmark (NNThroughputBenchmark). Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 50 - Files: 1000000abcde20K40K60K80K100KSE +/- 372.45, N = 3SE +/- 305.53, N = 38642486830866638649086783

TiDB Community Server

This is a PingCAP TiDB Community Server benchmark facilitated using the sysbench OLTP database benchmarks. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_index - Threads: 16ae9001800270036004500SE +/- 58.12, N = 242624259

Test: oltp_update_index - Threads: 16

b: The test quit with a non-zero exit status. E: FATAL: Thread initialization failed!

c: The test quit with a non-zero exit status. E: FATAL: Thread initialization failed!

d: The test quit with a non-zero exit status. E: FATAL: Thread initialization failed!

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_index - Threads: 64ab3K6K9K12K15KSE +/- 259.78, N = 21632716318

Test: oltp_update_index - Threads: 64

c: The test quit with a non-zero exit status. E: FATAL: Thread initialization failed!

d: The test quit with a non-zero exit status. E: FATAL: Thread initialization failed!

e: The test quit with a non-zero exit status. E: FATAL: Thread initialization failed!

Apache Hadoop

This is a benchmark of the Apache Hadoop making use of its built-in name-node throughput benchmark (NNThroughputBenchmark). Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 500 - Files: 1000000abcde700K1400K2100K2800K3500KSE +/- 276368.45, N = 12SE +/- 296794.96, N = 1224865882533511275482127397263039514

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 100 - Files: 1000000abcde700K1400K2100K2800K3500KSE +/- 275609.80, N = 15SE +/- 299383.09, N = 152105324176298143592029850753048780

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 500 - Files: 100000abcde200K400K600K800K1000KSE +/- 83989.70, N = 12SE +/- 71090.09, N = 15112555611432569523816578951041667

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 50 - Files: 1000000abcde600K1200K1800K2400K3000KSE +/- 109318.69, N = 12SE +/- 64247.19, N = 1526451552703857238663530120482849003

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 20 - Files: 1000000abcde700K1400K2100K2800K3500KSE +/- 204074.39, N = 12SE +/- 306417.72, N = 1226442872323924261096625380713058104

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 100 - Files: 100000abcde300K600K900K1200K1500KSE +/- 55546.66, N = 14SE +/- 45729.51, N = 121207762115909588495610638301010101

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 50 - Files: 100000abcde300K600K900K1200K1500KSE +/- 74556.07, N = 15SE +/- 41248.73, N = 121072125120922612820518695651010101

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 20 - Files: 100000abcde300K600K900K1200K1500KSE +/- 24982.04, N = 12SE +/- 32189.17, N = 1513125071386155133333313888891315789

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 500 - Files: 100000abcde20K40K60K80K100KSE +/- 1288.40, N = 13SE +/- 1693.04, N = 15102196100078917439514791575

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 100 - Files: 100000abcde30K60K90K120K150KSE +/- 1037.40, N = 11SE +/- 4039.82, N = 12144489141379139470137741147710

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 500 - Files: 1000000abcde400K800K1200K1600K2000KSE +/- 26506.63, N = 13SE +/- 128790.28, N = 1217951841591445185185217006801795332

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 100 - Files: 1000000abcde400K800K1200K1600K2000KSE +/- 169588.88, N = 15SE +/- 150792.28, N = 151432849154414919193864046941869159

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 500 - Files: 100000abcde200K400K600K800K1000KSE +/- 52886.66, N = 14SE +/- 45041.58, N = 15858795898846657895467290862069

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 50 - Files: 1000000abcde400K800K1200K1600K2000KSE +/- 18574.75, N = 15SE +/- 44742.96, N = 1519551261865586192678220325201926782

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 20 - Files: 1000000abcde400K800K1200K1600K2000KSE +/- 133042.41, N = 12SE +/- 136534.50, N = 1518704501783854200000020325201956947

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 100 - Files: 100000abcde200K400K600K800K1000KSE +/- 59310.07, N = 15SE +/- 60725.91, N = 12836613846151840336909091990099

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 50 - Files: 100000abcde200K400K600K800K1000KSE +/- 33116.08, N = 12SE +/- 26460.68, N = 1295335898354910989019433961010101

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 20 - Files: 100000abcde200K400K600K800K1000KSE +/- 23007.20, N = 15SE +/- 14789.71, N = 1210526051059540108695711363641111111

TiDB Community Server

This is a PingCAP TiDB Community Server benchmark facilitated using the sysbench OLTP database benchmarks. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_non_index - Threads: 16abd15003000450060007500SE +/- 156.50, N = 9SE +/- 151.08, N = 5683068416472

Test: oltp_update_non_index - Threads: 16

c: The test quit with a non-zero exit status. E: FATAL: Thread initialization failed!

e: The test quit with a non-zero exit status. E: FATAL: Thread initialization failed!

56 Results Shown

TiDB Community Server
Apache Hadoop:
  Rename - 50 - 100000
  Delete - 100 - 1000000
  Delete - 500 - 100000
  Rename - 100 - 100000
  Create - 500 - 100000
  Delete - 500 - 1000000
  Rename - 500 - 1000000
TiDB Community Server
Apache Hadoop:
  Rename - 100 - 1000000
  Create - 100 - 100000
  Delete - 50 - 100000
  Delete - 20 - 1000000
  Delete - 20 - 100000
  Delete - 50 - 1000000
  Create - 500 - 1000000
  Rename - 50 - 1000000
TiDB Community Server:
  oltp_point_select - 1
  oltp_read_write - 64
  oltp_update_non_index - 64
Apache Hadoop
TiDB Community Server:
  oltp_read_write - 1
  oltp_update_index - 32
  oltp_point_select - 32
Apache Hadoop:
  Rename - 20 - 1000000
  Rename - 20 - 100000
  Create - 20 - 100000
TiDB Community Server
Apache Hadoop
TiDB Community Server:
  oltp_point_select - 64
  oltp_read_write - 32
Apache Hadoop
TiDB Community Server:
  oltp_update_non_index - 32
  oltp_update_non_index - 1
Apache Hadoop
TiDB Community Server:
  oltp_update_index - 16
  oltp_update_index - 64
Apache Hadoop:
  File Status - 500 - 1000000
  File Status - 100 - 1000000
  File Status - 500 - 100000
  File Status - 50 - 1000000
  File Status - 20 - 1000000
  File Status - 100 - 100000
  File Status - 50 - 100000
  File Status - 20 - 100000
  Rename - 500 - 100000
  Delete - 100 - 100000
  Open - 500 - 1000000
  Open - 100 - 1000000
  Open - 500 - 100000
  Open - 50 - 1000000
  Open - 20 - 1000000
  Open - 100 - 100000
  Open - 50 - 100000
  Open - 20 - 100000
TiDB Community Server

a

Kernel Notes: Transparent Huge Pages: madvise
Processor Notes: Scaling Governor: intel_pstate powersave (EPP: balance_performance) - CPU Microcode: 0x119 - Thermald 2.4.9
Java Notes: OpenJDK Runtime Environment (build 11.0.20.1+1-post-Ubuntu-0ubuntu122.04)
Security Notes: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced / Automatic IBRS IBPB: conditional RSB filling PBRSB-eIBRS: SW sequence + srbds: Not affected + tsx_async_abort: Not affected

Testing initiated at 7 September 2023 19:14 by user pts.

b

Kernel Notes: Transparent Huge Pages: madvise
Processor Notes: Scaling Governor: intel_pstate powersave (EPP: balance_performance) - CPU Microcode: 0x119 - Thermald 2.4.9
Java Notes: OpenJDK Runtime Environment (build 11.0.20.1+1-post-Ubuntu-0ubuntu122.04)
Security Notes: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced / Automatic IBRS IBPB: conditional RSB filling PBRSB-eIBRS: SW sequence + srbds: Not affected + tsx_async_abort: Not affected

Testing initiated at 8 September 2023 07:05 by user pts.

c

Kernel Notes: Transparent Huge Pages: madvise
Processor Notes: Scaling Governor: intel_pstate powersave (EPP: balance_performance) - CPU Microcode: 0x119 - Thermald 2.4.9
Java Notes: OpenJDK Runtime Environment (build 11.0.20.1+1-post-Ubuntu-0ubuntu122.04)
Security Notes: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced / Automatic IBRS IBPB: conditional RSB filling PBRSB-eIBRS: SW sequence + srbds: Not affected + tsx_async_abort: Not affected

Testing initiated at 8 September 2023 17:36 by user pts.

d

Kernel Notes: Transparent Huge Pages: madvise
Processor Notes: Scaling Governor: intel_pstate powersave (EPP: balance_performance) - CPU Microcode: 0x119 - Thermald 2.4.9
Java Notes: OpenJDK Runtime Environment (build 11.0.20.1+1-post-Ubuntu-0ubuntu122.04)
Security Notes: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced / Automatic IBRS IBPB: conditional RSB filling PBRSB-eIBRS: SW sequence + srbds: Not affected + tsx_async_abort: Not affected

Testing initiated at 8 September 2023 20:28 by user pts.

e

Processor: Intel Core i9-13900K @ 5.50GHz (24 Cores / 32 Threads), Motherboard: ASUS PRIME Z790-P WIFI (0812 BIOS), Chipset: Intel Device 7a27, Memory: 32GB, Disk: 1000GB Western Digital WDS100T1X0E-00AFY0, Graphics: AMD Radeon RX 7700S/7600S/7600M XT 8GB (1940/1124MHz), Audio: Realtek ALC897, Monitor: ASUS VP28U

OS: Ubuntu 22.04, Kernel: 6.4.6-060406-generic (x86_64), Desktop: GNOME Shell 42.9, Display Server: X Server 1.21.1.4 + Wayland, OpenGL: 4.6 Mesa 23.3~git2308070600.777734~oibaf~j (git-7777349 2023-08-07 jammy-oibaf-ppa) (LLVM 15.0.7 DRM 3.52), OpenCL: OpenCL 1.1 Mesa 23.3~git2308020600.4de7e0~oibaf~j (git-4de7e00 2023-08-02 jammy-oibaf-ppa) + OpenCL 3.0, Vulkan: 1.3.258, Compiler: GCC 11.4.0 + Clang 16.0.6 + LLVM 16.0.6, File-System: ext4, Screen Resolution: 3840x2160

Kernel Notes: Transparent Huge Pages: madvise
Processor Notes: Scaling Governor: intel_pstate powersave (EPP: balance_performance) - CPU Microcode: 0x119 - Thermald 2.4.9
Java Notes: OpenJDK Runtime Environment (build 11.0.20.1+1-post-Ubuntu-0ubuntu122.04)
Security Notes: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced / Automatic IBRS IBPB: conditional RSB filling PBRSB-eIBRS: SW sequence + srbds: Not affected + tsx_async_abort: Not affected

Testing initiated at 9 September 2023 08:32 by user pts.