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

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):


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

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

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: Open - Threads: 20 - Files: 100000edcba200K400K600K800K1000KSE +/- 14789.71, N = 12SE +/- 23007.20, N = 1511111111136364108695710595401052605
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 20 - Files: 100000edcba200K400K600K800K1000KMin: 970873.79 / Avg: 1059540.42 / Max: 1149425.29Min: 892857.14 / Avg: 1052605.47 / Max: 1162790.7

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 50 - Files: 100000edcba200K400K600K800K1000KSE +/- 26460.68, N = 12SE +/- 33116.08, N = 1210101019433961098901983549953358
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 50 - Files: 100000edcba200K400K600K800K1000KMin: 833333.33 / Avg: 983549.23 / Max: 1136363.64Min: 709219.86 / Avg: 953357.54 / Max: 1136363.64

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: 32da2K4K6K8K10K78227703

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: 32ecba30K60K90K120K150KSE +/- 666.16, N = 2SE +/- 424.67, N = 2159085161529159440160292
OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_point_select - Threads: 32ecba30K60K90K120K150KMin: 158773.89 / Avg: 159440.06 / Max: 160106.22Min: 159867.46 / Avg: 160292.13 / Max: 160716.79

Test: oltp_point_select - Threads: 32

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_point_select - Threads: 64eca40K80K120K160K200KSE +/- 410.42, N = 3190107189475188480
OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_point_select - Threads: 64eca30K60K90K120K150KMin: 187770.27 / Avg: 188479.95 / Max: 189191.99

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_update_index - Threads: 1dcba90180270360450SE +/- 0.09, N = 2SE +/- 5.96, N = 4399398397415
OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_index - Threads: 1dcba70140210280350Min: 396.98 / Avg: 397.08 / Max: 397.17Min: 406.74 / Avg: 414.65 / Max: 432.37

Test: oltp_update_index - Threads: 1

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: 16ba20K40K60K80K100KSE +/- 547.96, N = 2110427111533
OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_point_select - Threads: 16ba20K40K60K80K100KMin: 109878.64 / Avg: 110426.6 / Max: 110974.55

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!

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_point_select - Threads: 1edcba6001200180024003000SE +/- 8.07, N = 3SE +/- 4.28, N = 227002636264326662693
OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_point_select - Threads: 1edcba5001000150020002500Min: 2649.5 / Avg: 2665.64 / Max: 2673.72Min: 2688.85 / Avg: 2693.13 / Max: 2697.41

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_read_write - Threads: 64edcba20K40K60K80K100KSE +/- 133.87, N = 3SE +/- 255.80, N = 27868479141801227827478819
OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_read_write - Threads: 64edcba14K28K42K56K70KMin: 78132.86 / Avg: 78273.93 / Max: 78541.54Min: 78562.88 / Avg: 78818.68 / Max: 79074.48

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_read_write - Threads: 32edcb14K28K42K56K70KSE +/- 87.23, N = 365458653486528264969
OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_read_write - Threads: 32edcb11K22K33K44K55KMin: 64797.2 / Avg: 64969.5 / Max: 65079.38

