SSD Storage

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
Jump To Table - Results

View

Do Not Show Noisy Results
Do Not Show Results With Incomplete Data
Do Not Show Results With Little Change/Spread
List Notable Results
Show Result Confidence Charts
Allow Limiting Results To Certain Suite(s)

Statistics

Show Overall Harmonic Mean(s)
Show Overall Geometric Mean
Show Wins / Losses Counts (Pie Chart)
Normalize Results
Remove Outliers Before Calculating Averages

Graph Settings

Force Line Graphs Where Applicable
Convert To Scalar Where Applicable
Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Highlight
Result
Toggle/Hide
Result
Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
Micron 7450 Max 3.2TB
March 21
  1 Day, 12 Hours, 42 Minutes
Corsair MP700 PRO 2TB
March 22
  18 Hours, 16 Minutes
Crucial T705 2TB
March 22
  4 Hours, 14 Minutes
Corsair MP700 2TB
March 23
  18 Hours, 46 Minutes
Samsung MZWLJ1T9HBJR-00007
April 01
  9 Hours, 51 Minutes
Invert Behavior (Only Show Selected Data)
  17 Hours, 34 Minutes

Only show results where is faster than
Only show results matching title/arguments (delimit multiple options with a comma):
Do not show results matching title/arguments (delimit multiple options with a comma):


SSD StorageOpenBenchmarking.orgPhoronix Test SuiteAMD EPYC 8534P 64-Core @ 2.30GHz (64 Cores / 128 Threads)AMD Cinnabar (RCB1009C BIOS)AMD Device 14a46 x 32GB DRAM-4800MT/s Samsung M321R4GA0BB0-CQKMG3201GB Micron_7450_MTFDKCB3T2TFS3201GB Micron_7450_MTFDKCB3T2TFS + 2000GB Corsair MP700 PRO3201GB Micron_7450_MTFDKCB3T2TFS + 2000GB CT2000T705SSD53201GB Micron_7450_MTFDKCB3T2TFS + 2000GB Corsair MP7003201GB Micron_7450_MTFDKCB3T2TFS + 2 x 1920GB SAMSUNG MZWLJ1T9HBJR-00007ASPEED2 x Broadcom NetXtreme BCM5720 PCIeUbuntu 23.106.8.1-060801-generic (x86_64)GNOME Shell 45.2X Server 1.21.1.7GCC 13.2.0ext41920x1200ProcessorMotherboardChipsetMemoryDisksGraphicsNetworkOSKernelDesktopDisplay ServerCompilerFile-SystemScreen ResolutionSSD Storage BenchmarksSystem Logs- Transparent Huge Pages: madvise- --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 - 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- Scaling Governor: acpi-cpufreq performance (Boost: Enabled) - CPU Microcode: 0xaa00212 - OpenJDK Runtime Environment (build 11.0.22+7-post-Ubuntu-0ubuntu223.10.1)- Micron 7450 Max 3.2TB: Python 3.11.6- 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

Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-00007Logarithmic Result OverviewPhoronix Test SuiteFlexible IO TesterSQLitePostgreSQLCockroachDBApache CassandraClickHouse

