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