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&grs .
ryzen db Processor Motherboard Chipset Memory Disk Graphics Audio Monitor Network OS Kernel Desktop Display Server Display Driver OpenGL Compiler File-System Screen Resolution a b AMD Ryzen 9 7950X 16-Core @ 4.50GHz (16 Cores / 32 Threads) ASUS ROG STRIX X670E-E GAMING WIFI (1416 BIOS) AMD Device 14d8 32GB Western Digital WD_BLACK SN850X 1000GB + 4001GB Western Digital WD_BLACK SN850X 4000GB NVIDIA GeForce RTX 3070 8GB NVIDIA GA104 HD Audio ASUS MG28U Intel I225-V + Intel Wi-Fi 6 AX210/AX211/AX411 Ubuntu 23.04 6.3.13-060313-generic (x86_64) GNOME Shell 44.3 X Server 1.21.1.7 NVIDIA 535.104.05 4.6.0 GCC 12.3.0 ext4 3840x2160 OpenBenchmarking.org Kernel Details - Transparent Huge Pages: madvise Processor Details - Scaling Governor: acpi-cpufreq performance (Boost: Enabled) - CPU Microcode: 0xa601203 Java 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 db tidb: oltp_update_non_index - 1 hadoop: Open - 20 - 100000 tidb: oltp_update_index - 1 hadoop: Open - 20 - 1000000 tidb: oltp_update_non_index - 16 hadoop: Delete - 50 - 1000000 hadoop: Open - 50 - 100000 tidb: oltp_update_index - 32 hadoop: Delete - 20 - 1000000 tidb: oltp_read_write - 1 hadoop: Open - 50 - 1000000 tidb: oltp_update_non_index - 64 tidb: oltp_point_select - 1 tidb: oltp_update_index - 16 hadoop: Rename - 50 - 1000000 tidb: oltp_read_write - 32 hadoop: File Status - 20 - 100000 hadoop: Rename - 50 - 100000 tidb: oltp_read_write - 64 tidb: oltp_read_write - 16 hadoop: Create - 50 - 1000000 tidb: oltp_update_non_index - 32 tidb: oltp_point_select - 64 hadoop: Rename - 20 - 100000 hadoop: Create - 20 - 1000000 tidb: oltp_update_index - 64 hadoop: Delete - 50 - 100000 tidb: oltp_point_select - 16 hadoop: Rename - 20 - 1000000 hadoop: Create - 50 - 100000 tidb: oltp_read_write - 128 tidb: oltp_point_select - 32 hadoop: Delete - 20 - 100000 hadoop: Create - 20 - 100000 hadoop: File Status - 50 - 1000000 hadoop: File Status - 20 - 1000000 hadoop: File Status - 50 - 100000 a b 1284 1027778 735 1887349 8448 111239 962090 8932 57699 3762 1923254 19274 8711 5427 95497 54269 1500529 99871 64273 35388 96552 13136 156409 52545 51820 12329 116701 93789 51520 77656 71125 130455 58085 48318 2593301 2989726 1022918 1193 1098901 783 2000000 8040 116604 990099 8703 56628 3833 1890359 19593 8614 5368 96525 54826 1515152 99010 64831 35110 97248 13223 157394 52247 52086 12268 116144 94179 51712 77882 70990 130652 58005 48309 2816901 3115265 1204819 OpenBenchmarking.org
TiDB Community Server Test: oltp_update_non_index - Threads: 1 OpenBenchmarking.org Queries Per Second, More Is Better TiDB Community Server 7.3 Test: oltp_update_non_index - Threads: 1 a b 300 600 900 1200 1500 SE +/- 18.10, N = 9 1284 1193
Apache Hadoop Operation: Open - Threads: 20 - Files: 100000 OpenBenchmarking.org Ops per sec, More Is Better Apache Hadoop 3.3.6 Operation: Open - Threads: 20 - Files: 100000 a b 200K 400K 600K 800K 1000K SE +/- 13888.89, N = 3 1027778 1098901
TiDB Community Server Test: oltp_update_index - Threads: 1 OpenBenchmarking.org Queries Per Second, More Is Better TiDB Community Server 7.3 Test: oltp_update_index - Threads: 1 a b 200 400 600 800 1000 SE +/- 8.47, N = 4 SE +/- 5.43, N = 3 735 783
Apache Hadoop Operation: Open - Threads: 20 - Files: 1000000 OpenBenchmarking.org Ops per sec, More Is Better Apache Hadoop 3.3.6 Operation: Open - Threads: 20 - Files: 1000000 a b 400K 800K 1200K 1600K 2000K SE +/- 15139.01, N = 9 1887349 2000000
TiDB Community Server Test: oltp_update_non_index - Threads: 16 OpenBenchmarking.org Queries Per Second, More Is Better TiDB Community Server 7.3 Test: oltp_update_non_index - Threads: 16 a b 2K 4K 6K 8K 10K SE +/- 71.57, N = 3 8448 8040
Apache Hadoop Operation: Delete - Threads: 50 - Files: 1000000 OpenBenchmarking.org Ops per sec, More Is Better Apache Hadoop 3.3.6 Operation: Delete - Threads: 50 - Files: 1000000 a b 20K 40K 60K 80K 100K SE +/- 493.75, N = 3 111239 116604
Apache Hadoop Operation: Open - Threads: 50 - Files: 100000 OpenBenchmarking.org Ops per sec, More Is Better Apache Hadoop 3.3.6 Operation: Open - Threads: 50 - Files: 100000 a b 200K 400K 600K 800K 1000K SE +/- 6058.76, N = 15 962090 990099
TiDB Community Server Test: oltp_update_index - Threads: 32 OpenBenchmarking.org Queries Per Second, More Is Better TiDB Community Server 7.3 Test: oltp_update_index - Threads: 32 a b 2K 4K 6K 8K 10K SE +/- 90.71, N = 9 SE +/- 53.49, N = 3 8932 8703
Apache Hadoop Operation: Delete - Threads: 20 - Files: 1000000 OpenBenchmarking.org Ops per sec, More Is Better Apache Hadoop 3.3.6 Operation: Delete - Threads: 20 - Files: 1000000 a b 12K 24K 36K 48K 60K SE +/- 733.62, N = 3 57699 56628
TiDB Community Server Test: oltp_read_write - Threads: 1 OpenBenchmarking.org Queries Per Second, More Is Better TiDB Community Server 7.3 Test: oltp_read_write - Threads: 1 a b 800 1600 2400 3200 4000 SE +/- 26.31, N = 3 SE +/- 31.19, N = 9 3762 3833
Apache Hadoop Operation: Open - Threads: 50 - Files: 1000000 OpenBenchmarking.org Ops per sec, More Is Better Apache Hadoop 3.3.6 Operation: Open - Threads: 50 - Files: 1000000 a b 400K 800K 1200K 1600K 2000K SE +/- 13074.61, N = 3 1923254 1890359
TiDB Community Server Test: oltp_update_non_index - Threads: 64 OpenBenchmarking.org Queries Per Second, More Is Better TiDB Community Server 7.3 Test: oltp_update_non_index - Threads: 64 a b 4K 8K 12K 16K 20K SE +/- 148.09, N = 3 19274 19593
TiDB Community Server Test: oltp_point_select - Threads: 1 OpenBenchmarking.org Queries Per Second, More Is Better TiDB Community Server 7.3 Test: oltp_point_select - Threads: 1 a b 2K 4K 6K 8K 10K SE +/- 15.98, N = 3 SE +/- 60.33, N = 3 8711 8614
TiDB Community Server Test: oltp_update_index - Threads: 16 OpenBenchmarking.org Queries Per Second, More Is Better TiDB Community Server 7.3 Test: oltp_update_index - Threads: 16 a b 1200 2400 3600 4800 6000 SE +/- 32.49, N = 3 SE +/- 60.41, N = 3 5427 5368
Apache Hadoop Operation: Rename - Threads: 50 - Files: 1000000 OpenBenchmarking.org Ops per sec, More Is Better Apache Hadoop 3.3.6 Operation: Rename - Threads: 50 - Files: 1000000 a b 20K 40K 60K 80K 100K SE +/- 895.86, N = 12 95497 96525
TiDB Community Server Test: oltp_read_write - Threads: 32 OpenBenchmarking.org Queries Per Second, More Is Better TiDB Community Server 7.3 Test: oltp_read_write - Threads: 32 a b 12K 24K 36K 48K 60K SE +/- 680.24, N = 3 SE +/- 243.78, N = 3 54269 54826
Apache Hadoop Operation: File Status - Threads: 20 - Files: 100000 OpenBenchmarking.org Ops per sec, More Is Better Apache Hadoop 3.3.6 Operation: File Status - Threads: 20 - Files: 100000 a b 300K 600K 900K 1200K 1500K SE +/- 19996.64, N = 3 1500529 1515152
Apache Hadoop Operation: Rename - Threads: 50 - Files: 100000 OpenBenchmarking.org Ops per sec, More Is Better Apache Hadoop 3.3.6 Operation: Rename - Threads: 50 - Files: 100000 a b 20K 40K 60K 80K 100K SE +/- 467.62, N = 3 99871 99010
TiDB Community Server Test: oltp_read_write - Threads: 64 OpenBenchmarking.org Queries Per Second, More Is Better TiDB Community Server 7.3 Test: oltp_read_write - Threads: 64 a b 14K 28K 42K 56K 70K SE +/- 445.12, N = 3 SE +/- 348.76, N = 3 64273 64831
TiDB Community Server Test: oltp_read_write - Threads: 16 OpenBenchmarking.org Queries Per Second, More Is Better TiDB Community Server 7.3 Test: oltp_read_write - Threads: 16 a b 8K 16K 24K 32K 40K SE +/- 78.29, N = 3 SE +/- 217.62, N = 3 35388 35110
Apache Hadoop Operation: Create - Threads: 50 - Files: 1000000 OpenBenchmarking.org Ops per sec, More Is Better Apache Hadoop 3.3.6 Operation: Create - Threads: 50 - Files: 1000000 a b 20K 40K 60K 80K 100K SE +/- 338.59, N = 3 96552 97248
TiDB Community Server Test: oltp_update_non_index - Threads: 32 OpenBenchmarking.org Queries Per Second, More Is Better TiDB Community Server 7.3 Test: oltp_update_non_index - Threads: 32 a b 3K 6K 9K 12K 15K SE +/- 57.25, N = 3 13136 13223
TiDB Community Server Test: oltp_point_select - Threads: 64 OpenBenchmarking.org Queries Per Second, More Is Better TiDB Community Server 7.3 Test: oltp_point_select - Threads: 64 a b 30K 60K 90K 120K 150K SE +/- 825.26, N = 3 SE +/- 410.05, N = 3 156409 157394
Apache Hadoop Operation: Rename - Threads: 20 - Files: 100000 OpenBenchmarking.org Ops per sec, More Is Better Apache Hadoop 3.3.6 Operation: Rename - Threads: 20 - Files: 100000 a b 11K 22K 33K 44K 55K SE +/- 366.97, N = 3 52545 52247
Apache Hadoop Operation: Create - Threads: 20 - Files: 1000000 OpenBenchmarking.org Ops per sec, More Is Better Apache Hadoop 3.3.6 Operation: Create - Threads: 20 - Files: 1000000 a b 11K 22K 33K 44K 55K SE +/- 61.54, N = 3 51820 52086
TiDB Community Server Test: oltp_update_index - Threads: 64 OpenBenchmarking.org Queries Per Second, More Is Better TiDB Community Server 7.3 Test: oltp_update_index - Threads: 64 a b 3K 6K 9K 12K 15K SE +/- 162.28, N = 3 12329 12268
Apache Hadoop Operation: Delete - Threads: 50 - Files: 100000 OpenBenchmarking.org Ops per sec, More Is Better Apache Hadoop 3.3.6 Operation: Delete - Threads: 50 - Files: 100000 a b 20K 40K 60K 80K 100K SE +/- 943.54, N = 3 116701 116144
TiDB Community Server Test: oltp_point_select - Threads: 16 OpenBenchmarking.org Queries Per Second, More Is Better TiDB Community Server 7.3 Test: oltp_point_select - Threads: 16 a b 20K 40K 60K 80K 100K SE +/- 156.49, N = 3 SE +/- 266.12, N = 3 93789 94179
Apache Hadoop Operation: Rename - Threads: 20 - Files: 1000000 OpenBenchmarking.org Ops per sec, More Is Better Apache Hadoop 3.3.6 Operation: Rename - Threads: 20 - Files: 1000000 a b 11K 22K 33K 44K 55K SE +/- 345.84, N = 3 51520 51712
Apache Hadoop Operation: Create - Threads: 50 - Files: 100000 OpenBenchmarking.org Ops per sec, More Is Better Apache Hadoop 3.3.6 Operation: Create - Threads: 50 - Files: 100000 a b 20K 40K 60K 80K 100K SE +/- 792.50, N = 3 77656 77882
TiDB Community Server Test: oltp_read_write - Threads: 128 OpenBenchmarking.org Queries Per Second, More Is Better TiDB Community Server 7.3 Test: oltp_read_write - Threads: 128 a b 15K 30K 45K 60K 75K SE +/- 292.99, N = 3 SE +/- 497.35, N = 3 71125 70990
TiDB Community Server Test: oltp_point_select - Threads: 32 OpenBenchmarking.org Queries Per Second, More Is Better TiDB Community Server 7.3 Test: oltp_point_select - Threads: 32 a b 30K 60K 90K 120K 150K SE +/- 775.98, N = 3 SE +/- 259.61, N = 3 130455 130652
Apache Hadoop Operation: Delete - Threads: 20 - Files: 100000 OpenBenchmarking.org Ops per sec, More Is Better Apache Hadoop 3.3.6 Operation: Delete - Threads: 20 - Files: 100000 a b 12K 24K 36K 48K 60K SE +/- 254.52, N = 3 58085 58005
Apache Hadoop Operation: Create - Threads: 20 - Files: 100000 OpenBenchmarking.org Ops per sec, More Is Better Apache Hadoop 3.3.6 Operation: Create - Threads: 20 - Files: 100000 a b 10K 20K 30K 40K 50K SE +/- 114.87, N = 3 48318 48309
Apache Hadoop Operation: File Status - Threads: 50 - Files: 1000000 OpenBenchmarking.org Ops per sec, More Is Better Apache Hadoop 3.3.6 Operation: File Status - Threads: 50 - Files: 1000000 a b 600K 1200K 1800K 2400K 3000K SE +/- 88473.03, N = 12 2593301 2816901
Apache Hadoop Operation: File Status - Threads: 20 - Files: 1000000 OpenBenchmarking.org Ops per sec, More Is Better Apache Hadoop 3.3.6 Operation: File Status - Threads: 20 - Files: 1000000 a b 700K 1400K 2100K 2800K 3500K SE +/- 67256.27, N = 15 2989726 3115265
Apache Hadoop Operation: File Status - Threads: 50 - Files: 100000 OpenBenchmarking.org Ops per sec, More Is Better Apache Hadoop 3.3.6 Operation: File Status - Threads: 50 - Files: 100000 a b 300K 600K 900K 1200K 1500K SE +/- 42601.80, N = 15 1022918 1204819
Phoronix Test Suite v10.8.5