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 - 100000hadoop: Open - 100 - 100000hadoop: Open - 20 - 1000000hadoop: Open - 50 - 1000000hadoop: Open - 500 - 100000hadoop: Create - 20 - 100000hadoop: Create - 50 - 100000hadoop: 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 - 1000000hadoop: File Status - 50 - 1000000hadoop: File Status - 500 - 100000hadoop: File Status - 100 - 1000000hadoop: File Status - 500 - 1000000tidb: oltp_read_write - 1tidb: oltp_read_write - 16tidb: oltp_read_write - 32tidb: oltp_read_write - 64tidb: oltp_point_select - 1tidb: oltp_update_index - 1tidb: oltp_point_select - 16tidb: oltp_point_select - 32tidb: oltp_point_select - 64tidb: oltp_update_index - 16tidb: oltp_update_index - 32tidb: oltp_update_index - 64tidb: oltp_update_non_index - 1tidb: oltp_update_non_index - 16tidb: oltp_update_non_index - 32tidb: oltp_update_non_index - 64abcde10526059533588366131870450195512685879539411744624578395397143284917951844174688737791544102586424719661444894664010142013782610366941666901351021969201184721156020147969106915105297131250710721251207762264428726451551125556210532424865884163778819269341511153316029218848042627703163275226830209271059540983549846151178385418655868988463946974628459719699415441491591445416978994179304407348683069817141379453789856913546110740141936900201000789214284647160931148242107389100460138615512092261159095232392427038571143256176298125335111140649697827426663971104271594401631868411044121405108695710989018403362000000192678265789539124750754597798814191938618518524139179745818334094086663746831394704628898290135870992064136088324917439159284196142674140174108613103220133333312820518849562610966238663595238143592027548211159359296528280122264339816152918947551910427113636494339690909120325202032520467290390327524546019993054046941700680418598833982508408918649069881137741466901011221250001062704197190220951479249885499145773147341111757104635138888986956510638302538071301204865789529850752739726115165348791412636399782264721050021401111111110101019900991956947192678286206939370759304458397087186915917953324192991324797454088086783729931477104684510079613175210000041808906549157591811867001529991439881102781003611315789101010110101013058104284900310416673048780303951411453651565458786842700159085190107425952021278OpenBenchmarking.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: 100000abced200K400K600K800K1000KSE +/- 23007.20, N = 15SE +/- 14789.71, N = 1210526051059540108695711111111136364
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 20 - Files: 100000abced200K400K600K800K1000KMin: 892857.14 / Avg: 1052605.47 / Max: 1162790.7Min: 970873.79 / Avg: 1059540.42 / Max: 1149425.29

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

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 100 - Files: 100000acbde200K400K600K800K1000KSE +/- 59310.07, N = 15SE +/- 60725.91, N = 12836613840336846151909091990099
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 100 - Files: 100000acbde200K400K600K800K1000KMin: 471698.11 / Avg: 836612.95 / Max: 1250000Min: 448430.49 / Avg: 846150.51 / Max: 1219512.2

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 20 - Files: 1000000baecd400K800K1200K1600K2000KSE +/- 136534.50, N = 15SE +/- 133042.41, N = 1217838541870450195694720000002032520
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 20 - Files: 1000000baecd400K800K1200K1600K2000KMin: 496770.99 / Avg: 1783853.98 / Max: 2164502.16Min: 537056.93 / Avg: 1870449.99 / Max: 2212389.38

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 50 - Files: 1000000bcead400K800K1200K1600K2000KSE +/- 44742.96, N = 15SE +/- 18574.75, N = 1518655861926782192678219551262032520
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 50 - Files: 1000000bcead400K800K1200K1600K2000KMin: 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: 100000dcaeb200K400K600K800K1000KSE +/- 52886.66, N = 14SE +/- 45041.58, N = 15467290657895858795862069898846
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 500 - Files: 100000dcaeb160K320K480K640K800KMin: 333333.33 / Avg: 858794.56 / Max: 1190476.19Min: 490196.08 / Avg: 898846.35 / Max: 1265822.78

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

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

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 20 - Files: 100000eabcd10K20K30K40K50KSE +/- 224.98, N = 3SE +/- 141.32, N = 34458345783459714597746019
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 20 - Files: 100000eabcd8K16K24K32K40KMin: 45537.34 / Avg: 45782.76 / Max: 46232.09Min: 45829.51 / Avg: 45970.83 / Max: 46253.47

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

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

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 500 - Files: 1000000bdaec400K800K1200K1600K2000KSE +/- 128790.28, N = 12SE +/- 26506.63, N = 1315914451700680179518417953321851852
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 500 - Files: 1000000bdaec300K600K900K1200K1500KMin: 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: 100000cbade9K18K27K36K45KSE +/- 192.52, N = 3SE +/- 283.79, N = 34139141697417464185941929
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 20 - Files: 100000cbade7K14K21K28K35KMin: 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: 100000cdabe20K40K60K80K100KSE +/- 489.92, N = 3SE +/- 756.16, N = 37974588339887378994191324
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 50 - Files: 100000cdabe16K32K48K64K80KMin: 87796.31 / Avg: 88736.57 / Max: 89445.44Min: 88888.89 / Avg: 89940.69 / Max: 91407.68

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

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 20 - Files: 1000000bedca9K18K27K36K45KSE +/- 87.73, N = 3SE +/- 30.63, N = 34073440880408914094041025
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 20 - Files: 1000000bedca7K14K21K28K35KMin: 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: 1000000adceb20K40K60K80K100KSE +/- 372.45, N = 3SE +/- 305.53, N = 38642486490866638678386830
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 50 - Files: 1000000adceb15K30K45K60K75KMin: 85682.46 / Avg: 86423.69 / Max: 86858.33Min: 86236.63 / Avg: 86830.32 / Max: 87252.42

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 500 - Files: 100000bdaec16K32K48K64K80KSE +/- 113.81, N = 3SE +/- 918.61, N = 36981769881719667299374683
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 500 - Files: 100000bdaec13K26K39K52K65KMin: 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: 100000dcbae30K60K90K120K150KSE +/- 4039.82, N = 12SE +/- 1037.40, N = 11137741139470141379144489147710
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 100 - Files: 100000dcbae30K60K90K120K150KMin: 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: 1000000bcade10K20K30K40K50KSE +/- 122.94, N = 3SE +/- 153.67, N = 34537846288466404669046845
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 20 - Files: 1000000bcade8K16K24K32K40KMin: 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: 1000000cbeda20K40K60K80K100KSE +/- 1235.91, N = 3SE +/- 115.94, N = 39829098569100796101122101420
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 50 - Files: 1000000cbeda20K40K60K80K100KMin: 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: 100000debca30K60K90K120K150KSE +/- 1197.30, N = 3SE +/- 1218.17, N = 3125000131752135461135870137826
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 500 - Files: 100000debca20K40K60K80K100KMin: 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: 100000ceadb20K40K60K80K100KSE +/- 1485.49, N = 3SE +/- 1239.01, N = 399206100000103669106270107401
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 100 - Files: 100000ceadb20K40K60K80K100KMin: 101832.99 / Avg: 103668.97 / Max: 106609.81Min: 105374.08 / Avg: 107401.45 / Max: 109649.12

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

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 50 - Files: 1000000cbade20K40K60K80K100KSE +/- 498.27, N = 3SE +/- 452.79, N = 38832490020901359022090654
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 50 - Files: 1000000cbade16K32K48K64K80KMin: 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: 100000ecdba20K40K60K80K100KSE +/- 1693.04, N = 15SE +/- 1288.40, N = 13915759174395147100078102196
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 500 - Files: 100000ecdba20K40K60K80K100KMin: 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: 1000000ceabd20K40K60K80K100KSE +/- 413.29, N = 3SE +/- 445.15, N = 39159291811920119214292498
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 100 - Files: 1000000ceabd16K32K48K64K80KMin: 91524.8 / Avg: 92011.3 / Max: 92833.27Min: 91282.52 / Avg: 92141.91 / Max: 92772.98

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 500 - Files: 1000000cbade20K40K60K80K100KSE +/- 510.57, N = 3SE +/- 655.90, N = 138419684647847218549986700
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 500 - Files: 1000000cbade15K30K45K60K75KMin: 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: 1000000cdeab30K60K90K120K150KSE +/- 1735.70, N = 5SE +/- 1016.01, N = 3142674145773152999156020160931
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 100 - Files: 1000000cdeab30K60K90K120K150KMin: 152068.13 / Avg: 156019.59 / Max: 161342.37Min: 159286.4 / Avg: 160931.11 / Max: 162786.91

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

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

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 500 - Files: 1000000ebcda20K40K60K80K100KSE +/- 649.94, N = 3SE +/- 788.38, N = 11100361100460103220104635105297
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 500 - Files: 1000000ebcda20K40K60K80K100KMin: 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: 100000aecbd300K600K900K1200K1500KSE +/- 24982.04, N = 12SE +/- 32189.17, N = 1513125071315789133333313861551388889
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 20 - Files: 100000aecbd200K400K600K800K1000KMin: 1149425.29 / Avg: 1312506.75 / Max: 1449275.36Min: 1149425.29 / Avg: 1386154.76 / Max: 1724137.93

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

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 100 - Files: 100000cedba300K600K900K1200K1500KSE +/- 45729.51, N = 12SE +/- 55546.66, N = 148849561010101106383011590951207762
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 100 - Files: 100000cedba200K400K600K800K1000KMin: 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: 1000000bdcae700K1400K2100K2800K3500KSE +/- 306417.72, N = 12SE +/- 204074.39, N = 1223239242538071261096626442873058104
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 20 - Files: 1000000bdcae500K1000K1500K2000K2500KMin: 471031.56 / Avg: 2323923.61 / Max: 3095975.23Min: 478011.47 / Avg: 2644286.92 / Max: 3174603.17

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 50 - Files: 1000000cabed600K1200K1800K2400K3000KSE +/- 109318.69, N = 12SE +/- 64247.19, N = 1523866352645155270385728490033012048
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 50 - Files: 1000000cabed500K1000K1500K2000K2500KMin: 1912045.89 / Avg: 2645154.7 / Max: 3257328.99Min: 2293577.98 / Avg: 2703857.46 / Max: 3311258.28

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

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 100 - Files: 1000000cbade700K1400K2100K2800K3500KSE +/- 299383.09, N = 15SE +/- 275609.80, N = 154359201762981210532429850753048780
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 100 - Files: 1000000cbade500K1000K1500K2000K2500KMin: 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: 1000000abdce700K1400K2100K2800K3500KSE +/- 276368.45, N = 12SE +/- 296794.96, N = 1224865882533511273972627548213039514
OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 500 - Files: 1000000abdce500K1000K1500K2000K2500KMin: 331235.51 / Avg: 2486588.49 / Max: 3460207.61Min: 332225.91 / Avg: 2533510.77 / Max: 3311258.28

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: 1bedc2004006008001000SE +/- 8.35, N = 31140114511511159
OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_read_write - Threads: 1bedc2004006008001000Min: 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!

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_read_write - Threads: 16cea9K18K27K36K45KSE +/- 172.53, N = 3359293651541637
OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_read_write - Threads: 16cea7K14K21K28K35KMin: 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!

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_read_write - Threads: 32bcde14K28K42K56K70KSE +/- 87.23, N = 364969652826534865458
OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_read_write - Threads: 32bcde11K22K33K44K55KMin: 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_read_write - Threads: 64beadc20K40K60K80K100KSE +/- 133.87, N = 3SE +/- 255.80, N = 27827478684788197914180122
OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_read_write - Threads: 64beadc14K28K42K56K70KMin: 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_point_select - Threads: 1dcbae6001200180024003000SE +/- 8.07, N = 3SE +/- 4.28, N = 226362643266626932700
OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_point_select - Threads: 1dcbae5001000150020002500Min: 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_update_index - Threads: 1bcda90180270360450SE +/- 0.09, N = 2SE +/- 5.96, N = 4397398399415
OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_index - Threads: 1bcda70140210280350Min: 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: 32ebac30K60K90K120K150KSE +/- 666.16, N = 2SE +/- 424.67, N = 2159085159440160292161529
OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_point_select - Threads: 32ebac30K60K90K120K150KMin: 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: 64ace40K80K120K160K200KSE +/- 410.42, N = 3188480189475190107
OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_point_select - Threads: 64ace30K60K90K120K150KMin: 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: 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!

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_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!

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_non_index - Threads: 1cea110220330440550SE +/- 4.87, N = 3519520522
OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_non_index - Threads: 1cea90180270360450Min: 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_non_index - Threads: 16dab15003000450060007500SE +/- 156.50, N = 9SE +/- 151.08, N = 5647268306841
OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_non_index - Threads: 16dab12002400360048006000Min: 6431.25 / Avg: 6829.69 / Max: 7728.75Min: 6406.3 / Avg: 6841.38 / Max: 7183.62

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!

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_non_index - Threads: 32cbd2K4K6K8K10KSE +/- 12.84, N = 2104271044110500
OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_non_index - Threads: 32cbd2K4K6K8K10KMin: 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!

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_non_index - Threads: 64aedb5K10K15K20K25KSE +/- 110.67, N = 320927212782140121405
OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_non_index - Threads: 64aedb4K8K12K16K20KMin: 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!