Benchmarks for a future article.
Compare your own system(s) to this result file with the
Phoronix Test Suite by running the command:
phoronix-test-suite benchmark 2404022-NE-SSDSTORAG76 SSD Storage - Phoronix Test Suite SSD Storage Benchmarks for a future article.
HTML result view exported from: https://openbenchmarking.org/result/2404022-NE-SSDSTORAG76&grt&sor .
SSD Storage Processor Motherboard Chipset Memory Disk Graphics Network OS Kernel Desktop Display Server Compiler File-System Screen Resolution Micron 7450 Max 3.2TB Corsair MP700 PRO 2TB Crucial T705 2TB Corsair MP700 2TB Samsung MZWLJ1T9HBJR-00007 AMD EPYC 8534P 64-Core @ 2.30GHz (64 Cores / 128 Threads) AMD Cinnabar (RCB1009C BIOS) AMD Device 14a4 6 x 32GB DRAM-4800MT/s Samsung M321R4GA0BB0-CQKMG 3201GB Micron_7450_MTFDKCB3T2TFS ASPEED 2 x Broadcom NetXtreme BCM5720 PCIe Ubuntu 23.10 6.8.1-060801-generic (x86_64) GNOME Shell 45.2 X Server 1.21.1.7 GCC 13.2.0 ext4 1920x1200 3201GB Micron_7450_MTFDKCB3T2TFS + 2000GB Corsair MP700 PRO 3201GB Micron_7450_MTFDKCB3T2TFS + 2000GB CT2000T705SSD5 3201GB Micron_7450_MTFDKCB3T2TFS + 2000GB Corsair MP700 3201GB Micron_7450_MTFDKCB3T2TFS + 2 x 1920GB SAMSUNG MZWLJ1T9HBJR-00007 OpenBenchmarking.org Kernel Details - Transparent Huge Pages: madvise Compiler Details - --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-bootstrap --enable-cet --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,d,fortran,objc,obj-c++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-link-serialization=2 --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-defaulted --enable-offload-targets=nvptx-none=/build/gcc-13-XYspKM/gcc-13-13.2.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-13-XYspKM/gcc-13-13.2.0/debian/tmp-gcn/usr --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-build-config=bootstrap-lto-lean --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib=auto --with-tune=generic --without-cuda-driver -v Disk Details - Micron 7450 Max 3.2TB: NONE / relatime,rw,stripe=64 / Block Size: 4096 - Corsair MP700 PRO 2TB: NONE / relatime,rw / Block Size: 4096 - Crucial T705 2TB: NONE / relatime,rw / Block Size: 4096 - Corsair MP700 2TB: NONE / relatime,rw / Block Size: 4096 - Samsung MZWLJ1T9HBJR-00007: NONE / relatime,rw / Block Size: 4096 Processor Details - Scaling Governor: acpi-cpufreq performance (Boost: Enabled) - CPU Microcode: 0xaa00212 Java Details - OpenJDK Runtime Environment (build 11.0.22+7-post-Ubuntu-0ubuntu223.10.1) Python Details - Micron 7450 Max 3.2TB: Python 3.11.6 Security Details - gather_data_sampling: Not affected + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + reg_file_data_sampling: Not affected + retbleed: Not affected + spec_rstack_overflow: Mitigation of Safe RET + 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 STIBP: always-on RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected
SSD Storage cassandra: Writes clickhouse: 100M Rows Hits Dataset, First Run / Cold Cache clickhouse: 100M Rows Hits Dataset, Second Run clickhouse: 100M Rows Hits Dataset, Third Run cockroach: KV, 50% Reads - 256 cockroach: KV, 60% Reads - 256 fio: Seq Read - IO_uring - Yes - 2MB - 64 - Default Test Directory fio: Seq Write - IO_uring - Yes - 2MB - 1 - Default Test Directory fio: Seq Write - IO_uring - Yes - 2MB - 16 - Default Test Directory fio: Seq Read - IO_uring - Yes - 2MB - 64 - Default Test Directory fio: Seq Write - IO_uring - Yes - 2MB - 1 - Default Test Directory fio: Seq Write - IO_uring - Yes - 2MB - 16 - Default Test Directory mariadb: oltp_read_only - 128 mariadb: oltp_read_write - 128 mariadb: oltp_write_only - 128 mariadb: oltp_point_select - 128 mariadb: oltp_update_index - 128 mariadb: oltp_update_non_index - 128 mysqlslap: 32 mysqlslap: 64 mysqlslap: 128 mysqlslap: 256 mysqlslap: 512 mysqlslap: 1024 mysqlslap: 2048 mysqlslap: 4096 pgbench: 1000 - 1000 - Read Write pgbench: 1000 - 1000 - Read Write - Average Latency sqlite: 1 sqlite: 8 sqlite: 16 Micron 7450 Max 3.2TB Corsair MP700 PRO 2TB Crucial T705 2TB Corsair MP700 2TB Samsung MZWLJ1T9HBJR-00007 252621 329.86 336.49 329.19 101366.5 107941.1 6420 5183 4993 3209 2590 2495 936 470 239 119 43 4 7 41046 24.365 2.219 4.415 7.454 250721 325.58 335.80 340.17 85287.5 94295.7 3433 3372 3373 1715 1685 1685 26432 121810 73634 38300 52864 39323 739 525 330 189 101 46 78 81 22859 43.867 23.093 92.752 123.972 252370 328.03 332.73 338.17 83953.0 92691.1 3562 1704 1122 1780 850 559 21747 46.175 23.773 87.676 133.458 250646 320.33 339.95 330.69 85748.4 92980.0 3432 2004 1093 1715 1000 545 26294 121314 73802 37991 51810 38325 764 532 334 190 101 45 79 81 22868 43.904 23.212 93.244 135.499 257581 323.26 341.89 341.09 106033.3 107353.9 6861 2449 2448 3429 1223 1222 26449 122924 268825 38603 115416 160897 1435 795 421 218 111 40 62 82 29704 33.666 2.525 6.108 OpenBenchmarking.org
Apache Cassandra Test: Writes OpenBenchmarking.org Op/s, More Is Better Apache Cassandra 4.1.3 Test: Writes Samsung MZWLJ1T9HBJR-00007 Micron 7450 Max 3.2TB Crucial T705 2TB Corsair MP700 PRO 2TB Corsair MP700 2TB 60K 120K 180K 240K 300K SE +/- 945.21, N = 3 SE +/- 1354.41, N = 3 SE +/- 856.73, N = 3 SE +/- 415.66, N = 3 SE +/- 1156.33, N = 3 257581 252621 252370 250721 250646
ClickHouse 100M Rows Hits Dataset, First Run / Cold Cache OpenBenchmarking.org Queries Per Minute, Geo Mean, More Is Better ClickHouse 22.12.3.5 100M Rows Hits Dataset, First Run / Cold Cache Micron 7450 Max 3.2TB Crucial T705 2TB Corsair MP700 PRO 2TB Samsung MZWLJ1T9HBJR-00007 Corsair MP700 2TB 70 140 210 280 350 SE +/- 3.71, N = 3 SE +/- 3.65, N = 4 SE +/- 3.47, N = 5 SE +/- 0.47, N = 3 SE +/- 4.03, N = 3 329.86 328.03 325.58 323.26 320.33 MIN: 38.34 / MAX: 5000 MIN: 37.04 / MAX: 3529.41 MIN: 37.81 / MAX: 4000 MIN: 37.93 / MAX: 3750 MIN: 36.97 / MAX: 3333.33
ClickHouse 100M Rows Hits Dataset, Second Run OpenBenchmarking.org Queries Per Minute, Geo Mean, More Is Better ClickHouse 22.12.3.5 100M Rows Hits Dataset, Second Run Samsung MZWLJ1T9HBJR-00007 Corsair MP700 2TB Micron 7450 Max 3.2TB Corsair MP700 PRO 2TB Crucial T705 2TB 70 140 210 280 350 SE +/- 3.94, N = 3 SE +/- 3.15, N = 3 SE +/- 3.46, N = 3 SE +/- 2.74, N = 5 SE +/- 4.87, N = 4 341.89 339.95 336.49 335.80 332.73 MIN: 38.44 / MAX: 5000 MIN: 37.64 / MAX: 4000 MIN: 37.9 / MAX: 3750 MIN: 38.07 / MAX: 3750 MIN: 38.17 / MAX: 3750
ClickHouse 100M Rows Hits Dataset, Third Run OpenBenchmarking.org Queries Per Minute, Geo Mean, More Is Better ClickHouse 22.12.3.5 100M Rows Hits Dataset, Third Run Samsung MZWLJ1T9HBJR-00007 Corsair MP700 PRO 2TB Crucial T705 2TB Corsair MP700 2TB Micron 7450 Max 3.2TB 70 140 210 280 350 SE +/- 1.63, N = 3 SE +/- 2.43, N = 5 SE +/- 2.11, N = 4 SE +/- 2.52, N = 3 SE +/- 2.21, N = 3 341.09 340.17 338.17 330.69 329.19 MIN: 38.36 / MAX: 5000 MIN: 38.27 / MAX: 4000 MIN: 38.14 / MAX: 5454.55 MIN: 37.5 / MAX: 3529.41 MIN: 38.63 / MAX: 3000
CockroachDB Workload: KV, 50% Reads - Concurrency: 256 OpenBenchmarking.org ops/s, More Is Better CockroachDB 22.2 Workload: KV, 50% Reads - Concurrency: 256 Samsung MZWLJ1T9HBJR-00007 Micron 7450 Max 3.2TB Corsair MP700 2TB Corsair MP700 PRO 2TB Crucial T705 2TB 20K 40K 60K 80K 100K SE +/- 828.24, N = 3 SE +/- 1341.10, N = 15 SE +/- 302.48, N = 3 SE +/- 624.14, N = 3 SE +/- 477.68, N = 3 106033.3 101366.5 85748.4 85287.5 83953.0
CockroachDB Workload: KV, 60% Reads - Concurrency: 256 OpenBenchmarking.org ops/s, More Is Better CockroachDB 22.2 Workload: KV, 60% Reads - Concurrency: 256 Micron 7450 Max 3.2TB Samsung MZWLJ1T9HBJR-00007 Corsair MP700 PRO 2TB Corsair MP700 2TB Crucial T705 2TB 20K 40K 60K 80K 100K SE +/- 1417.12, N = 15 SE +/- 1826.76, N = 15 SE +/- 504.72, N = 3 SE +/- 388.03, N = 3 SE +/- 733.23, N = 3 107941.1 107353.9 94295.7 92980.0 92691.1
Flexible IO Tester Type: Sequential Read - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 64 - Disk Target: Default Test Directory OpenBenchmarking.org MB/s, More Is Better Flexible IO Tester 3.36 Type: Sequential Read - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 64 - Disk Target: Default Test Directory Samsung MZWLJ1T9HBJR-00007 Micron 7450 Max 3.2TB Crucial T705 2TB Corsair MP700 PRO 2TB Corsair MP700 2TB 1500 3000 4500 6000 7500 SE +/- 55.19, N = 3 SE +/- 9.45, N = 3 SE +/- 1.45, N = 3 SE +/- 0.00, N = 3 SE +/- 0.00, N = 3 6861 6549 3562 3433 3432 1. (CC) gcc options: -rdynamic -ltcmalloc -ll -lnuma -lz -lm -laio -lpthread -ldl -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -march=native
Flexible IO Tester Type: Sequential Write - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 1 - Disk Target: Default Test Directory OpenBenchmarking.org MB/s, More Is Better Flexible IO Tester 3.36 Type: Sequential Write - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 1 - Disk Target: Default Test Directory Micron 7450 Max 3.2TB Corsair MP700 PRO 2TB Samsung MZWLJ1T9HBJR-00007 Corsair MP700 2TB Crucial T705 2TB 1100 2200 3300 4400 5500 SE +/- 4.81, N = 3 SE +/- 0.33, N = 3 SE +/- 0.88, N = 3 SE +/- 171.84, N = 15 SE +/- 130.58, N = 15 5183 3374 2449 2004 1704 1. (CC) gcc options: -rdynamic -ltcmalloc -ll -lnuma -lz -lm -laio -lpthread -ldl -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -march=native
Flexible IO Tester Type: Sequential Write - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 16 - Disk Target: Default Test Directory OpenBenchmarking.org MB/s, More Is Better Flexible IO Tester 3.36 Type: Sequential Write - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 16 - Disk Target: Default Test Directory Micron 7450 Max 3.2TB Corsair MP700 PRO 2TB Samsung MZWLJ1T9HBJR-00007 Crucial T705 2TB Corsair MP700 2TB 1100 2200 3300 4400 5500 SE +/- 11.98, N = 3 SE +/- 0.00, N = 3 SE +/- 1.53, N = 3 SE +/- 143.79, N = 13 SE +/- 77.06, N = 15 4993 3373 2448 1122 1093 1. (CC) gcc options: -rdynamic -ltcmalloc -ll -lnuma -lz -lm -laio -lpthread -ldl -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -march=native
Flexible IO Tester Type: Sequential Read - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 64 - Disk Target: Default Test Directory OpenBenchmarking.org IOPS, More Is Better Flexible IO Tester 3.36 Type: Sequential Read - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 64 - Disk Target: Default Test Directory Samsung MZWLJ1T9HBJR-00007 Micron 7450 Max 3.2TB Crucial T705 2TB Corsair MP700 PRO 2TB Corsair MP700 2TB 700 1400 2100 2800 3500 SE +/- 27.45, N = 3 SE +/- 1.86, N = 3 SE +/- 0.88, N = 3 SE +/- 0.00, N = 3 SE +/- 0.00, N = 3 3429 3209 1780 1715 1715 1. (CC) gcc options: -rdynamic -ltcmalloc -ll -lnuma -lz -lm -laio -lpthread -ldl -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -march=native
Flexible IO Tester Type: Sequential Write - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 1 - Disk Target: Default Test Directory OpenBenchmarking.org IOPS, More Is Better Flexible IO Tester 3.36 Type: Sequential Write - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 1 - Disk Target: Default Test Directory Micron 7450 Max 3.2TB Corsair MP700 PRO 2TB Samsung MZWLJ1T9HBJR-00007 Corsair MP700 2TB Crucial T705 2TB 600 1200 1800 2400 3000 SE +/- 2.40, N = 3 SE +/- 0.33, N = 3 SE +/- 0.58, N = 3 SE +/- 85.95, N = 15 SE +/- 65.28, N = 15 2590 1685 1223 1000 850 1. (CC) gcc options: -rdynamic -ltcmalloc -ll -lnuma -lz -lm -laio -lpthread -ldl -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -march=native
Flexible IO Tester Type: Sequential Write - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 16 - Disk Target: Default Test Directory OpenBenchmarking.org IOPS, More Is Better Flexible IO Tester 3.36 Type: Sequential Write - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 16 - Disk Target: Default Test Directory Micron 7450 Max 3.2TB Corsair MP700 PRO 2TB Samsung MZWLJ1T9HBJR-00007 Crucial T705 2TB Corsair MP700 2TB 500 1000 1500 2000 2500 SE +/- 5.86, N = 3 SE +/- 0.00, N = 3 SE +/- 0.67, N = 3 SE +/- 71.93, N = 13 SE +/- 38.56, N = 15 2495 1685 1222 559 545 1. (CC) gcc options: -rdynamic -ltcmalloc -ll -lnuma -lz -lm -laio -lpthread -ldl -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -march=native
MariaDB Test: oltp_read_only - Threads: 128 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_read_only - Threads: 128 Samsung MZWLJ1T9HBJR-00007 Corsair MP700 PRO 2TB Corsair MP700 2TB 6K 12K 18K 24K 30K SE +/- 23.88, N = 3 SE +/- 20.46, N = 3 SE +/- 9.76, N = 3 26449 26432 26294 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_read_write - Threads: 128 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_read_write - Threads: 128 Samsung MZWLJ1T9HBJR-00007 Corsair MP700 PRO 2TB Corsair MP700 2TB 30K 60K 90K 120K 150K SE +/- 63.58, N = 3 SE +/- 152.21, N = 3 SE +/- 173.52, N = 3 122924 121810 121314 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_write_only - Threads: 128 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_write_only - Threads: 128 Samsung MZWLJ1T9HBJR-00007 Corsair MP700 2TB Corsair MP700 PRO 2TB 60K 120K 180K 240K 300K SE +/- 222.32, N = 3 SE +/- 566.85, N = 3 SE +/- 558.10, N = 3 268825 73802 73634 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_point_select - Threads: 128 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_point_select - Threads: 128 Samsung MZWLJ1T9HBJR-00007 Corsair MP700 PRO 2TB Corsair MP700 2TB 8K 16K 24K 32K 40K SE +/- 23.41, N = 3 SE +/- 26.99, N = 3 SE +/- 24.16, N = 3 38603 38300 37991 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_update_index - Threads: 128 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_update_index - Threads: 128 Samsung MZWLJ1T9HBJR-00007 Corsair MP700 PRO 2TB Corsair MP700 2TB 20K 40K 60K 80K 100K SE +/- 80.60, N = 3 SE +/- 3430.94, N = 6 SE +/- 2315.37, N = 9 115416 52864 51810 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_update_non_index - Threads: 128 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_update_non_index - Threads: 128 Samsung MZWLJ1T9HBJR-00007 Corsair MP700 PRO 2TB Corsair MP700 2TB 30K 60K 90K 120K 150K SE +/- 91.45, N = 3 SE +/- 2173.20, N = 9 SE +/- 2550.78, N = 9 160897 39323 38325 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB mariadb-slap Clients: 32 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB mariadb-slap 11.5 Clients: 32 Samsung MZWLJ1T9HBJR-00007 Micron 7450 Max 3.2TB Corsair MP700 2TB Corsair MP700 PRO 2TB 300 600 900 1200 1500 SE +/- 2.47, N = 3 SE +/- 2.78, N = 3 SE +/- 0.39, N = 3 SE +/- 9.35, N = 12 1435 936 764 739 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB mariadb-slap Clients: 64 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB mariadb-slap 11.5 Clients: 64 Samsung MZWLJ1T9HBJR-00007 Corsair MP700 2TB Corsair MP700 PRO 2TB Micron 7450 Max 3.2TB 200 400 600 800 1000 SE +/- 0.56, N = 3 SE +/- 0.34, N = 3 SE +/- 0.91, N = 3 SE +/- 0.41, N = 3 795 532 525 470 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB mariadb-slap Clients: 128 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB mariadb-slap 11.5 Clients: 128 Samsung MZWLJ1T9HBJR-00007 Corsair MP700 2TB Corsair MP700 PRO 2TB Micron 7450 Max 3.2TB 90 180 270 360 450 SE +/- 0.18, N = 3 SE +/- 0.04, N = 3 SE +/- 0.32, N = 3 SE +/- 0.52, N = 3 421 334 330 239 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB mariadb-slap Clients: 256 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB mariadb-slap 11.5 Clients: 256 Samsung MZWLJ1T9HBJR-00007 Corsair MP700 2TB Corsair MP700 PRO 2TB Micron 7450 Max 3.2TB 50 100 150 200 250 SE +/- 0.14, N = 3 SE +/- 0.21, N = 3 SE +/- 0.09, N = 3 SE +/- 0.50, N = 3 218 190 189 119 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB mariadb-slap Clients: 512 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB mariadb-slap 11.5 Clients: 512 Samsung MZWLJ1T9HBJR-00007 Corsair MP700 PRO 2TB Corsair MP700 2TB Micron 7450 Max 3.2TB 20 40 60 80 100 SE +/- 0.17, N = 3 SE +/- 0.04, N = 3 SE +/- 0.14, N = 3 SE +/- 0.17, N = 3 111 101 101 43 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB mariadb-slap Clients: 1024 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB mariadb-slap 11.5 Clients: 1024 Corsair MP700 PRO 2TB Corsair MP700 2TB Samsung MZWLJ1T9HBJR-00007 Micron 7450 Max 3.2TB 10 20 30 40 50 SE +/- 0.47, N = 9 SE +/- 0.53, N = 9 SE +/- 0.13, N = 3 SE +/- 0.05, N = 3 46 45 40 4 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB mariadb-slap Clients: 2048 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB mariadb-slap 11.5 Clients: 2048 Corsair MP700 2TB Corsair MP700 PRO 2TB Samsung MZWLJ1T9HBJR-00007 Micron 7450 Max 3.2TB 20 40 60 80 100 SE +/- 0.74, N = 9 SE +/- 0.88, N = 3 SE +/- 0.85, N = 3 SE +/- 0.38, N = 3 79 78 62 7 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB mariadb-slap Clients: 4096 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB mariadb-slap 11.5 Clients: 4096 Samsung MZWLJ1T9HBJR-00007 Corsair MP700 PRO 2TB Corsair MP700 2TB 20 40 60 80 100 SE +/- 0.95, N = 3 SE +/- 0.73, N = 9 SE +/- 0.57, N = 3 82 81 81 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
PostgreSQL Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write OpenBenchmarking.org TPS, More Is Better PostgreSQL 16 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write Micron 7450 Max 3.2TB Samsung MZWLJ1T9HBJR-00007 Corsair MP700 2TB Corsair MP700 PRO 2TB Crucial T705 2TB 9K 18K 27K 36K 45K SE +/- 310.04, N = 3 SE +/- 77.34, N = 3 SE +/- 446.86, N = 12 SE +/- 371.60, N = 12 SE +/- 448.34, N = 12 41046 29704 22868 22859 21747 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
PostgreSQL Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write - Average Latency OpenBenchmarking.org ms, Fewer Is Better PostgreSQL 16 Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write - Average Latency Micron 7450 Max 3.2TB Samsung MZWLJ1T9HBJR-00007 Corsair MP700 PRO 2TB Corsair MP700 2TB Crucial T705 2TB 10 20 30 40 50 SE +/- 0.18, N = 3 SE +/- 0.09, N = 3 SE +/- 0.68, N = 12 SE +/- 0.82, N = 12 SE +/- 0.85, N = 12 24.37 33.67 43.87 43.90 46.18 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
SQLite Threads / Copies: 1 OpenBenchmarking.org Seconds, Fewer Is Better SQLite 3.41.2 Threads / Copies: 1 Micron 7450 Max 3.2TB Corsair MP700 PRO 2TB Corsair MP700 2TB Crucial T705 2TB 6 12 18 24 30 SE +/- 0.000, N = 3 SE +/- 0.186, N = 3 SE +/- 0.080, N = 3 SE +/- 0.220, N = 3 2.219 23.093 23.212 23.773 1. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm
SQLite Threads / Copies: 8 OpenBenchmarking.org Seconds, Fewer Is Better SQLite 3.41.2 Threads / Copies: 8 Samsung MZWLJ1T9HBJR-00007 Micron 7450 Max 3.2TB Crucial T705 2TB Corsair MP700 PRO 2TB Corsair MP700 2TB 20 40 60 80 100 SE +/- 0.087, N = 12 SE +/- 0.036, N = 3 SE +/- 0.737, N = 3 SE +/- 0.843, N = 3 SE +/- 0.864, N = 3 2.525 4.415 87.676 92.752 93.244 1. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm
SQLite Threads / Copies: 16 OpenBenchmarking.org Seconds, Fewer Is Better SQLite 3.41.2 Threads / Copies: 16 Samsung MZWLJ1T9HBJR-00007 Micron 7450 Max 3.2TB Corsair MP700 PRO 2TB Crucial T705 2TB Corsair MP700 2TB 30 60 90 120 150 SE +/- 0.371, N = 12 SE +/- 0.031, N = 3 SE +/- 1.278, N = 12 SE +/- 1.241, N = 3 SE +/- 0.565, N = 3 6.108 7.454 123.972 133.458 135.499 1. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm
Phoronix Test Suite v10.8.4