Test: oltp_read_write - Threads: 32

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_non_index - Threads: 1eca110220330440550SE +/- 4.87, N = 3520519522
OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_non_index - Threads: 1eca90180270360450Min: 512.84 / Avg: 521.54 / Max: 529.67

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!

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_index - Threads: 16ea9001800270036004500SE +/- 58.12, N = 242594262
OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_index - Threads: 16ea7001400210028003500Min: 4203.76 / Avg: 4261.88 / Max: 4320

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!

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: Open - Threads: 100 - Files: 100000edcba200K400K600K800K1000KSE +/- 60725.91, N = 12SE +/- 59310.07, N = 15990099909091840336846151836613
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 100 - Files: 100000edcba200K400K600K800K1000KMin: 448430.49 / Avg: 846150.51 / Max: 1219512.2Min: 471698.11 / Avg: 836612.95 / Max: 1250000

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: 64ba3K6K9K12K15KSE +/- 259.78, N = 21631816327
OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_index - Threads: 64ba3K6K9K12K15KMin: 16058.08 / Avg: 16317.86 / Max: 16577.64

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: Open - Threads: 20 - Files: 1000000edcba400K800K1200K1600K2000KSE +/- 136534.50, N = 15SE +/- 133042.41, N = 1219569472032520200000017838541870450
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 20 - Files: 1000000edcba400K800K1200K1600K2000KMin: 496770.99 / Avg: 1783853.98 / Max: 2164502.16Min: 537056.93 / Avg: 1870449.99 / Max: 2212389.38

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: 64edba5K10K15K20K25KSE +/- 110.67, N = 321278214012140520927
OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_non_index - Threads: 64edba4K8K12K16K20KMin: 21204.81 / Avg: 21405.49 / Max: 21586.7

Test: oltp_update_non_index - Threads: 64

