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.

HTML result view exported from: https://openbenchmarking.org/result/2309098-PTS-DDD9785724&grw&sor.

dddProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorOSKernelDesktopDisplay ServerOpenGLOpenCLVulkanCompilerFile-SystemScreen ResolutionabcdeIntel 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.6ext43840x2160OpenBenchmarking.orgKernel Details- Transparent Huge Pages: madviseProcessor Details- Scaling Governor: intel_pstate powersave (EPP: balance_performance) - CPU Microcode: 0x119 - Thermald 2.4.9Java Details- OpenJDK Runtime Environment (build 11.0.20.1+1-post-Ubuntu-0ubuntu122.04)Security Details- 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

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

Operation: Open - Threads: 20 - Files: 100000

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

Apache Hadoop

Operation: Open - Threads: 50 - Files: 100000

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

TiDB Community Server

Test: oltp_update_index - Threads: 32

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

TiDB Community Server

Test: oltp_point_select - Threads: 32

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

TiDB Community Server

Test: oltp_point_select - Threads: 64

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

TiDB Community Server

Test: oltp_update_index - Threads: 1

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

TiDB Community Server

Test: oltp_point_select - Threads: 16

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

TiDB Community Server

Test: oltp_point_select - Threads: 1

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

TiDB Community Server

Test: oltp_read_write - Threads: 64

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

TiDB Community Server

Test: oltp_read_write - Threads: 32

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

TiDB Community Server

Test: oltp_update_non_index - Threads: 1

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

TiDB Community Server

Test: oltp_update_index - Threads: 16

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

Apache Hadoop

Operation: Open - Threads: 100 - Files: 100000

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

TiDB Community Server

Test: oltp_update_index - Threads: 64

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

Apache Hadoop

Operation: Open - Threads: 20 - Files: 1000000

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

TiDB Community Server

Test: oltp_update_non_index - Threads: 64

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

TiDB Community Server

Test: oltp_update_non_index - Threads: 32

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

Apache Hadoop

Operation: Open - Threads: 50 - Files: 1000000

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

Apache Hadoop

Operation: Open - Threads: 500 - Files: 100000

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

Apache Hadoop

Operation: Create - Threads: 20 - Files: 100000

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

Apache Hadoop

Operation: Create - Threads: 50 - Files: 100000

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

TiDB Community Server

Test: oltp_update_non_index - Threads: 16

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

Apache Hadoop

Operation: Delete - Threads: 20 - Files: 100000

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

Apache Hadoop

Operation: Delete - Threads: 50 - Files: 100000

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

Apache Hadoop

Operation: Open - Threads: 100 - Files: 1000000

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

Apache Hadoop

Operation: Open - Threads: 500 - Files: 1000000

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

Apache Hadoop

Operation: Rename - Threads: 20 - Files: 100000

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

Apache Hadoop

Operation: Rename - Threads: 50 - Files: 100000

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

Apache Hadoop

Operation: Create - Threads: 100 - Files: 100000

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

Apache Hadoop

Operation: Create - Threads: 20 - Files: 1000000

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

Apache Hadoop

Operation: Create - Threads: 50 - Files: 1000000

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

Apache Hadoop

Operation: Create - Threads: 500 - Files: 100000

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

Apache Hadoop

Operation: Delete - Threads: 100 - Files: 100000

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

Apache Hadoop

Operation: Delete - Threads: 20 - Files: 1000000

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

Apache Hadoop

Operation: Delete - Threads: 50 - Files: 1000000

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

Apache Hadoop

Operation: Delete - Threads: 500 - Files: 100000

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

Apache Hadoop

Operation: Rename - Threads: 100 - Files: 100000

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

Apache Hadoop

Operation: Rename - Threads: 20 - Files: 1000000

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

Apache Hadoop

Operation: Rename - Threads: 50 - Files: 1000000

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

Apache Hadoop

Operation: Rename - Threads: 500 - Files: 100000

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

Apache Hadoop

Operation: Create - Threads: 100 - Files: 1000000

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

Apache Hadoop

Operation: Create - Threads: 500 - Files: 1000000

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

Apache Hadoop

Operation: Delete - Threads: 100 - Files: 1000000

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

Apache Hadoop

Operation: Delete - Threads: 500 - Files: 1000000

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

Apache Hadoop

Operation: Rename - Threads: 100 - Files: 1000000

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

Apache Hadoop

Operation: Rename - Threads: 500 - Files: 1000000

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

Apache Hadoop

Operation: File Status - Threads: 20 - Files: 100000

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

Apache Hadoop

Operation: File Status - Threads: 50 - Files: 100000

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

Apache Hadoop

Operation: File Status - Threads: 100 - Files: 100000

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

Apache Hadoop

Operation: File Status - Threads: 20 - Files: 1000000

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

TiDB Community Server

Test: oltp_read_write - Threads: 16

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

Apache Hadoop

Operation: File Status - Threads: 50 - Files: 1000000

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

Apache Hadoop

Operation: File Status - Threads: 500 - Files: 100000

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

Apache Hadoop

Operation: File Status - Threads: 100 - Files: 1000000

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

Apache Hadoop

Operation: File Status - Threads: 500 - Files: 1000000

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

TiDB Community Server

Test: oltp_read_write - Threads: 1

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


Phoronix Test Suite v10.8.4