SSD Storagefio: Seq Read - IO_uring - Yes - 2MB - 64 - Default Test Directoryfio: Seq Write - IO_uring - Yes - 2MB - 1 - Default Test Directoryfio: Seq Write - IO_uring - Yes - 2MB - 16 - Default Test Directoryfio: Seq Read - IO_uring - Yes - 2MB - 64 - Default Test Directoryfio: Seq Write - IO_uring - Yes - 2MB - 1 - Default Test Directoryfio: Seq Write - IO_uring - Yes - 2MB - 16 - Default Test Directorycassandra: Writescockroach: KV, 50% Reads - 256cockroach: KV, 60% Reads - 256clickhouse: 100M Rows Hits Dataset, First Run / Cold Cacheclickhouse: 100M Rows Hits Dataset, Second Runclickhouse: 100M Rows Hits Dataset, Third Runmysqlslap: 32mysqlslap: 64mysqlslap: 128mysqlslap: 256mysqlslap: 512mysqlslap: 1024mysqlslap: 2048mysqlslap: 4096mariadb: oltp_read_only - 128mariadb: oltp_read_write - 128mariadb: oltp_write_only - 128mariadb: oltp_point_select - 128mariadb: oltp_update_index - 128mariadb: oltp_update_non_index - 128pgbench: 1000 - 1000 - Read Writepgbench: 1000 - 1000 - Read Write - Average Latencysqlite: 1sqlite: 8sqlite: 16Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-00007320925902495642051834993252621101366.5107941.1329.86336.49329.1993647023911943474104624.3652.2194.4157.45417151685168534333372337325072185287.594295.7325.58335.80340.1773952533018910146788126432121810736343830052864393232285943.86723.09392.752123.972178085055935621704112225237083953.092691.1328.03332.73338.172174746.17523.77387.676133.4581715100054534322004109325064685748.492980.0320.33339.95330.6976453233419010145798126294121314738023799151810383252286843.90423.21293.244135.499342912231222686124492448257581106033.3107353.9323.26341.89341.09143579542121811140628226449122924268825386031154161608972970433.6662.5256.108OpenBenchmarking.org

Flexible IO Tester

FIO, the Flexible I/O Tester, is an advanced Linux disk benchmark supporting multiple I/O engines and a wealth of options. FIO was written by Jens Axboe for testing of the Linux I/O subsystem and schedulers. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgIOPS, More Is BetterFlexible IO Tester 3.36Type: Sequential Read - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 64 - Disk Target: Default Test DirectorySamsung MZWLJ1T9HBJR-00007Micron 7450 Max 3.2TBCrucial T705 2TBCorsair MP700 PRO 2TBCorsair MP700 2TB7001400210028003500SE +/- 27.45, N = 3SE +/- 1.86, N = 3SE +/- 0.88, N = 3SE +/- 0.00, N = 3SE +/- 0.00, N = 3342932091780171517151. (CC) gcc options: -rdynamic -ltcmalloc -ll -lnuma -lz -lm -laio -lpthread -ldl -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -march=native

OpenBenchmarking.orgIOPS, More Is BetterFlexible IO Tester 3.36Type: Sequential Write - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 1 - Disk Target: Default Test DirectorySamsung MZWLJ1T9HBJR-00007Micron 7450 Max 3.2TBCrucial T705 2TBCorsair MP700 PRO 2TBCorsair MP700 2TB6001200180024003000SE +/- 0.58, N = 3SE +/- 2.40, N = 3SE +/- 65.28, N = 15SE +/- 0.33, N = 3SE +/- 85.95, N = 1512232590850168510001. (CC) gcc options: -rdynamic -ltcmalloc -ll -lnuma -lz -lm -laio -lpthread -ldl -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -march=native

OpenBenchmarking.orgIOPS, More Is BetterFlexible IO Tester 3.36Type: Sequential Write - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 16 - Disk Target: Default Test DirectorySamsung MZWLJ1T9HBJR-00007Micron 7450 Max 3.2TBCrucial T705 2TBCorsair MP700 PRO 2TBCorsair MP700 2TB5001000150020002500SE +/- 0.67, N = 3SE +/- 5.86, N = 3SE +/- 71.93, N = 13SE +/- 0.00, N = 3SE +/- 38.56, N = 151222249555916855451. (CC) gcc options: -rdynamic -ltcmalloc -ll -lnuma -lz -lm -laio -lpthread -ldl -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -march=native

OpenBenchmarking.orgMB/s, More Is BetterFlexible IO Tester 3.36Type: Sequential Read - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 64 - Disk Target: Default Test DirectorySamsung MZWLJ1T9HBJR-00007Micron 7450 Max 3.2TBCrucial T705 2TBCorsair MP700 PRO 2TBCorsair MP700 2TB15003000450060007500SE +/- 55.19, N = 3SE +/- 9.45, N = 3SE +/- 1.45, N = 3SE +/- 0.00, N = 3SE +/- 0.00, N = 3686165493562343334321. (CC) gcc options: -rdynamic -ltcmalloc -ll -lnuma -lz -lm -laio -lpthread -ldl -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -march=native