c: 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: 32dcb2K4K6K8K10KSE +/- 12.84, N = 2105001042710441
OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_non_index - Threads: 32dcb2K4K6K8K10KMin: 10428.42 / Avg: 10441.26 / Max: 10454.1

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!

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: Open - Threads: 50 - Files: 1000000edcba400K800K1200K1600K2000KSE +/- 44742.96, N = 15SE +/- 18574.75, N = 1519267822032520192678218655861955126
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 50 - Files: 1000000edcba400K800K1200K1600K2000KMin: 1451378.81 / Avg: 1865586.22 / Max: 2040816.33Min: 1795332.14 / Avg: 1955126.33 / Max: 2083333.33

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 500 - Files: 100000edcba200K400K600K800K1000KSE +/- 45041.58, N = 15SE +/- 52886.66, N = 14862069467290657895898846858795
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 500 - Files: 100000edcba160K320K480K640K800KMin: 490196.08 / Avg: 898846.35 / Max: 1265822.78Min: 333333.33 / Avg: 858794.56 / Max: 1190476.19

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 20 - Files: 100000edcba8K16K24K32K40KSE +/- 18.72, N = 3SE +/- 18.67, N = 33937039032391243946939411
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 20 - Files: 100000edcba7K14K21K28K35KMin: 39432.18 / Avg: 39468.51 / Max: 39494.47Min: 39385.58 / Avg: 39411.47 / Max: 39447.73

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 50 - Files: 100000edcba16K32K48K64K80KSE +/- 178.83, N = 3SE +/- 254.81, N = 37593075245750757462874462
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 50 - Files: 100000edcba13K26K39K52K65KMin: 74294.21 / Avg: 74627.72 / Max: 74906.37Min: 74128.98 / Avg: 74461.9 / Max: 74962.52

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: 16dba15003000450060007500SE +/- 151.08, N = 5SE +/- 156.50, N = 9647268416830
OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_non_index - Threads: 16dba12002400360048006000Min: 6406.3 / Avg: 6841.38 / Max: 7183.62Min: 6431.25 / Avg: 6829.69 / Max: 7728.75

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!

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: Delete - Threads: 20 - Files: 100000edcba10K20K30K40K50KSE +/- 141.32, N = 3SE +/- 224.98, N = 34458346019459774597145783
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 20 - Files: 100000edcba8K16K24K32K40KMin: 45829.51 / Avg: 45970.83 / Max: 46253.47Min: 45537.34 / Avg: 45782.76 / Max: 46232.09

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 50 - Files: 100000edcba20K40K60K80K100KSE +/- 196.10, N = 3SE +/- 1343.10, N = 39708799305988149699495397
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 50 - Files: 100000edcba20K40K60K80K100KMin: 96711.8 / Avg: 96994 / Max: 97370.98Min: 92936.8 / Avg: 95397.19 / Max: 97560.98

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 100 - Files: 1000000edcba400K800K1200K1600K2000KSE +/- 150792.28, N = 15SE +/- 169588.88, N = 151869159404694191938615441491432849
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 100 - Files: 1000000edcba300K600K900K1200K1500KMin: 398089.17 / Avg: 1544148.67 / Max: 1964636.54Min: 397140.59 / Avg: 1432849.18 / Max: 1996007.98

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 500 - Files: 1000000edcba400K800K1200K1600K2000KSE +/- 128790.28, N = 12SE +/- 26506.63, N = 1317953321700680185185215914451795184
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 500 - Files: 1000000edcba300K600K900K1200K1500KMin: 327011.12 / Avg: 1591444.89 / Max: 1945525.29Min: 1680672.27 / Avg: 1795184.1 / Max: 1996007.98

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 20 - Files: 100000edcba9K18K27K36K45KSE +/- 192.52, N = 3SE +/- 283.79, N = 34192941859413914169741746
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 20 - Files: 100000edcba7K14K21K28K35KMin: 41339.4 / Avg: 41697.4 / Max: 41999.16Min: 41288.19 / Avg: 41745.88 / Max: 42265.43

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 50 - Files: 100000edcba20K40K60K80K100KSE +/- 756.16, N = 3SE +/- 489.92, N = 39132488339797458994188737
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 50 - Files: 100000edcba16K32K48K64K80KMin: 88888.89 / Avg: 89940.69 / Max: 91407.68Min: 87796.31 / Avg: 88736.57 / Max: 89445.44

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 100 - Files: 100000edcba20K40K60K80K100KSE +/- 960.46, N = 3SE +/- 878.95, N = 37974582508818337930479154
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 100 - Files: 100000edcba14K28K42K56K70KMin: 77821.01 / Avg: 79304.32 / Max: 81103Min: 77881.62 / Avg: 79154.17 / Max: 80840.74

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 20 - Files: 1000000edcba9K18K27K36K45KSE +/- 87.73, N = 3SE +/- 30.63, N = 34088040891409404073441025
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 20 - Files: 1000000edcba7K14K21K28K35KMin: 40559.72 / Avg: 40734.13 / Max: 40838Min: 40992.01 / Avg: 41025.13 / Max: 41086.32

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 50 - Files: 1000000edcba20K40K60K80K100KSE +/- 305.53, N = 3SE +/- 372.45, N = 38678386490866638683086424
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 50 - Files: 1000000edcba15K30K45K60K75KMin: 86236.63 / Avg: 86830.32 / Max: 87252.42Min: 85682.46 / Avg: 86423.69 / Max: 86858.33

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 500 - Files: 100000edcba16K32K48K64K80KSE +/- 113.81, N = 3SE +/- 918.61, N = 37299369881746836981771966
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 500 - Files: 100000edcba13K26K39K52K65KMin: 69637.88 / Avg: 69816.52 / Max: 70028.01Min: 70972.32 / Avg: 71965.6 / Max: 73800.74

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 100 - Files: 100000edcba30K60K90K120K150KSE +/- 4039.82, N = 12SE +/- 1037.40, N = 11147710137741139470141379144489
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 100 - Files: 100000edcba30K60K90K120K150KMin: 98814.23 / Avg: 141379.26 / Max: 151515.15Min: 138504.16 / Avg: 144489.31 / Max: 148367.95

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 20 - Files: 1000000edcba10K20K30K40K50KSE +/- 122.94, N = 3SE +/- 153.67, N = 34684546690462884537846640
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 20 - Files: 1000000edcba8K16K24K32K40KMin: 45132.46 / Avg: 45378.21 / Max: 45508.33Min: 46334.91 / Avg: 46639.91 / Max: 46825.25

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 50 - Files: 1000000edcba20K40K60K80K100KSE +/- 1235.91, N = 3SE +/- 115.94, N = 31007961011229829098569101420
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 50 - Files: 1000000edcba20K40K60K80K100KMin: 96889.84 / Avg: 98569.04 / Max: 100979.5Min: 101224.82 / Avg: 101420.14 / Max: 101626.02

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 500 - Files: 100000edcba30K60K90K120K150KSE +/- 1197.30, N = 3SE +/- 1218.17, N = 3131752125000135870135461137826
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 500 - Files: 100000edcba20K40K60K80K100KMin: 133155.79 / Avg: 135461.48 / Max: 137174.21Min: 136425.65 / Avg: 137825.67 / Max: 140252.45

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 100 - Files: 100000edcba20K40K60K80K100KSE +/- 1239.01, N = 3SE +/- 1485.49, N = 310000010627099206107401103669
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 100 - Files: 100000edcba20K40K60K80K100KMin: 105374.08 / Avg: 107401.45 / Max: 109649.12Min: 101832.99 / Avg: 103668.97 / Max: 106609.81

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 20 - Files: 1000000edcba9K18K27K36K45KSE +/- 35.15, N = 3SE +/- 287.29, N = 34180841971413604193641666
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 20 - Files: 1000000edcba7K14K21K28K35KMin: 41888.33 / Avg: 41935.81 / Max: 42004.45Min: 41106.59 / Avg: 41666.02 / Max: 42059.22

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 50 - Files: 1000000edcba20K40K60K80K100KSE +/- 498.27, N = 3SE +/- 452.79, N = 39065490220883249002090135
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 50 - Files: 1000000edcba16K32K48K64K80KMin: 89023.41 / Avg: 90019.95 / Max: 90522.31Min: 89245.87 / Avg: 90135.26 / Max: 90727.64

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 500 - Files: 100000edcba20K40K60K80K100KSE +/- 1693.04, N = 15SE +/- 1288.40, N = 13915759514791743100078102196
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 500 - Files: 100000edcba20K40K60K80K100KMin: 87032.2 / Avg: 100078.29 / Max: 110741.97Min: 90826.52 / Avg: 102195.88 / Max: 109649.12

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 100 - Files: 1000000edcba20K40K60K80K100KSE +/- 445.15, N = 3SE +/- 413.29, N = 39181192498915929214292011
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 100 - Files: 1000000edcba16K32K48K64K80KMin: 91282.52 / Avg: 92141.91 / Max: 92772.98Min: 91524.8 / Avg: 92011.3 / Max: 92833.27

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 500 - Files: 1000000edcba20K40K60K80K100KSE +/- 510.57, N = 3SE +/- 655.90, N = 138670085499841968464784721
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 500 - Files: 1000000edcba15K30K45K60K75KMin: 83682.01 / Avg: 84646.74 / Max: 85418.98Min: 77273.78 / Avg: 84720.79 / Max: 86820.63

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 100 - Files: 1000000edcba30K60K90K120K150KSE +/- 1016.01, N = 3SE +/- 1735.70, N = 5152999145773142674160931156020
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 100 - Files: 1000000edcba30K60K90K120K150KMin: 159286.4 / Avg: 160931.11 / Max: 162786.91Min: 152068.13 / Avg: 156019.59 / Max: 161342.37

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 500 - Files: 1000000edcba30K60K90K120K150KSE +/- 1795.54, N = 3SE +/- 1877.02, N = 3143988147341140174148242147969
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 500 - Files: 1000000edcba30K60K90K120K150KMin: 146134.74 / Avg: 148242.38 / Max: 151814.18Min: 146028.04 / Avg: 147968.73 / Max: 151722.05

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 100 - Files: 1000000edcba20K40K60K80K100KSE +/- 722.51, N = 15SE +/- 889.38, N = 15110278111757108613107389106915
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 100 - Files: 1000000edcba20K40K60K80K100KMin: 100836.95 / Avg: 107388.97 / Max: 110424.03Min: 99760.57 / Avg: 106915.2 / Max: 112007.17

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 500 - Files: 1000000edcba20K40K60K80K100KSE +/- 649.94, N = 3SE +/- 788.38, N = 11100361104635103220100460105297
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 500 - Files: 1000000edcba20K40K60K80K100KMin: 99621.44 / Avg: 100460.4 / Max: 101739.75Min: 101999.18 / Avg: 105297.09 / Max: 109962.61

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 20 - Files: 100000edcba300K600K900K1200K1500KSE +/- 32189.17, N = 15SE +/- 24982.04, N = 1213157891388889133333313861551312507
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 20 - Files: 100000edcba200K400K600K800K1000KMin: 1149425.29 / Avg: 1386154.76 / Max: 1724137.93Min: 1149425.29 / Avg: 1312506.75 / Max: 1449275.36

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 50 - Files: 100000edcba300K600K900K1200K1500KSE +/- 41248.73, N = 12SE +/- 74556.07, N = 151010101869565128205112092261072125
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 50 - Files: 100000edcba200K400K600K800K1000KMin: 877192.98 / Avg: 1209226.29 / Max: 1428571.43Min: 480769.23 / Avg: 1072124.77 / Max: 1333333.33

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 100 - Files: 100000edcba300K600K900K1200K1500KSE +/- 45729.51, N = 12SE +/- 55546.66, N = 141010101106383088495611590951207762
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 100 - Files: 100000edcba200K400K600K800K1000KMin: 892857.14 / Avg: 1159094.96 / Max: 1388888.89Min: 595238.1 / Avg: 1207762.03 / Max: 1388888.89

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 20 - Files: 1000000edcba700K1400K2100K2800K3500KSE +/- 306417.72, N = 12SE +/- 204074.39, N = 1230581042538071261096623239242644287
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 20 - Files: 1000000edcba500K1000K1500K2000K2500KMin: 471031.56 / Avg: 2323923.61 / Max: 3095975.23Min: 478011.47 / Avg: 2644286.92 / Max: 3174603.17

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: 16eca9K18K27K36K45KSE +/- 172.53, N = 3365153592941637
OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_read_write - Threads: 16eca7K14K21K28K35KMin: 41305.11 / Avg: 41636.98 / Max: 41884.77

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: File Status - Threads: 50 - Files: 1000000edcba600K1200K1800K2400K3000KSE +/- 64247.19, N = 15SE +/- 109318.69, N = 1228490033012048238663527038572645155
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 50 - Files: 1000000edcba500K1000K1500K2000K2500KMin: 2293577.98 / Avg: 2703857.46 / Max: 3311258.28Min: 1912045.89 / Avg: 2645154.7 / Max: 3257328.99

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 500 - Files: 100000edcba200K400K600K800K1000KSE +/- 71090.09, N = 15SE +/- 83989.70, N = 12104166765789595238111432561125556
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 500 - Files: 100000edcba200K400K600K800K1000KMin: 684931.51 / Avg: 1143256.02 / Max: 1612903.23Min: 729927.01 / Avg: 1125556.27 / Max: 1587301.59

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 100 - Files: 1000000edcba700K1400K2100K2800K3500KSE +/- 299383.09, N = 15SE +/- 275609.80, N = 153048780298507543592017629812105324
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 100 - Files: 1000000edcba500K1000K1500K2000K2500KMin: 404203.72 / Avg: 1762980.85 / Max: 3236245.95Min: 426985.48 / Avg: 2105324.44 / Max: 3067484.66

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 500 - Files: 1000000edcba700K1400K2100K2800K3500KSE +/- 296794.96, N = 12SE +/- 276368.45, N = 1230395142739726275482125335112486588
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 500 - Files: 1000000edcba500K1000K1500K2000K2500KMin: 332225.91 / Avg: 2533510.77 / Max: 3311258.28Min: 331235.51 / Avg: 2486588.49 / Max: 3460207.61

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: 1edcb2004006008001000SE +/- 8.35, N = 31145115111591140
OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_read_write - Threads: 1edcb2004006008001000Min: 1126.97 / Avg: 1140.22 / Max: 1155.66

Test: oltp_read_write - Threads: 1

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

56 Results Shown

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