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&sor.

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 dbtidb: 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 - 64hadoop: 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 - 1000000ab37623538854269642738711711257359378913045515640954278932123291284844813136192741027778962090188734919232544831877656580851167015254599871518209655257699111239515209549715005291022918298972625933013833351105482664831861470990783941791306521573945368870312268119380401322319593109890199009920000001890359483097788258005116144522479901052086972485662811660451712965251515152120481931152652816901OpenBenchmarking.org

TiDB Community Server

Test: oltp_read_write - Threads: 1

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

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: 32ba12K24K36K48K60KSE +/- 243.78, N = 3SE +/- 680.24, N = 35482654269

TiDB Community Server

Test: oltp_read_write - Threads: 64

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

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: 1ba2004006008001000SE +/- 5.43, N = 3SE +/- 8.47, N = 4783735

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

TiDB Community Server

Test: oltp_point_select - Threads: 32

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

TiDB Community Server

Test: oltp_point_select - Threads: 64

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

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

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

Apache Hadoop

Operation: Open - Threads: 20 - Files: 100000

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

Apache Hadoop

Operation: Open - Threads: 50 - Files: 100000

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

Apache Hadoop

Operation: Open - Threads: 20 - Files: 1000000

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

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: 100000ba20K40K60K80K100KSE +/- 792.50, N = 37788277656

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: 1000000ba11K22K33K44K55KSE +/- 61.54, N = 35208651820

Apache Hadoop

Operation: Create - Threads: 50 - Files: 1000000

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

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: 1000000ba20K40K60K80K100KSE +/- 493.75, N = 3116604111239

Apache Hadoop

Operation: Rename - Threads: 20 - Files: 1000000

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

Apache Hadoop

Operation: Rename - Threads: 50 - Files: 1000000

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

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

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

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

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

Phoronix Test Suite v10.8.5