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&export=pdf&grr&rdt&rro.

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

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

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: 16dba15003000450060007500SE +/- 151.08, N = 5SE +/- 156.50, N = 9647268416830

TiDB Community Server

Test: oltp_update_index - Threads: 1

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

TiDB Community Server

Test: oltp_read_write - Threads: 64

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

TiDB Community Server

Test: oltp_point_select - Threads: 1

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

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: 64edba5K10K15K20K25KSE +/- 110.67, N = 321278214012140520927

TiDB Community Server

Test: oltp_read_write - Threads: 1

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

TiDB Community Server

Test: oltp_point_select - Threads: 32

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

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

Apache Hadoop

Operation: Open - Threads: 20 - Files: 1000000

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

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: 1eca110220330440550SE +/- 4.87, N = 3520519522

TiDB Community Server

Test: oltp_read_write - Threads: 16

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

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

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: 1000000edcba700K1400K2100K2800K3500KSE +/- 306417.72, N = 12SE +/- 204074.39, N = 1230581042538071261096623239242644287

Apache Hadoop

Operation: Rename - Threads: 100 - Files: 1000000

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

Apache Hadoop

Operation: Open - Threads: 50 - Files: 1000000

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

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: 32dcb2K4K6K8K10KSE +/- 12.84, N = 2105001042710441

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: 1000000edcba700K1400K2100K2800K3500KSE +/- 299383.09, N = 15SE +/- 275609.80, N = 153048780298507543592017629812105324

Apache Hadoop

Operation: Open - Threads: 100 - Files: 1000000

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

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: 1000000edcba600K1200K1800K2400K3000KSE +/- 64247.19, N = 15SE +/- 109318.69, N = 1228490033012048238663527038572645155

Apache Hadoop

Operation: Open - Threads: 500 - Files: 1000000

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

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: 1000000edcba700K1400K2100K2800K3500KSE +/- 296794.96, N = 12SE +/- 276368.45, N = 1230395142739726275482125335112486588

TiDB Community Server

Test: oltp_update_index - Threads: 64

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

TiDB Community Server

Test: oltp_point_select - Threads: 16

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

TiDB Community Server

Test: oltp_update_index - Threads: 16

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

Apache Hadoop

Operation: Open - Threads: 500 - Files: 100000

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

Apache Hadoop

Operation: Open - Threads: 20 - Files: 100000

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

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: 100000edcba300K600K900K1200K1500KSE +/- 32189.17, N = 15SE +/- 24982.04, N = 1213157891388889133333313861551312507

Apache Hadoop

Operation: Rename - Threads: 500 - Files: 100000

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

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: 100000edcba300K600K900K1200K1500KSE +/- 41248.73, N = 12SE +/- 74556.07, N = 151010101869565128205112092261072125

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: 100000edcba200K400K600K800K1000KSE +/- 71090.09, N = 15SE +/- 83989.70, N = 12104166765789595238111432561125556

Apache Hadoop

Operation: Open - Threads: 100 - Files: 100000

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

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: 100000edcba300K600K900K1200K1500KSE +/- 45729.51, N = 12SE +/- 55546.66, N = 141010101106383088495611590951207762

Apache Hadoop

Operation: Open - Threads: 50 - Files: 100000

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

Apache Hadoop

Operation: Rename - Threads: 500 - Files: 1000000

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

Apache Hadoop

Operation: Delete - Threads: 100 - Files: 100000

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

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

Apache Hadoop

Operation: Create - Threads: 500 - Files: 1000000

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

Apache Hadoop

Operation: Rename - Threads: 20 - Files: 1000000

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

Apache Hadoop

Operation: Delete - Threads: 20 - Files: 1000000

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

Apache Hadoop

Operation: Delete - Threads: 100 - Files: 1000000

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

Apache Hadoop

Operation: Rename - Threads: 50 - Files: 1000000

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

Apache Hadoop

Operation: Delete - Threads: 50 - Files: 1000000

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

Apache Hadoop

Operation: Delete - Threads: 500 - Files: 1000000

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

Apache Hadoop

Operation: Create - Threads: 20 - Files: 1000000

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

Apache Hadoop

Operation: Create - Threads: 50 - Files: 1000000

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

Apache Hadoop

Operation: Create - Threads: 100 - Files: 1000000

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

Apache Hadoop

Operation: Rename - Threads: 20 - Files: 100000

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

Apache Hadoop

Operation: Delete - Threads: 20 - Files: 100000

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

Apache Hadoop

Operation: Rename - Threads: 50 - Files: 100000

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

Apache Hadoop

Operation: Delete - Threads: 50 - Files: 100000

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

Apache Hadoop

Operation: Rename - Threads: 100 - Files: 100000

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

Apache Hadoop

Operation: Delete - Threads: 500 - Files: 100000

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

Apache Hadoop

Operation: Create - Threads: 20 - Files: 100000

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

Apache Hadoop

Operation: Create - Threads: 500 - Files: 100000

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

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

Apache Hadoop

Operation: Create - Threads: 100 - Files: 100000

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


Phoronix Test Suite v10.8.5