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. a: Processor: AMD Ryzen 9 7950X 16-Core @ 4.50GHz (16 Cores / 32 Threads), Motherboard: ASUS ROG STRIX X670E-E GAMING WIFI (1416 BIOS), Chipset: AMD Device 14d8, Memory: 32GB, Disk: Western Digital WD_BLACK SN850X 1000GB + 4001GB Western Digital WD_BLACK SN850X 4000GB, Graphics: NVIDIA GeForce RTX 3070 8GB, Audio: NVIDIA GA104 HD Audio, Monitor: ASUS MG28U, Network: Intel I225-V + Intel Wi-Fi 6 AX210/AX211/AX411 OS: Ubuntu 23.04, Kernel: 6.3.13-060313-generic (x86_64), Desktop: GNOME Shell 44.3, Display Server: X Server 1.21.1.7, Display Driver: NVIDIA 535.104.05, OpenGL: 4.6.0, Compiler: GCC 12.3.0, File-System: ext4, Screen Resolution: 3840x2160 b: Processor: AMD Ryzen 9 7950X 16-Core @ 4.50GHz (16 Cores / 32 Threads), Motherboard: ASUS ROG STRIX X670E-E GAMING WIFI (1416 BIOS), Chipset: AMD Device 14d8, Memory: 32GB, Disk: Western Digital WD_BLACK SN850X 1000GB + 4001GB Western Digital WD_BLACK SN850X 4000GB, Graphics: NVIDIA GeForce RTX 3070 8GB, Audio: NVIDIA GA104 HD Audio, Monitor: ASUS MG28U, Network: Intel I225-V + Intel Wi-Fi 6 AX210/AX211/AX411 OS: Ubuntu 23.04, Kernel: 6.3.13-060313-generic (x86_64), Desktop: GNOME Shell 44.3, Display Server: X Server 1.21.1.7, Display Driver: NVIDIA 535.104.05, OpenGL: 4.6.0, Compiler: GCC 12.3.0, File-System: ext4, Screen Resolution: 3840x2160 TiDB Community Server 7.3 Test: oltp_update_non_index - Threads: 1 Queries Per Second > Higher Is Better a . 1284 |===================================================================== b . 1193 |================================================================ Apache Hadoop 3.3.6 Operation: Open - Threads: 20 - Files: 100000 Ops per sec > Higher Is Better a . 1027778 |============================================================== b . 1098901 |================================================================== TiDB Community Server 7.3 Test: oltp_update_index - Threads: 1 Queries Per Second > Higher Is Better a . 735 |================================================================== b . 783 |====================================================================== Apache Hadoop 3.3.6 Operation: Open - Threads: 20 - Files: 1000000 Ops per sec > Higher Is Better a . 1887349 |============================================================== b . 2000000 |================================================================== TiDB Community Server 7.3 Test: oltp_update_non_index - Threads: 16 Queries Per Second > Higher Is Better a . 8448 |===================================================================== b . 8040 |================================================================== Apache Hadoop 3.3.6 Operation: Delete - Threads: 50 - Files: 1000000 Ops per sec > Higher Is Better a . 111239 |================================================================ b . 116604 |=================================================================== Apache Hadoop 3.3.6 Operation: Open - Threads: 50 - Files: 100000 Ops per sec > Higher Is Better a . 962090 |================================================================= b . 990099 |=================================================================== TiDB Community Server 7.3 Test: oltp_update_index - Threads: 32 Queries Per Second > Higher Is Better a . 8932 |===================================================================== b . 8703 |=================================================================== Apache Hadoop 3.3.6 Operation: Delete - Threads: 20 - Files: 1000000 Ops per sec > Higher Is Better a . 57699 |==================================================================== b . 56628 |=================================================================== TiDB Community Server 7.3 Test: oltp_read_write - Threads: 1 Queries Per Second > Higher Is Better a . 3762 |==================================================================== b . 3833 |===================================================================== Apache Hadoop 3.3.6 Operation: Open - Threads: 50 - Files: 1000000 Ops per sec > Higher Is Better a . 1923254 |================================================================== b . 1890359 |================================================================= TiDB Community Server 7.3 Test: oltp_update_non_index - Threads: 64 Queries Per Second > Higher Is Better a . 19274 |=================================================================== b . 19593 |==================================================================== TiDB Community Server 7.3 Test: oltp_point_select - Threads: 1 Queries Per Second > Higher Is Better a . 8711 |===================================================================== b . 8614 |==================================================================== TiDB Community Server 7.3 Test: oltp_update_index - Threads: 16 Queries Per Second > Higher Is Better a . 5427 |===================================================================== b . 5368 |==================================================================== Apache Hadoop 3.3.6 Operation: Rename - Threads: 50 - Files: 1000000 Ops per sec > Higher Is Better a . 95497 |=================================================================== b . 96525 |==================================================================== TiDB Community Server 7.3 Test: oltp_read_write - Threads: 32 Queries Per Second > Higher Is Better a . 54269 |=================================================================== b . 54826 |==================================================================== Apache Hadoop 3.3.6 Operation: File Status - Threads: 20 - Files: 100000 Ops per sec > Higher Is Better a . 1500529 |================================================================= b . 1515152 |================================================================== Apache Hadoop 3.3.6 Operation: Rename - Threads: 50 - Files: 100000 Ops per sec > Higher Is Better a . 99871 |==================================================================== b . 99010 |=================================================================== TiDB Community Server 7.3 Test: oltp_read_write - Threads: 64 Queries Per Second > Higher Is Better a . 64273 |=================================================================== b . 64831 |==================================================================== TiDB Community Server 7.3 Test: oltp_read_write - Threads: 16 Queries Per Second > Higher Is Better a . 35388 |==================================================================== b . 35110 |=================================================================== Apache Hadoop 3.3.6 Operation: Create - Threads: 50 - Files: 1000000 Ops per sec > Higher Is Better a . 96552 |==================================================================== b . 97248 |==================================================================== TiDB Community Server 7.3 Test: oltp_update_non_index - Threads: 32 Queries Per Second > Higher Is Better a . 13136 |==================================================================== b . 13223 |==================================================================== TiDB Community Server 7.3 Test: oltp_point_select - Threads: 64 Queries Per Second > Higher Is Better a . 156409 |=================================================================== b . 157394 |=================================================================== Apache Hadoop 3.3.6 Operation: Rename - Threads: 20 - Files: 100000 Ops per sec > Higher Is Better a . 52545 |==================================================================== b . 52247 |==================================================================== Apache Hadoop 3.3.6 Operation: Create - Threads: 20 - Files: 1000000 Ops per sec > Higher Is Better a . 51820 |==================================================================== b . 52086 |==================================================================== TiDB Community Server 7.3 Test: oltp_update_index - Threads: 64 Queries Per Second > Higher Is Better a . 12329 |==================================================================== b . 12268 |==================================================================== Apache Hadoop 3.3.6 Operation: Delete - Threads: 50 - Files: 100000 Ops per sec > Higher Is Better a . 116701 |=================================================================== b . 116144 |=================================================================== TiDB Community Server 7.3 Test: oltp_point_select - Threads: 16 Queries Per Second > Higher Is Better a . 93789 |==================================================================== b . 94179 |==================================================================== Apache Hadoop 3.3.6 Operation: Rename - Threads: 20 - Files: 1000000 Ops per sec > Higher Is Better a . 51520 |==================================================================== b . 51712 |==================================================================== Apache Hadoop 3.3.6 Operation: Create - Threads: 50 - Files: 100000 Ops per sec > Higher Is Better a . 77656 |==================================================================== b . 77882 |==================================================================== TiDB Community Server 7.3 Test: oltp_read_write - Threads: 128 Queries Per Second > Higher Is Better a . 71125 |==================================================================== b . 70990 |==================================================================== TiDB Community Server 7.3 Test: oltp_point_select - Threads: 32 Queries Per Second > Higher Is Better a . 130455 |=================================================================== b . 130652 |=================================================================== Apache Hadoop 3.3.6 Operation: Delete - Threads: 20 - Files: 100000 Ops per sec > Higher Is Better a . 58085 |==================================================================== b . 58005 |==================================================================== Apache Hadoop 3.3.6 Operation: Create - Threads: 20 - Files: 100000 Ops per sec > Higher Is Better a . 48318 |==================================================================== b . 48309 |==================================================================== Apache Hadoop 3.3.6 Operation: File Status - Threads: 50 - Files: 1000000 Ops per sec > Higher Is Better a . 2593301 |============================================================= b . 2816901 |================================================================== Apache Hadoop 3.3.6 Operation: File Status - Threads: 20 - Files: 1000000 Ops per sec > Higher Is Better a . 2989726 |=============================================================== b . 3115265 |================================================================== Apache Hadoop 3.3.6 Operation: File Status - Threads: 50 - Files: 100000 Ops per sec > Higher Is Better a . 1022918 |======================================================== b . 1204819 |==================================================================