ryzen db

AMD Ryzen 9 7950X 16-Core testing with a ASUS ROG STRIX X670E-E GAMING WIFI (1416 BIOS) and NVIDIA GeForce RTX 3070 8GB on Ubuntu 23.04 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2309084-PTS-RYZENDB986&grt&sro.

ryzen dbProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerDisplay DriverOpenGLCompilerFile-SystemScreen ResolutionabAMD Ryzen 9 7950X 16-Core @ 4.50GHz (16 Cores / 32 Threads)ASUS ROG STRIX X670E-E GAMING WIFI (1416 BIOS)AMD Device 14d832GBWestern Digital WD_BLACK SN850X 1000GB + 4001GB Western Digital WD_BLACK SN850X 4000GBNVIDIA GeForce RTX 3070 8GBNVIDIA GA104 HD AudioASUS MG28UIntel I225-V + Intel Wi-Fi 6 AX210/AX211/AX411Ubuntu 23.046.3.13-060313-generic (x86_64)GNOME Shell 44.3X Server 1.21.1.7NVIDIA 535.104.054.6.0GCC 12.3.0ext43840x2160OpenBenchmarking.orgKernel Details- Transparent Huge Pages: madviseProcessor Details- Scaling Governor: acpi-cpufreq performance (Boost: Enabled) - CPU Microcode: 0xa601203Java Details- OpenJDK Runtime Environment (build 17.0.8.1+1-Ubuntu-0ubuntu123.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: Not affected + srbds: Not affected + tsx_async_abort: Not affected

ryzen dbhadoop: Open - 20 - 100000hadoop: Open - 50 - 100000hadoop: Open - 20 - 1000000hadoop: Open - 50 - 1000000hadoop: Create - 20 - 100000hadoop: Create - 50 - 100000hadoop: Delete - 20 - 100000hadoop: Delete - 50 - 100000hadoop: Rename - 20 - 100000hadoop: Rename - 50 - 100000hadoop: Create - 20 - 1000000hadoop: Create - 50 - 1000000hadoop: Delete - 20 - 1000000hadoop: Delete - 50 - 1000000hadoop: Rename - 20 - 1000000hadoop: Rename - 50 - 1000000hadoop: File Status - 20 - 100000hadoop: File Status - 50 - 100000hadoop: File Status - 20 - 1000000hadoop: File Status - 50 - 1000000tidb: oltp_read_write - 1tidb: oltp_read_write - 16tidb: oltp_read_write - 32tidb: oltp_read_write - 64tidb: oltp_point_select - 1tidb: oltp_read_write - 128tidb: 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 - 64ab10277789620901887349192325448318776565808511670152545998715182096552576991112395152095497150052910229182989726259330137623538854269642738711711257359378913045515640954278932123291284844813136192741098901990099200000018903594830977882580051161445224799010520869724856628116604517129652515151521204819311526528169013833351105482664831861470990783941791306521573945368870312268119380401322319593OpenBenchmarking.org

Apache Hadoop

Operation: Open - Threads: 20 - Files: 100000

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 20 - Files: 100000ab200K400K600K800K1000KSE +/- 13888.89, N = 310277781098901

Apache Hadoop

Operation: Open - Threads: 50 - Files: 100000

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 50 - Files: 100000ab200K400K600K800K1000KSE +/- 6058.76, N = 15962090990099

Apache Hadoop

Operation: Open - Threads: 20 - Files: 1000000

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 20 - Files: 1000000ab400K800K1200K1600K2000KSE +/- 15139.01, N = 918873492000000

Apache Hadoop

Operation: Open - Threads: 50 - Files: 1000000

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 50 - Files: 1000000ab400K800K1200K1600K2000KSE +/- 13074.61, N = 319232541890359

Apache Hadoop

Operation: Create - Threads: 20 - Files: 100000

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 20 - Files: 100000ab10K20K30K40K50KSE +/- 114.87, N = 34831848309

Apache Hadoop

Operation: Create - Threads: 50 - Files: 100000

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 50 - Files: 100000ab20K40K60K80K100KSE +/- 792.50, N = 37765677882

Apache Hadoop

Operation: Delete - Threads: 20 - Files: 100000

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 20 - Files: 100000ab12K24K36K48K60KSE +/- 254.52, N = 35808558005

Apache Hadoop

Operation: Delete - Threads: 50 - Files: 100000

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 50 - Files: 100000ab20K40K60K80K100KSE +/- 943.54, N = 3116701116144

Apache Hadoop

Operation: Rename - Threads: 20 - Files: 100000

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 20 - Files: 100000ab11K22K33K44K55KSE +/- 366.97, N = 35254552247

Apache Hadoop

Operation: Rename - Threads: 50 - Files: 100000

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 50 - Files: 100000ab20K40K60K80K100KSE +/- 467.62, N = 39987199010

Apache Hadoop

Operation: Create - Threads: 20 - Files: 1000000

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 20 - Files: 1000000ab11K22K33K44K55KSE +/- 61.54, N = 35182052086

Apache Hadoop

Operation: Create - Threads: 50 - Files: 1000000

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 50 - Files: 1000000ab20K40K60K80K100KSE +/- 338.59, N = 39655297248

Apache Hadoop

Operation: Delete - Threads: 20 - Files: 1000000

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 20 - Files: 1000000ab12K24K36K48K60KSE +/- 733.62, N = 35769956628

Apache Hadoop

Operation: Delete - Threads: 50 - Files: 1000000

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 50 - Files: 1000000ab20K40K60K80K100KSE +/- 493.75, N = 3111239116604

Apache Hadoop

Operation: Rename - Threads: 20 - Files: 1000000

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 20 - Files: 1000000ab11K22K33K44K55KSE +/- 345.84, N = 35152051712

Apache Hadoop

Operation: Rename - Threads: 50 - Files: 1000000

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 50 - Files: 1000000ab20K40K60K80K100KSE +/- 895.86, N = 129549796525

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: 100000ab300K600K900K1200K1500KSE +/- 19996.64, N = 315005291515152

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: 100000ab300K600K900K1200K1500KSE +/- 42601.80, N = 1510229181204819

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: 1000000ab700K1400K2100K2800K3500KSE +/- 67256.27, N = 1529897263115265

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: 1000000ab600K1200K1800K2400K3000KSE +/- 88473.03, N = 1225933012816901

TiDB Community Server

Test: oltp_read_write - Threads: 1

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_read_write - Threads: 1ab8001600240032004000SE +/- 26.31, N = 3SE +/- 31.19, N = 937623833

TiDB Community Server

Test: oltp_read_write - Threads: 16

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_read_write - Threads: 16ab8K16K24K32K40KSE +/- 78.29, N = 3SE +/- 217.62, N = 33538835110

TiDB Community Server

Test: oltp_read_write - Threads: 32

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_read_write - Threads: 32ab12K24K36K48K60KSE +/- 680.24, N = 3SE +/- 243.78, N = 35426954826

TiDB Community Server

Test: oltp_read_write - Threads: 64

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_read_write - Threads: 64ab14K28K42K56K70KSE +/- 445.12, N = 3SE +/- 348.76, N = 36427364831

TiDB Community Server

Test: oltp_point_select - Threads: 1

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_point_select - Threads: 1ab2K4K6K8K10KSE +/- 15.98, N = 3SE +/- 60.33, N = 387118614

TiDB Community Server

Test: oltp_read_write - Threads: 128

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_read_write - Threads: 128ab15K30K45K60K75KSE +/- 292.99, N = 3SE +/- 497.35, N = 37112570990

TiDB Community Server

Test: oltp_update_index - Threads: 1

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_index - Threads: 1ab2004006008001000SE +/- 8.47, N = 4SE +/- 5.43, N = 3735783

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 +/- 156.49, N = 3SE +/- 266.12, N = 39378994179

TiDB Community Server

Test: oltp_point_select - Threads: 32

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_point_select - Threads: 32ab30K60K90K120K150KSE +/- 775.98, N = 3SE +/- 259.61, N = 3130455130652

TiDB Community Server

Test: oltp_point_select - Threads: 64

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_point_select - Threads: 64ab30K60K90K120K150KSE +/- 825.26, N = 3SE +/- 410.05, N = 3156409157394

TiDB Community Server

Test: oltp_update_index - Threads: 16

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_index - Threads: 16ab12002400360048006000SE +/- 32.49, N = 3SE +/- 60.41, N = 354275368

TiDB Community Server

Test: oltp_update_index - Threads: 32

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_index - Threads: 32ab2K4K6K8K10KSE +/- 90.71, N = 9SE +/- 53.49, N = 389328703

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 +/- 162.28, N = 31232912268

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: 1ab30060090012001500SE +/- 18.10, N = 912841193

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: 16ab2K4K6K8K10KSE +/- 71.57, N = 384488040

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: 32ab3K6K9K12K15KSE +/- 57.25, N = 31313613223

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: 64ab4K8K12K16K20KSE +/- 148.09, N = 31927419593


Phoronix Test Suite v10.8.5