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&grw .
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 - 32 tidb: oltp_update_non_index - 1 tidb: oltp_update_non_index - 16 tidb: oltp_update_index - 32 tidb: oltp_update_index - 64 tidb: oltp_point_select - 64 tidb: oltp_update_index - 16 tidb: oltp_point_select - 16 tidb: oltp_point_select - 32 tidb: oltp_read_write - 128 tidb: oltp_update_index - 1 tidb: oltp_point_select - 1 tidb: oltp_read_write - 64 tidb: oltp_read_write - 32 tidb: oltp_update_non_index - 64 hadoop: Open - 20 - 100000 hadoop: Open - 50 - 100000 tidb: oltp_read_write - 16 hadoop: Open - 20 - 1000000 hadoop: Open - 50 - 1000000 hadoop: Create - 20 - 100000 hadoop: Create - 50 - 100000 hadoop: Delete - 20 - 100000 hadoop: Delete - 50 - 100000 hadoop: Rename - 20 - 100000 hadoop: Rename - 50 - 100000 hadoop: Create - 20 - 1000000 hadoop: Create - 50 - 1000000 hadoop: Delete - 20 - 1000000 hadoop: Delete - 50 - 1000000 hadoop: Rename - 20 - 1000000 hadoop: Rename - 50 - 1000000 hadoop: File Status - 20 - 100000 hadoop: File Status - 50 - 100000 hadoop: File Status - 20 - 1000000 hadoop: File Status - 50 - 1000000 tidb: oltp_read_write - 1 a b 13136 1284 8448 8932 12329 156409 5427 93789 130455 71125 735 8711 64273 54269 19274 1027778 962090 35388 1887349 1923254 48318 77656 58085 116701 52545 99871 51820 96552 57699 111239 51520 95497 1500529 1022918 2989726 2593301 3762 13223 1193 8040 8703 12268 157394 5368 94179 130652 70990 783 8614 64831 54826 19593 1098901 990099 35110 2000000 1890359 48309 77882 58005 116144 52247 99010 52086 97248 56628 116604 51712 96525 1515152 1204819 3115265 2816901 3833 OpenBenchmarking.org
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_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
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
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
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
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
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
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
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
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_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
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_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: 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
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
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
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_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: 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
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
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: 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
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: 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
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: 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
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
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
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
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: 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: 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
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: 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
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: 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
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
Phoronix Test Suite v10.8.5