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-00007320925902495654949524990252621101366.5107941.1329.86336.49329.1993647023911943474104624.3652.2194.4157.45417151685168534173374334125072185287.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 DirectoryMicron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-000077001400210028003500SE +/- 1.86, N = 3SE +/- 0.00, N = 3SE +/- 0.88, N = 3SE +/- 0.00, N = 3SE +/- 27.45, N = 3320917151780171534291. (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 DirectoryMicron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-000076001200180024003000SE +/- 2.40, N = 3SE +/- 0.33, N = 3SE +/- 65.28, N = 15SE +/- 85.95, N = 15SE +/- 0.58, N = 325901685850100012231. (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 DirectoryMicron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-000075001000150020002500SE +/- 5.86, N = 3SE +/- 0.00, N = 3SE +/- 71.93, N = 13SE +/- 38.56, N = 15SE +/- 0.67, N = 32495168555954512221. (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 DirectoryCorsair MP700 PRO 2TBMicron 7450 Max 3.2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000715003000450060007500SE +/- 0.00, N = 3SE +/- 3.84, N = 3SE +/- 1.45, N = 3SE +/- 0.00, N = 3SE +/- 55.19, N = 3343364203562343268611. (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 DirectoryCorsair MP700 PRO 2TBMicron 7450 Max 3.2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000711002200330044005500SE +/- 0.67, N = 3SE +/- 4.81, N = 3SE +/- 130.58, N = 15SE +/- 171.84, N = 15SE +/- 0.88, N = 3337251831704200424491. (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 DirectoryCorsair MP700 PRO 2TBMicron 7450 Max 3.2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000711002200330044005500SE +/- 0.00, N = 3SE +/- 11.98, N = 3SE +/- 143.79, N = 13SE +/- 77.06, N = 15SE +/- 1.53, N = 3337349931122109324481. (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: WritesMicron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000760K120K180K240K300KSE +/- 1354.41, N = 3SE +/- 415.66, N = 3SE +/- 856.73, N = 3SE +/- 1156.33, N = 3SE +/- 945.21, N = 3252621250721252370250646257581

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: 256Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000720K40K60K80K100KSE +/- 1341.10, N = 15SE +/- 624.14, N = 3SE +/- 477.68, N = 3SE +/- 302.48, N = 3SE +/- 828.24, N = 3101366.585287.583953.085748.4106033.3

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

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 CacheMicron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000770140210280350SE +/- 3.71, N = 3SE +/- 3.47, N = 5SE +/- 3.65, N = 4SE +/- 4.03, N = 3SE +/- 0.47, N = 3329.86325.58328.03320.33323.26MIN: 38.34 / MAX: 5000MIN: 37.81 / MAX: 4000MIN: 37.04 / MAX: 3529.41MIN: 36.97 / MAX: 3333.33MIN: 37.93 / MAX: 3750

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

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

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: 32Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000730060090012001500SE +/- 2.78, N = 3SE +/- 9.35, N = 12SE +/- 0.39, N = 3SE +/- 2.47, N = 393673976414351. (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: 64Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-000072004006008001000SE +/- 0.41, N = 3SE +/- 0.91, N = 3SE +/- 0.34, N = 3SE +/- 0.56, N = 34705255327951. (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: 128Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000790180270360450SE +/- 0.52, N = 3SE +/- 0.32, N = 3SE +/- 0.04, N = 3SE +/- 0.18, N = 32393303344211. (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: 256Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000750100150200250SE +/- 0.50, N = 3SE +/- 0.09, N = 3SE +/- 0.21, N = 3SE +/- 0.14, N = 31191891902181. (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: 512Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000720406080100SE +/- 0.17, N = 3SE +/- 0.04, N = 3SE +/- 0.14, N = 3SE +/- 0.17, N = 3431011011111. (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: 1024Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-000071020304050SE +/- 0.05, N = 3SE +/- 0.47, N = 9SE +/- 0.53, N = 9SE +/- 0.13, N = 344645401. (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: 2048Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000720406080100SE +/- 0.38, N = 3SE +/- 0.88, N = 3SE +/- 0.74, N = 9SE +/- 0.85, N = 377879621. (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: 4096Corsair MP700 PRO 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000720406080100SE +/- 0.73, N = 9SE +/- 0.57, N = 3SE +/- 0.95, N = 38181821. (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: 128Corsair MP700 PRO 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-000076K12K18K24K30KSE +/- 20.46, N = 3SE +/- 9.76, N = 3SE +/- 23.88, N = 32643226294264491. (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: 128Corsair MP700 PRO 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000730K60K90K120K150KSE +/- 152.21, N = 3SE +/- 173.52, N = 3SE +/- 63.58, N = 31218101213141229241. (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: 128Corsair MP700 PRO 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000760K120K180K240K300KSE +/- 558.10, N = 3SE +/- 566.85, N = 3SE +/- 222.32, N = 373634738022688251. (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: 128Corsair MP700 PRO 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-000078K16K24K32K40KSE +/- 26.99, N = 3SE +/- 24.16, N = 3SE +/- 23.41, N = 33830037991386031. (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: 128Corsair MP700 PRO 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000720K40K60K80K100KSE +/- 3430.94, N = 6SE +/- 2315.37, N = 9SE +/- 80.60, N = 352864518101154161. (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: 128Corsair MP700 PRO 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000730K60K90K120K150KSE +/- 2173.20, N = 9SE +/- 2550.78, N = 9SE +/- 91.45, N = 339323383251608971. (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 WriteMicron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-000079K18K27K36K45KSE +/- 310.04, N = 3SE +/- 371.60, N = 12SE +/- 448.34, N = 12SE +/- 446.86, N = 12SE +/- 77.34, N = 341046228592174722868297041. (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 LatencyMicron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-000071020304050SE +/- 0.18, N = 3SE +/- 0.68, N = 12SE +/- 0.85, N = 12SE +/- 0.82, N = 12SE +/- 0.09, N = 324.3743.8746.1843.9033.671. (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.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TB612182430SE +/- 0.000, N = 3SE +/- 0.186, N = 3SE +/- 0.220, N = 3SE +/- 0.080, N = 32.21923.09323.77323.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: 8Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000720406080100SE +/- 0.036, N = 3SE +/- 0.843, N = 3SE +/- 0.737, N = 3SE +/- 0.864, N = 3SE +/- 0.087, N = 124.41592.75287.67693.2442.5251. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm

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