OpenBenchmarking.orgMB/s, More Is BetterFlexible IO Tester 3.36Type: Sequential Write - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 1 - Disk Target: Default Test DirectorySamsung MZWLJ1T9HBJR-00007Micron 7450 Max 3.2TBCrucial T705 2TBCorsair MP700 PRO 2TBCorsair MP700 2TB11002200330044005500SE +/- 0.88, N = 3SE +/- 4.81, N = 3SE +/- 130.58, N = 15SE +/- 0.33, N = 3SE +/- 171.84, N = 15244951831704337420041. (CC) gcc options: -rdynamic -ltcmalloc -ll -lnuma -lz -lm -laio -lpthread -ldl -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -march=native

OpenBenchmarking.orgMB/s, More Is BetterFlexible IO Tester 3.36Type: Sequential Write - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 16 - Disk Target: Default Test DirectorySamsung MZWLJ1T9HBJR-00007Micron 7450 Max 3.2TBCrucial T705 2TBCorsair MP700 PRO 2TBCorsair MP700 2TB11002200330044005500SE +/- 1.53, N = 3SE +/- 11.98, N = 3SE +/- 143.79, N = 13SE +/- 0.00, N = 3SE +/- 77.06, N = 15244849931122337310931. (CC) gcc options: -rdynamic -ltcmalloc -ll -lnuma -lz -lm -laio -lpthread -ldl -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -march=native

Apache Cassandra

This is a benchmark of the Apache Cassandra NoSQL database management system making use of cassandra-stress. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgOp/s, More Is BetterApache Cassandra 4.1.3Test: WritesSamsung MZWLJ1T9HBJR-00007Micron 7450 Max 3.2TBCrucial T705 2TBCorsair MP700 PRO 2TBCorsair MP700 2TB60K120K180K240K300KSE +/- 945.21, N = 3SE +/- 1354.41, N = 3SE +/- 856.73, N = 3SE +/- 415.66, N = 3SE +/- 1156.33, N = 3257581252621252370250721250646

CockroachDB

CockroachDB is a cloud-native, distributed SQL database for data intensive applications. This test profile uses a server-less CockroachDB configuration to test various Coackroach workloads on the local host with a single node. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgops/s, More Is BetterCockroachDB 22.2Workload: KV, 50% Reads - Concurrency: 256Samsung MZWLJ1T9HBJR-00007Micron 7450 Max 3.2TBCrucial T705 2TBCorsair MP700 PRO 2TBCorsair MP700 2TB20K40K60K80K100KSE +/- 828.24, N = 3SE +/- 1341.10, N = 15SE +/- 477.68, N = 3SE +/- 624.14, N = 3SE +/- 302.48, N = 3106033.3101366.583953.085287.585748.4

OpenBenchmarking.orgops/s, More Is BetterCockroachDB 22.2Workload: KV, 60% Reads - Concurrency: 256Samsung MZWLJ1T9HBJR-00007Micron 7450 Max 3.2TBCrucial T705 2TBCorsair MP700 PRO 2TBCorsair MP700 2TB20K40K60K80K100KSE +/- 1826.76, N = 15SE +/- 1417.12, N = 15SE +/- 733.23, N = 3SE +/- 504.72, N = 3SE +/- 388.03, N = 3107353.9107941.192691.194295.792980.0

ClickHouse

