raptor db Intel Core i9-13900K testing with a ASUS PRIME Z790-P WIFI (0812 BIOS) and AMD Radeon RX 7700S/7600S/7600M XT 8GB on Ubuntu 22.04 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/2309076-PTS-RAPTORDB81&grr .
raptor db Processor Motherboard Chipset Memory Disk Graphics Audio Monitor OS Kernel Desktop Display Server OpenGL OpenCL Vulkan Compiler File-System Screen Resolution a Intel Core i9-13900K @ 5.50GHz (24 Cores / 32 Threads) ASUS PRIME Z790-P WIFI (0812 BIOS) Intel Device 7a27 32GB 1000GB Western Digital WDS100T1X0E-00AFY0 AMD Radeon RX 7700S/7600S/7600M XT 8GB (1940/1124MHz) Realtek ALC897 ASUS VP28U Ubuntu 22.04 6.4.6-060406-generic (x86_64) GNOME Shell 42.9 X Server 1.21.1.4 + Wayland 4.6 Mesa 23.3~git2308070600.777734~oibaf~j (git-7777349 2023-08-07 jammy-oibaf-ppa) (LLVM 15.0.7 DRM 3.52) OpenCL 1.1 Mesa 23.3~git2308020600.4de7e0~oibaf~j (git-4de7e00 2023-08-02 jammy-oibaf-ppa) + OpenCL 3.0 1.3.258 GCC 11.4.0 + Clang 16.0.6 + LLVM 16.0.6 ext4 3840x2160 OpenBenchmarking.org - Transparent Huge Pages: madvise - Scaling Governor: intel_pstate powersave (EPP: balance_performance) - CPU Microcode: 0x119 - Thermald 2.4.9 - OpenJDK Runtime Environment (build 11.0.20.1+1-post-Ubuntu-0ubuntu122.04) - 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: SW sequence + srbds: Not affected + tsx_async_abort: Not affected
raptor db tidb: oltp_update_index - 32 tidb: oltp_read_write - 32 tidb: oltp_point_select - 64 tidb: oltp_update_non_index - 1 tidb: oltp_read_write - 16 tidb: oltp_update_non_index - 32 tidb: oltp_point_select - 1 tidb: oltp_point_select - 32 tidb: oltp_point_select - 16 tidb: oltp_read_write - 1 hadoop: Open - 20 - 100000 hadoop: File Status - 20 - 100000 hadoop: Delete - 50 - 100000 tidb: oltp_update_non_index - 64 tidb: oltp_update_index - 1 hadoop: File Status - 50 - 100000 hadoop: Open - 50 - 100000 hadoop: Rename - 20 - 100000 hadoop: Delete - 20 - 100000 hadoop: Rename - 50 - 100000 hadoop: Create - 20 - 100000 hadoop: Create - 50 - 100000 tidb: oltp_update_non_index - 16 a 8914 66351 188971 524 41601 11746 2636 159262 111019 1161 1098255 1299211 96613 26146 410 1098590 1010552 41582 45851 89133 39165 74222 OpenBenchmarking.org
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 2K 4K 6K 8K 10K SE +/- 40.07, N = 3 8914
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 14K 28K 42K 56K 70K SE +/- 283.00, N = 3 66351
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 40K 80K 120K 160K 200K SE +/- 330.31, N = 3 188971
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 110 220 330 440 550 SE +/- 1.21, N = 2 524
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 9K 18K 27K 36K 45K SE +/- 626.97, N = 2 41601
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 3K 6K 9K 12K 15K SE +/- 71.93, N = 2 11746
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 600 1200 1800 2400 3000 SE +/- 33.90, N = 2 2636
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 30K 60K 90K 120K 150K SE +/- 1187.80, N = 2 159262
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 20K 40K 60K 80K 100K SE +/- 484.18, N = 2 111019
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 200 400 600 800 1000 SE +/- 6.38, N = 2 1161
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 200K 400K 600K 800K 1000K SE +/- 24875.30, N = 14 1098255
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 300K 600K 900K 1200K 1500K SE +/- 36644.72, N = 12 1299211
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 20K 40K 60K 80K 100K SE +/- 767.02, N = 12 96613
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 6K 12K 18K 24K 30K 26146
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 90 180 270 360 450 410
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 200K 400K 600K 800K 1000K SE +/- 63532.90, N = 12 1098590
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 200K 400K 600K 800K 1000K SE +/- 29923.69, N = 12 1010552
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 9K 18K 27K 36K 45K SE +/- 203.06, N = 3 41582
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 10K 20K 30K 40K 50K SE +/- 138.24, N = 3 45851
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 20K 40K 60K 80K 100K SE +/- 550.42, N = 3 89133
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 8K 16K 24K 32K 40K SE +/- 74.13, N = 3 39165
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 16K 32K 48K 64K 80K SE +/- 211.18, N = 3 74222
Phoronix Test Suite v10.8.5