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&sro .
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 Corsair MP700 2TB Corsair MP700 PRO 2TB Crucial T705 2TB Micron 7450 Max 3.2TB Samsung MZWLJ1T9HBJR-00007 60K 120K 180K 240K 300K SE +/- 1156.33, N = 3 SE +/- 415.66, N = 3 SE +/- 856.73, N = 3 SE +/- 1354.41, N = 3 SE +/- 945.21, N = 3 250646 250721 252370 252621 257581
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 Corsair MP700 2TB Corsair MP700 PRO 2TB Crucial T705 2TB Micron 7450 Max 3.2TB Samsung MZWLJ1T9HBJR-00007 70 140 210 280 350 SE +/- 4.03, N = 3 SE +/- 3.47, N = 5 SE +/- 3.65, N = 4 SE +/- 3.71, N = 3 SE +/- 0.47, N = 3 320.33 325.58 328.03 329.86 323.26 MIN: 36.97 / MAX: 3333.33 MIN: 37.81 / MAX: 4000 MIN: 37.04 / MAX: 3529.41 MIN: 38.34 / MAX: 5000 MIN: 37.93 / MAX: 3750
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 Corsair MP700 2TB Corsair MP700 PRO 2TB Crucial T705 2TB Micron 7450 Max 3.2TB Samsung MZWLJ1T9HBJR-00007 70 140 210 280 350 SE +/- 3.15, N = 3 SE +/- 2.74, N = 5 SE +/- 4.87, N = 4 SE +/- 3.46, N = 3 SE +/- 3.94, N = 3 339.95 335.80 332.73 336.49 341.89 MIN: 37.64 / MAX: 4000 MIN: 38.07 / MAX: 3750 MIN: 38.17 / MAX: 3750 MIN: 37.9 / MAX: 3750 MIN: 38.44 / MAX: 5000
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 Corsair MP700 2TB Corsair MP700 PRO 2TB Crucial T705 2TB Micron 7450 Max 3.2TB Samsung MZWLJ1T9HBJR-00007 70 140 210 280 350 SE +/- 2.52, N = 3 SE +/- 2.43, N = 5 SE +/- 2.11, N = 4 SE +/- 2.21, N = 3 SE +/- 1.63, N = 3 330.69 340.17 338.17 329.19 341.09 MIN: 37.5 / MAX: 3529.41 MIN: 38.27 / MAX: 4000 MIN: 38.14 / MAX: 5454.55 MIN: 38.63 / MAX: 3000 MIN: 38.36 / MAX: 5000
CockroachDB Workload: KV, 50% Reads - Concurrency: 256 OpenBenchmarking.org ops/s, More Is Better CockroachDB 22.2 Workload: KV, 50% Reads - Concurrency: 256 Corsair MP700 2TB Corsair MP700 PRO 2TB Crucial T705 2TB Micron 7450 Max 3.2TB Samsung MZWLJ1T9HBJR-00007 20K 40K 60K 80K 100K SE +/- 302.48, N = 3 SE +/- 624.14, N = 3 SE +/- 477.68, N = 3 SE +/- 1341.10, N = 15 SE +/- 828.24, N = 3 85748.4 85287.5 83953.0 101366.5 106033.3
CockroachDB Workload: KV, 60% Reads - Concurrency: 256 OpenBenchmarking.org ops/s, More Is Better CockroachDB 22.2 Workload: KV, 60% Reads - Concurrency: 256 Corsair MP700 2TB Corsair MP700 PRO 2TB Crucial T705 2TB Micron 7450 Max 3.2TB Samsung MZWLJ1T9HBJR-00007 20K 40K 60K 80K 100K SE +/- 388.03, N = 3 SE +/- 504.72, N = 3 SE +/- 733.23, N = 3 SE +/- 1417.12, N = 15 SE +/- 1826.76, N = 15 92980.0 94295.7 92691.1 107941.1 107353.9
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 Corsair MP700 2TB Corsair MP700 PRO 2TB Crucial T705 2TB Micron 7450 Max 3.2TB Samsung MZWLJ1T9HBJR-00007 1500 3000 4500 6000 7500 SE +/- 0.00, N = 3 SE +/- 0.00, N = 3 SE +/- 1.45, N = 3 SE +/- 3.84, N = 3 SE +/- 55.19, N = 3 3432 3417 3562 6420 6861 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 Corsair MP700 2TB Corsair MP700 PRO 2TB Crucial T705 2TB Micron 7450 Max 3.2TB Samsung MZWLJ1T9HBJR-00007 1100 2200 3300 4400 5500 SE +/- 171.84, N = 15 SE +/- 0.67, N = 3 SE +/- 130.58, N = 15 SE +/- 6.74, N = 3 SE +/- 0.88, N = 3 2004 3372 1704 4952 2449 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 Corsair MP700 2TB Corsair MP700 PRO 2TB Crucial T705 2TB Micron 7450 Max 3.2TB Samsung MZWLJ1T9HBJR-00007 1100 2200 3300 4400 5500 SE +/- 77.06, N = 15 SE +/- 16.76, N = 3 SE +/- 143.79, N = 13 SE +/- 9.21, N = 3 SE +/- 1.53, N = 3 1093 3341 1122 4990 2448 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 Corsair MP700 2TB Corsair MP700 PRO 2TB Crucial T705 2TB Micron 7450 Max 3.2TB Samsung MZWLJ1T9HBJR-00007 700 1400 2100 2800 3500 SE +/- 0.00, N = 3 SE +/- 0.00, N = 3 SE +/- 0.88, N = 3 SE +/- 1.86, N = 3 SE +/- 27.45, N = 3 1715 1715 1780 3209 3429 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 Corsair MP700 2TB Corsair MP700 PRO 2TB Crucial T705 2TB Micron 7450 Max 3.2TB Samsung MZWLJ1T9HBJR-00007 600 1200 1800 2400 3000 SE +/- 85.95, N = 15 SE +/- 0.33, N = 3 SE +/- 65.28, N = 15 SE +/- 2.40, N = 3 SE +/- 0.58, N = 3 1000 1685 850 2590 1223 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 Corsair MP700 2TB Corsair MP700 PRO 2TB Crucial T705 2TB Micron 7450 Max 3.2TB Samsung MZWLJ1T9HBJR-00007 500 1000 1500 2000 2500 SE +/- 38.56, N = 15 SE +/- 0.00, N = 3 SE +/- 71.93, N = 13 SE +/- 5.86, N = 3 SE +/- 0.67, N = 3 545 1685 559 2495 1222 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 Corsair MP700 2TB Corsair MP700 PRO 2TB Samsung MZWLJ1T9HBJR-00007 6K 12K 18K 24K 30K SE +/- 9.76, N = 3 SE +/- 20.46, N = 3 SE +/- 23.88, N = 3 26294 26432 26449 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 Corsair MP700 2TB Corsair MP700 PRO 2TB Samsung MZWLJ1T9HBJR-00007 30K 60K 90K 120K 150K SE +/- 173.52, N = 3 SE +/- 152.21, N = 3 SE +/- 63.58, N = 3 121314 121810 122924 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 Corsair MP700 2TB Corsair MP700 PRO 2TB Samsung MZWLJ1T9HBJR-00007 60K 120K 180K 240K 300K SE +/- 566.85, N = 3 SE +/- 558.10, N = 3 SE +/- 222.32, N = 3 73802 73634 268825 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 Corsair MP700 2TB Corsair MP700 PRO 2TB Samsung MZWLJ1T9HBJR-00007 8K 16K 24K 32K 40K SE +/- 24.16, N = 3 SE +/- 26.99, N = 3 SE +/- 23.41, N = 3 37991 38300 38603 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 Corsair MP700 2TB Corsair MP700 PRO 2TB Samsung MZWLJ1T9HBJR-00007 20K 40K 60K 80K 100K SE +/- 2315.37, N = 9 SE +/- 3430.94, N = 6 SE +/- 80.60, N = 3 51810 52864 115416 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 Corsair MP700 2TB Corsair MP700 PRO 2TB Samsung MZWLJ1T9HBJR-00007 30K 60K 90K 120K 150K SE +/- 2550.78, N = 9 SE +/- 2173.20, N = 9 SE +/- 91.45, N = 3 38325 39323 160897 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 Corsair MP700 2TB Corsair MP700 PRO 2TB Micron 7450 Max 3.2TB Samsung MZWLJ1T9HBJR-00007 300 600 900 1200 1500 SE +/- 0.39, N = 3 SE +/- 9.35, N = 12 SE +/- 2.78, N = 3 SE +/- 2.47, N = 3 764 739 936 1435 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 Corsair MP700 2TB Corsair MP700 PRO 2TB Micron 7450 Max 3.2TB Samsung MZWLJ1T9HBJR-00007 200 400 600 800 1000 SE +/- 0.34, N = 3 SE +/- 0.91, N = 3 SE +/- 0.41, N = 3 SE +/- 0.56, N = 3 532 525 470 795 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 Corsair MP700 2TB Corsair MP700 PRO 2TB Micron 7450 Max 3.2TB Samsung MZWLJ1T9HBJR-00007 90 180 270 360 450 SE +/- 0.04, N = 3 SE +/- 0.32, N = 3 SE +/- 0.52, N = 3 SE +/- 0.18, N = 3 334 330 239 421 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 Corsair MP700 2TB Corsair MP700 PRO 2TB Micron 7450 Max 3.2TB Samsung MZWLJ1T9HBJR-00007 50 100 150 200 250 SE +/- 0.21, N = 3 SE +/- 0.09, N = 3 SE +/- 0.50, N = 3 SE +/- 0.14, N = 3 190 189 119 218 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 Corsair MP700 2TB Corsair MP700 PRO 2TB Micron 7450 Max 3.2TB Samsung MZWLJ1T9HBJR-00007 20 40 60 80 100 SE +/- 0.14, N = 3 SE +/- 0.04, N = 3 SE +/- 0.17, N = 3 SE +/- 0.17, N = 3 101 101 43 111 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 2TB Corsair MP700 PRO 2TB Micron 7450 Max 3.2TB Samsung MZWLJ1T9HBJR-00007 10 20 30 40 50 SE +/- 0.53, N = 9 SE +/- 0.47, N = 9 SE +/- 0.05, N = 3 SE +/- 0.13, N = 3 45 46 4 40 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 Micron 7450 Max 3.2TB Samsung MZWLJ1T9HBJR-00007 20 40 60 80 100 SE +/- 0.74, N = 9 SE +/- 0.88, N = 3 SE +/- 0.38, N = 3 SE +/- 0.85, N = 3 79 78 7 62 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 Corsair MP700 2TB Corsair MP700 PRO 2TB Samsung MZWLJ1T9HBJR-00007 20 40 60 80 100 SE +/- 0.57, N = 3 SE +/- 0.73, N = 9 SE +/- 0.95, N = 3 81 81 82 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 Corsair MP700 2TB Corsair MP700 PRO 2TB Crucial T705 2TB Micron 7450 Max 3.2TB Samsung MZWLJ1T9HBJR-00007 9K 18K 27K 36K 45K SE +/- 446.86, N = 12 SE +/- 371.60, N = 12 SE +/- 448.34, N = 12 SE +/- 310.04, N = 3 SE +/- 77.34, N = 3 22868 22859 21747 41046 29704 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 Corsair MP700 2TB Corsair MP700 PRO 2TB Crucial T705 2TB Micron 7450 Max 3.2TB Samsung MZWLJ1T9HBJR-00007 10 20 30 40 50 SE +/- 0.82, N = 12 SE +/- 0.68, N = 12 SE +/- 0.85, N = 12 SE +/- 0.18, N = 3 SE +/- 0.09, N = 3 43.90 43.87 46.18 24.37 33.67 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 Corsair MP700 2TB Corsair MP700 PRO 2TB Crucial T705 2TB Micron 7450 Max 3.2TB 6 12 18 24 30 SE +/- 0.080, N = 3 SE +/- 0.186, N = 3 SE +/- 0.220, N = 3 SE +/- 0.000, N = 3 23.212 23.093 23.773 2.219 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 Corsair MP700 2TB Corsair MP700 PRO 2TB Crucial T705 2TB Micron 7450 Max 3.2TB Samsung MZWLJ1T9HBJR-00007 20 40 60 80 100 SE +/- 0.864, N = 3 SE +/- 0.843, N = 3 SE +/- 0.737, N = 3 SE +/- 0.036, N = 3 SE +/- 0.087, N = 12 93.244 92.752 87.676 4.415 2.525 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 Corsair MP700 2TB Corsair MP700 PRO 2TB Crucial T705 2TB Micron 7450 Max 3.2TB Samsung MZWLJ1T9HBJR-00007 30 60 90 120 150 SE +/- 0.565, N = 3 SE +/- 1.278, N = 12 SE +/- 1.241, N = 3 SE +/- 0.031, N = 3 SE +/- 0.371, N = 12 135.499 123.972 133.458 7.454 6.108 1. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm
Phoronix Test Suite v10.8.4