ClickHouse is an open-source, high performance OLAP data management system. This test profile uses ClickHouse's standard benchmark recommendations per https://clickhouse.com/docs/en/operations/performance-test/ / https://github.com/ClickHouse/ClickBench/tree/main/clickhouse with the 100 million rows web analytics dataset. The reported value is the query processing time using the geometric mean of all separate queries performed as an aggregate. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse 22.12.3.5100M Rows Hits Dataset, First Run / Cold CacheSamsung MZWLJ1T9HBJR-00007Micron 7450 Max 3.2TBCrucial T705 2TBCorsair MP700 PRO 2TBCorsair MP700 2TB70140210280350SE +/- 0.47, N = 3SE +/- 3.71, N = 3SE +/- 3.65, N = 4SE +/- 3.47, N = 5SE +/- 4.03, N = 3323.26329.86328.03325.58320.33MIN: 37.93 / MAX: 3750MIN: 38.34 / MAX: 5000MIN: 37.04 / MAX: 3529.41MIN: 37.81 / MAX: 4000MIN: 36.97 / MAX: 3333.33

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse 22.12.3.5100M Rows Hits Dataset, Second RunSamsung MZWLJ1T9HBJR-00007Micron 7450 Max 3.2TBCrucial T705 2TBCorsair MP700 PRO 2TBCorsair MP700 2TB70140210280350SE +/- 3.94, N = 3SE +/- 3.46, N = 3SE +/- 4.87, N = 4SE +/- 2.74, N = 5SE +/- 3.15, N = 3341.89336.49332.73335.80339.95MIN: 38.44 / MAX: 5000MIN: 37.9 / MAX: 3750MIN: 38.17 / MAX: 3750MIN: 38.07 / MAX: 3750MIN: 37.64 / MAX: 4000

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse 22.12.3.5100M Rows Hits Dataset, Third RunSamsung MZWLJ1T9HBJR-00007Micron 7450 Max 3.2TBCrucial T705 2TBCorsair MP700 PRO 2TBCorsair MP700 2TB70140210280350SE +/- 1.63, N = 3SE +/- 2.21, N = 3SE +/- 2.11, N = 4SE +/- 2.43, N = 5SE +/- 2.52, N = 3341.09329.19338.17340.17330.69MIN: 38.36 / MAX: 5000MIN: 38.63 / MAX: 3000MIN: 38.14 / MAX: 5454.55MIN: 38.27 / MAX: 4000MIN: 37.5 / MAX: 3529.41

MariaDB mariadb-slap

This is a MariaDB MySQL database server benchmark making use of mysqlslap (mariadb-slap). Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 32Samsung MZWLJ1T9HBJR-00007Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCorsair MP700 2TB30060090012001500SE +/- 2.47, N = 3SE +/- 2.78, N = 3SE +/- 9.35, N = 12SE +/- 0.39, N = 314359367397641. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 64Samsung MZWLJ1T9HBJR-00007Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCorsair MP700 2TB2004006008001000SE +/- 0.56, N = 3SE +/- 0.41, N = 3SE +/- 0.91, N = 3SE +/- 0.34, N = 37954705255321. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 128Samsung MZWLJ1T9HBJR-00007Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCorsair MP700 2TB90180270360450SE +/- 0.18, N = 3SE +/- 0.52, N = 3SE +/- 0.32, N = 3SE +/- 0.04, N = 34212393303341. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 256Samsung MZWLJ1T9HBJR-00007Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCorsair MP700 2TB50100150200250SE +/- 0.14, N = 3SE +/- 0.50, N = 3SE +/- 0.09, N = 3SE +/- 0.21, N = 32181191891901. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 512Samsung MZWLJ1T9HBJR-00007Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCorsair MP700 2TB20406080100SE +/- 0.17, N = 3SE +/- 0.17, N = 3SE +/- 0.04, N = 3SE +/- 0.14, N = 3111431011011. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 1024Samsung MZWLJ1T9HBJR-00007Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCorsair MP700 2TB1020304050SE +/- 0.13, N = 3SE +/- 0.05, N = 3SE +/- 0.47, N = 9SE +/- 0.53, N = 940446451. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 2048Samsung MZWLJ1T9HBJR-00007Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCorsair MP700 2TB20406080100SE +/- 0.85, N = 3SE +/- 0.38, N = 3SE +/- 0.88, N = 3SE +/- 0.74, N = 962778791. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 4096Samsung MZWLJ1T9HBJR-00007Corsair MP700 PRO 2TBCorsair MP700 2TB20406080100SE +/- 0.95, N = 3SE +/- 0.73, N = 9SE +/- 0.57, N = 38281811. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

MariaDB

