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&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 b a 200K 400K 600K 800K 1000K SE +/- 13888.89, N = 3 1098901 1027778
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 b a 200 400 600 800 1000 SE +/- 5.43, N = 3 SE +/- 8.47, N = 4 783 735
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 b a 400K 800K 1200K 1600K 2000K SE +/- 15139.01, N = 9 2000000 1887349
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 b a 20K 40K 60K 80K 100K SE +/- 493.75, N = 3 116604 111239
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 b a 200K 400K 600K 800K 1000K SE +/- 6058.76, N = 15 990099 962090
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 b a 800 1600 2400 3200 4000 SE +/- 31.19, N = 9 SE +/- 26.31, N = 3 3833 3762
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 b a 4K 8K 12K 16K 20K SE +/- 148.09, N = 3 19593 19274
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 b a 20K 40K 60K 80K 100K SE +/- 895.86, N = 12 96525 95497
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 b a 12K 24K 36K 48K 60K SE +/- 243.78, N = 3 SE +/- 680.24, N = 3 54826 54269
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 b a 300K 600K 900K 1200K 1500K SE +/- 19996.64, N = 3 1515152 1500529
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 b a 14K 28K 42K 56K 70K SE +/- 348.76, N = 3 SE +/- 445.12, N = 3 64831 64273
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 b a 20K 40K 60K 80K 100K SE +/- 338.59, N = 3 97248 96552
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 b a 3K 6K 9K 12K 15K SE +/- 57.25, N = 3 13223 13136
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 b a 30K 60K 90K 120K 150K SE +/- 410.05, N = 3 SE +/- 825.26, N = 3 157394 156409
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 b a 11K 22K 33K 44K 55K SE +/- 61.54, N = 3 52086 51820
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 b a 20K 40K 60K 80K 100K SE +/- 266.12, N = 3 SE +/- 156.49, N = 3 94179 93789
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 b a 11K 22K 33K 44K 55K SE +/- 345.84, N = 3 51712 51520
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 b a 20K 40K 60K 80K 100K SE +/- 792.50, N = 3 77882 77656
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 b a 30K 60K 90K 120K 150K SE +/- 259.61, N = 3 SE +/- 775.98, N = 3 130652 130455
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 b a 600K 1200K 1800K 2400K 3000K SE +/- 88473.03, N = 12 2816901 2593301
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 b a 700K 1400K 2100K 2800K 3500K SE +/- 67256.27, N = 15 3115265 2989726
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 b a 300K 600K 900K 1200K 1500K SE +/- 42601.80, N = 15 1204819 1022918
Phoronix Test Suite v10.8.5