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

a

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

b

c

d

e

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

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

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

TiDB Community Server

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

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

Test: oltp_read_write - Threads: 16

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

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

Apache Hadoop

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

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

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

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

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

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

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

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

TiDB Community Server

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

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

Test: oltp_update_index - Threads: 1

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

Apache Hadoop

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

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

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

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

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

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

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

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

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

TiDB Community Server

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

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

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

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

Test: oltp_update_non_index - Threads: 64

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

Apache Hadoop

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

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

TiDB Community Server

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

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

Test: oltp_read_write - Threads: 1

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

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

Test: oltp_update_index - Threads: 32

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

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

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

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

Test: oltp_point_select - Threads: 32

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

Apache Hadoop

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

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

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

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

TiDB Community Server

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

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

Test: oltp_point_select - Threads: 16

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

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

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

Apache Hadoop

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

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

TiDB Community Server

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

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

Test: oltp_point_select - Threads: 64

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

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

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

Test: oltp_read_write - Threads: 32

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

Apache Hadoop

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

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

TiDB Community Server

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

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

Test: oltp_update_non_index - Threads: 32

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

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

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

Test: oltp_update_non_index - Threads: 1

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

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

Apache Hadoop

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

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

TiDB Community Server

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

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

Test: oltp_update_index - Threads: 16

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

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

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

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

Test: oltp_update_index - Threads: 64

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

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

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

Apache Hadoop

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

TiDB Community Server

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

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

Test: oltp_update_non_index - Threads: 16

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

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

56 Results Shown

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

a

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

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

b

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

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

c

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

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

d

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

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

e

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

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

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

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