This is a MariaDB MySQL database server benchmark making use of sysbench rather than the existing pts/mysqlslap test profile that uses MariaDB with mysqlslap/mariadb-slap as the benchmark driver. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.5Test: oltp_read_only - Threads: 128Samsung MZWLJ1T9HBJR-00007Corsair MP700 PRO 2TBCorsair MP700 2TB6K12K18K24K30KSE +/- 23.88, N = 3SE +/- 20.46, N = 3SE +/- 9.76, N = 32644926432262941. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.5Test: oltp_read_write - Threads: 128Samsung MZWLJ1T9HBJR-00007Corsair MP700 PRO 2TBCorsair MP700 2TB30K60K90K120K150KSE +/- 63.58, N = 3SE +/- 152.21, N = 3SE +/- 173.52, N = 31229241218101213141. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.5Test: oltp_write_only - Threads: 128Samsung MZWLJ1T9HBJR-00007Corsair MP700 PRO 2TBCorsair MP700 2TB60K120K180K240K300KSE +/- 222.32, N = 3SE +/- 558.10, N = 3SE +/- 566.85, N = 326882573634738021. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.5Test: oltp_point_select - Threads: 128Samsung MZWLJ1T9HBJR-00007Corsair MP700 PRO 2TBCorsair MP700 2TB8K16K24K32K40KSE +/- 23.41, N = 3SE +/- 26.99, N = 3SE +/- 24.16, N = 33860338300379911. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.5Test: oltp_update_index - Threads: 128Samsung MZWLJ1T9HBJR-00007Corsair MP700 PRO 2TBCorsair MP700 2TB20K40K60K80K100KSE +/- 80.60, N = 3SE +/- 3430.94, N = 6SE +/- 2315.37, N = 911541652864518101. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.5Test: oltp_update_non_index - Threads: 128Samsung MZWLJ1T9HBJR-00007Corsair MP700 PRO 2TBCorsair MP700 2TB30K60K90K120K150KSE +/- 91.45, N = 3SE +/- 2173.20, N = 9SE +/- 2550.78, N = 916089739323383251. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

PostgreSQL

This is a benchmark of PostgreSQL using the integrated pgbench for facilitating the database benchmarks. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 1000 - Mode: Read WriteSamsung MZWLJ1T9HBJR-00007Micron 7450 Max 3.2TBCrucial T705 2TBCorsair MP700 PRO 2TBCorsair MP700 2TB9K18K27K36K45KSE +/- 77.34, N = 3SE +/- 310.04, N = 3SE +/- 448.34, N = 12SE +/- 371.60, N = 12SE +/- 446.86, N = 1229704410462174722859228681. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write - Average LatencySamsung MZWLJ1T9HBJR-00007Micron 7450 Max 3.2TBCrucial T705 2TBCorsair MP700 PRO 2TBCorsair MP700 2TB1020304050SE +/- 0.09, N = 3SE +/- 0.18, N = 3SE +/- 0.85, N = 12SE +/- 0.68, N = 12SE +/- 0.82, N = 1233.6724.3746.1843.8743.901. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

SQLite

This is a simple benchmark of SQLite. At present this test profile just measures the time to perform a pre-defined number of insertions on an indexed database with a variable number of concurrent repetitions -- up to the maximum number of CPU threads available. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 1Micron 7450 Max 3.2TBCrucial T705 2TBCorsair MP700 PRO 2TBCorsair MP700 2TB612182430SE +/- 0.000, N = 3SE +/- 0.220, N = 3SE +/- 0.186, N = 3SE +/- 0.080, N = 32.21923.77323.09323.2121. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm

Threads / Copies: 1

Samsung MZWLJ1T9HBJR-00007: The test run did not produce a result.

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 8Samsung MZWLJ1T9HBJR-00007Micron 7450 Max 3.2TBCrucial T705 2TBCorsair MP700 PRO 2TBCorsair MP700 2TB20406080100SE +/- 0.087, N = 12SE +/- 0.036, N = 3SE +/- 0.737, N = 3SE +/- 0.843, N = 3SE +/- 0.864, N = 32.5254.41587.67692.75293.2441. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 16Samsung MZWLJ1T9HBJR-00007Micron 7450 Max 3.2TBCrucial T705 2TBCorsair MP700 PRO 2TBCorsair MP700 2TB306090120150SE +/- 0.371, N = 12SE +/- 0.031, N = 3SE +/- 1.241, N = 3SE +/- 1.278, N = 12SE +/- 0.565, N = 36.1087.454133.458123.972135.4991. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm