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

Limit displaying results to tests within:

CPU Massive 2 Tests
Database Test Suite 6 Tests
Disk Test Suite 2 Tests
Multi-Core 3 Tests
Server 7 Tests

Statistics

Show Overall Harmonic Mean(s)
Show Overall Geometric Mean
Show Geometric Means Per-Suite/Category
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
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 Hiding All Results Option
  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):

Micron 7450 Max 3.2TB

Processor: AMD EPYC 8534P 64-Core @ 2.30GHz (64 Cores / 128 Threads), Motherboard: AMD Cinnabar (RCB1009C BIOS), Chipset: AMD Device 14a4, Memory: 6 x 32GB DRAM-4800MT/s Samsung M321R4GA0BB0-CQKMG, Disk: 3201GB Micron_7450_MTFDKCB3T2TFS, Graphics: ASPEED, Network: 2 x Broadcom NetXtreme BCM5720 PCIe

OS: Ubuntu 23.10, Kernel: 6.8.1-060801-generic (x86_64), Desktop: GNOME Shell 45.2, Display Server: X Server 1.21.1.7, Compiler: GCC 13.2.0, File-System: ext4, Screen Resolution: 1920x1200

Kernel Notes: Transparent Huge Pages: madvise
Compiler Notes: --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 Notes: NONE / relatime,rw,stripe=64 / Block Size: 4096
Processor Notes: Scaling Governor: acpi-cpufreq performance (Boost: Enabled) - CPU Microcode: 0xaa00212
Java Notes: OpenJDK Runtime Environment (build 11.0.22+7-post-Ubuntu-0ubuntu223.10.1)
Python Notes: Python 3.11.6
Security Notes: 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

Corsair MP700 PRO 2TB

Changed Disk to 3201GB Micron_7450_MTFDKCB3T2TFS + 2000GB Corsair MP700 PRO.

Disk Change: NONE / relatime,rw / Block Size: 4096

Crucial T705 2TB

Changed Disk to 3201GB Micron_7450_MTFDKCB3T2TFS + 2000GB CT2000T705SSD5.

Corsair MP700 2TB

Changed Disk to 3201GB Micron_7450_MTFDKCB3T2TFS + 2000GB Corsair MP700.

Samsung MZWLJ1T9HBJR-00007

Changed Disk to 3201GB Micron_7450_MTFDKCB3T2TFS + 2 x 1920GB SAMSUNG MZWLJ1T9HBJR-00007.

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 Storagesqlite: 1sqlite: 8sqlite: 16fio: 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 Directoryclickhouse: 100M Rows Hits Dataset, First Run / Cold Cacheclickhouse: 100M Rows Hits Dataset, Second Runclickhouse: 100M Rows Hits Dataset, Third Runcockroach: KV, 50% Reads - 256cockroach: KV, 60% Reads - 256pgbench: 1000 - 1000 - Read Writepgbench: 1000 - 1000 - Read Write - Average Latencycassandra: Writesfio: 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 Directorymysqlslap: 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 - 128Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-000072.2194.4157.454642051834993329.86336.49329.19101366.5107941.14104624.365252621320925902495936470239119434723.09392.752123.972343333723373325.58335.80340.1785287.594295.72285943.867250721171516851685739525330189101467881264321218107363438300528643932323.77387.676133.458356217041122328.03332.73338.1783953.092691.12174746.175252370178085055923.21293.244135.499343220041093320.33339.95330.6985748.492980.02286843.9042506461715100054576453233419010145798126294121314738023799151810383252.5256.108686124492448323.26341.89341.09106033.3107353.92970433.66625758134291223122214357954212181114062822644912292426882538603115416160897OpenBenchmarking.org

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
OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 1Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TB612182430Min: 2.22 / Avg: 2.22 / Max: 2.22Min: 22.83 / Avg: 23.09 / Max: 23.45Min: 23.46 / Avg: 23.77 / Max: 24.2Min: 23.08 / Avg: 23.21 / Max: 23.361. (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: 8Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000720406080100Min: 4.37 / Avg: 4.42 / Max: 4.49Min: 91.73 / Avg: 92.75 / Max: 94.43Min: 86.26 / Avg: 87.68 / Max: 88.75Min: 91.53 / Avg: 93.24 / Max: 94.31Min: 2.14 / Avg: 2.52 / Max: 2.981. (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
OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 16Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-00007306090120150Min: 7.39 / Avg: 7.45 / Max: 7.5Min: 121.47 / Avg: 123.97 / Max: 135.27Min: 131.08 / Avg: 133.46 / Max: 135.26Min: 134.89 / Avg: 135.5 / Max: 136.63Min: 3.82 / Avg: 6.11 / Max: 8.441. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm

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.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 DirectoryMicron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000715003000450060007500SE +/- 9.45, N = 3SE +/- 0.00, N = 3SE +/- 1.45, N = 3SE +/- 0.00, N = 3SE +/- 55.19, N = 3654934173562343268611. (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 DirectoryMicron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000712002400360048006000Min: 6531 / Avg: 6549 / Max: 6563Min: 3417 / Avg: 3417 / Max: 3417Min: 3559 / Avg: 3561.67 / Max: 3564Min: 3432 / Avg: 3432 / Max: 3432Min: 6763 / Avg: 6861 / Max: 69541. (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 DirectoryMicron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000711002200330044005500SE +/- 6.74, N = 3SE +/- 0.33, N = 3SE +/- 130.58, N = 15SE +/- 171.84, N = 15SE +/- 0.88, N = 3495233741704200424491. (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 DirectoryMicron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-000079001800270036004500Min: 4939 / Avg: 4951.67 / Max: 4962Min: 3374 / Avg: 3374.33 / Max: 3375Min: 942 / Avg: 1704.13 / Max: 3084Min: 760 / Avg: 2003.53 / Max: 3367Min: 2447 / Avg: 2448.67 / Max: 24501. (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 DirectoryMicron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000711002200330044005500SE +/- 9.21, N = 3SE +/- 16.76, N = 3SE +/- 143.79, N = 13SE +/- 77.06, N = 15SE +/- 1.53, N = 3499033411122109324481. (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 DirectoryMicron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-000079001800270036004500Min: 4977 / Avg: 4990.33 / Max: 5008Min: 3321 / Avg: 3340.67 / Max: 3374Min: 630 / Avg: 1121.62 / Max: 2546Min: 752 / Avg: 1093.07 / Max: 1581Min: 2445 / Avg: 2448 / Max: 24501. (CC) gcc options: -rdynamic -ltcmalloc -ll -lnuma -lz -lm -laio -lpthread -ldl -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -march=native

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, First Run / Cold CacheMicron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000760120180240300Min: 324.08 / Avg: 329.86 / Max: 336.79Min: 318.78 / Avg: 325.58 / Max: 336.62Min: 322.72 / Avg: 328.03 / Max: 338.82Min: 313.16 / Avg: 320.33 / Max: 327.08Min: 322.34 / Avg: 323.26 / Max: 323.89

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, Second RunMicron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000760120180240300Min: 331.93 / Avg: 336.49 / Max: 343.28Min: 327.48 / Avg: 335.8 / Max: 343.82Min: 324.86 / Avg: 332.73 / Max: 346.87Min: 335.81 / Avg: 339.95 / Max: 346.12Min: 334.25 / Avg: 341.89 / Max: 347.34

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
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-0000760120180240300Min: 324.82 / Avg: 329.19 / Max: 331.96Min: 334.58 / Avg: 340.17 / Max: 346.19Min: 334.75 / Avg: 338.17 / Max: 344.28Min: 325.79 / Avg: 330.69 / Max: 334.14Min: 339.1 / Avg: 341.09 / Max: 344.33

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, 50% Reads - Concurrency: 256Micron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000720K40K60K80K100KMin: 92574.1 / Avg: 101366.47 / Max: 105956.4Min: 84050.4 / Avg: 85287.53 / Max: 86050.2Min: 82998.9 / Avg: 83953.03 / Max: 84472Min: 85148.9 / Avg: 85748.37 / Max: 86118.5Min: 104864.1 / Avg: 106033.3 / Max: 107634.1

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
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-0000720K40K60K80K100KMin: 96432.8 / Avg: 107941.07 / Max: 113763.4Min: 93432.5 / Avg: 94295.73 / Max: 95180.5Min: 91443.1 / Avg: 92691.07 / Max: 93982Min: 92204.4 / Avg: 92979.97 / Max: 93391.6Min: 98326.8 / Avg: 107353.93 / Max: 114386.8

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.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 1000 - Mode: Read WriteMicron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-000077K14K21K28K35KMin: 40500.15 / Avg: 41046.37 / Max: 41573.67Min: 21128.9 / Avg: 22859.08 / Max: 26081.62Min: 20377.84 / Avg: 21747.1 / Max: 26029.89Min: 20997.87 / Avg: 22868.24 / Max: 26160.15Min: 29562.71 / Avg: 29703.75 / Max: 29829.251. (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
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-00007918273645Min: 24.05 / Avg: 24.37 / Max: 24.69Min: 38.34 / Avg: 43.87 / Max: 47.33Min: 38.42 / Avg: 46.17 / Max: 49.07Min: 38.23 / Avg: 43.9 / Max: 47.62Min: 33.52 / Avg: 33.67 / Max: 33.831. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

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
OpenBenchmarking.orgOp/s, More Is BetterApache Cassandra 4.1.3Test: WritesMicron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBSamsung MZWLJ1T9HBJR-0000740K80K120K160K200KMin: 250586 / Avg: 252621.33 / Max: 255187Min: 250038 / Avg: 250721.33 / Max: 251473Min: 250793 / Avg: 252369.67 / Max: 253739Min: 248403 / Avg: 250645.67 / Max: 252256Min: 256464 / Avg: 257580.67 / Max: 259460

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 DirectoryCrucial T705 2TBCorsair MP700 2TBCorsair MP700 PRO 2TBMicron 7450 Max 3.2TBSamsung MZWLJ1T9HBJR-000077001400210028003500SE +/- 0.88, N = 3SE +/- 0.00, N = 3SE +/- 0.00, N = 3SE +/- 1.86, N = 3SE +/- 27.45, N = 3178017151715320934291. (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 Read - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 64 - Disk Target: Default Test DirectoryCrucial T705 2TBCorsair MP700 2TBCorsair MP700 PRO 2TBMicron 7450 Max 3.2TBSamsung MZWLJ1T9HBJR-000076001200180024003000Min: 1778 / Avg: 1779.67 / Max: 1781Min: 1715 / Avg: 1715 / Max: 1715Min: 1715 / Avg: 1715 / Max: 1715Min: 3205 / Avg: 3208.67 / Max: 3211Min: 3380 / Avg: 3428.67 / Max: 34751. (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 DirectoryCrucial T705 2TBCorsair MP700 2TBCorsair MP700 PRO 2TBMicron 7450 Max 3.2TBSamsung MZWLJ1T9HBJR-000076001200180024003000SE +/- 65.28, N = 15SE +/- 85.95, N = 15SE +/- 0.33, N = 3SE +/- 2.40, N = 3SE +/- 0.58, N = 385010001685259012231. (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 DirectoryCrucial T705 2TBCorsair MP700 2TBCorsair MP700 PRO 2TBMicron 7450 Max 3.2TBSamsung MZWLJ1T9HBJR-000075001000150020002500Min: 469 / Avg: 850.4 / Max: 1540Min: 378 / Avg: 1000.13 / Max: 1682Min: 1684 / Avg: 1684.67 / Max: 1685Min: 2585 / Avg: 2589.67 / Max: 2593Min: 1222 / Avg: 1223 / Max: 12241. (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 DirectoryCrucial T705 2TBCorsair MP700 2TBCorsair MP700 PRO 2TBMicron 7450 Max 3.2TBSamsung MZWLJ1T9HBJR-000075001000150020002500SE +/- 71.93, N = 13SE +/- 38.56, N = 15SE +/- 0.00, N = 3SE +/- 5.86, N = 3SE +/- 0.67, N = 35595451685249512221. (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 DirectoryCrucial T705 2TBCorsair MP700 2TBCorsair MP700 PRO 2TBMicron 7450 Max 3.2TBSamsung MZWLJ1T9HBJR-00007400800120016002000Min: 313 / Avg: 559.38 / Max: 1272Min: 374 / Avg: 545 / Max: 789Min: 1685 / Avg: 1685 / Max: 1685Min: 2486 / Avg: 2495 / Max: 2506Min: 1221 / Avg: 1222.33 / Max: 12231. (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 mariadb-slap

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 32Corsair MP700 2TBCorsair MP700 PRO 2TBMicron 7450 Max 3.2TBSamsung MZWLJ1T9HBJR-0000730060090012001500SE +/- 0.39, N = 3SE +/- 9.35, N = 12SE +/- 2.78, N = 3SE +/- 2.47, N = 376473993614351. (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: 32Corsair MP700 2TBCorsair MP700 PRO 2TBMicron 7450 Max 3.2TBSamsung MZWLJ1T9HBJR-0000730060090012001500Min: 763.36 / Avg: 763.75 / Max: 764.53Min: 636.13 / Avg: 738.91 / Max: 750.19Min: 930.23 / Avg: 935.76 / Max: 938.97Min: 1430.62 / Avg: 1435.42 / Max: 1438.851. (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: 64Corsair MP700 2TBCorsair MP700 PRO 2TBMicron 7450 Max 3.2TBSamsung MZWLJ1T9HBJR-000072004006008001000SE +/- 0.34, N = 3SE +/- 0.91, N = 3SE +/- 0.41, N = 3SE +/- 0.56, N = 35325254707951. (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: 64Corsair MP700 2TBCorsair MP700 PRO 2TBMicron 7450 Max 3.2TBSamsung MZWLJ1T9HBJR-00007140280420560700Min: 531.63 / Avg: 532.29 / Max: 532.77Min: 523.83 / Avg: 525.12 / Max: 526.87Min: 469.04 / Avg: 469.85 / Max: 470.37Min: 794.28 / Avg: 795.12 / Max: 796.181. (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: 128Corsair MP700 2TBCorsair MP700 PRO 2TBMicron 7450 Max 3.2TBSamsung MZWLJ1T9HBJR-0000790180270360450SE +/- 0.04, N = 3SE +/- 0.32, N = 3SE +/- 0.52, N = 3SE +/- 0.18, N = 33343302394211. (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: 128Corsair MP700 2TBCorsair MP700 PRO 2TBMicron 7450 Max 3.2TBSamsung MZWLJ1T9HBJR-0000770140210280350Min: 333.56 / Avg: 333.59 / Max: 333.67Min: 329.82 / Avg: 330.36 / Max: 330.91Min: 238.04 / Avg: 238.59 / Max: 239.64Min: 420.34 / Avg: 420.52 / Max: 420.881. (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: 256Corsair MP700 2TBCorsair MP700 PRO 2TBMicron 7450 Max 3.2TBSamsung MZWLJ1T9HBJR-0000750100150200250SE +/- 0.21, N = 3SE +/- 0.09, N = 3SE +/- 0.50, N = 3SE +/- 0.14, N = 31901891192181. (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: 256Corsair MP700 2TBCorsair MP700 PRO 2TBMicron 7450 Max 3.2TBSamsung MZWLJ1T9HBJR-000074080120160200Min: 189.25 / Avg: 189.67 / Max: 189.9Min: 189.14 / Avg: 189.25 / Max: 189.43Min: 118.41 / Avg: 119.39 / Max: 120.09Min: 217.91 / Avg: 218.12 / Max: 218.391. (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: 512Corsair MP700 2TBCorsair MP700 PRO 2TBMicron 7450 Max 3.2TBSamsung MZWLJ1T9HBJR-0000720406080100SE +/- 0.14, N = 3SE +/- 0.04, N = 3SE +/- 0.17, N = 3SE +/- 0.17, N = 3101101431111. (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: 512Corsair MP700 2TBCorsair MP700 PRO 2TBMicron 7450 Max 3.2TBSamsung MZWLJ1T9HBJR-0000720406080100Min: 100.65 / Avg: 100.93 / Max: 101.13Min: 100.57 / Avg: 100.65 / Max: 100.7Min: 43.08 / Avg: 43.34 / Max: 43.66Min: 110.47 / Avg: 110.67 / Max: 111.011. (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: 1024Corsair MP700 2TBCorsair MP700 PRO 2TBMicron 7450 Max 3.2TBSamsung MZWLJ1T9HBJR-000071020304050SE +/- 0.53, N = 9SE +/- 0.47, N = 9SE +/- 0.05, N = 3SE +/- 0.13, N = 345464401. (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: 1024Corsair MP700 2TBCorsair MP700 PRO 2TBMicron 7450 Max 3.2TBSamsung MZWLJ1T9HBJR-00007918273645Min: 43.64 / Avg: 45.34 / Max: 48.48Min: 44.48 / Avg: 46.07 / Max: 48.42Min: 4.19 / Avg: 4.28 / Max: 4.38Min: 39.65 / Avg: 39.9 / Max: 40.061. (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: 2048Corsair MP700 2TBCorsair MP700 PRO 2TBMicron 7450 Max 3.2TBSamsung MZWLJ1T9HBJR-0000720406080100SE +/- 0.74, N = 9SE +/- 0.88, N = 3SE +/- 0.38, N = 3SE +/- 0.85, N = 379787621. (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: 2048Corsair MP700 2TBCorsair MP700 PRO 2TBMicron 7450 Max 3.2TBSamsung MZWLJ1T9HBJR-000071530456075Min: 75.35 / Avg: 79.07 / Max: 82.24Min: 76.08 / Avg: 77.76 / Max: 79.08Min: 6.51 / Avg: 7.25 / Max: 7.77Min: 61.25 / Avg: 62.44 / Max: 64.071. (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 2TBCorsair MP700 PRO 2TBSamsung MZWLJ1T9HBJR-0000720406080100SE +/- 0.57, N = 3SE +/- 0.73, N = 9SE +/- 0.95, N = 38181821. (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 2TBCorsair MP700 PRO 2TBSamsung MZWLJ1T9HBJR-000071632486480Min: 80.63 / Avg: 81.36 / Max: 82.48Min: 79.31 / Avg: 80.98 / Max: 84.82Min: 80.33 / Avg: 82.09 / Max: 83.61. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

MariaDB

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.5Test: oltp_read_only - Threads: 128Corsair MP700 2TBCorsair MP700 PRO 2TBSamsung MZWLJ1T9HBJR-000076K12K18K24K30KSE +/- 9.76, N = 3SE +/- 20.46, N = 3SE +/- 23.88, N = 32629426432264491. (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_only - Threads: 128Corsair MP700 2TBCorsair MP700 PRO 2TBSamsung MZWLJ1T9HBJR-000075K10K15K20K25KMin: 26280.49 / Avg: 26294.01 / Max: 26312.96Min: 26392.02 / Avg: 26432.09 / Max: 26459.32Min: 26414.67 / Avg: 26449.32 / Max: 26495.111. (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 2TBCorsair MP700 PRO 2TBSamsung MZWLJ1T9HBJR-0000730K60K90K120K150KSE +/- 173.52, N = 3SE +/- 152.21, N = 3SE +/- 63.58, N = 31213141218101229241. (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 2TBCorsair MP700 PRO 2TBSamsung MZWLJ1T9HBJR-0000720K40K60K80K100KMin: 121043.27 / Avg: 121313.92 / Max: 121637.35Min: 121556.34 / Avg: 121809.96 / Max: 122082.58Min: 122815.96 / Avg: 122923.9 / Max: 123036.091. (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 2TBCorsair MP700 PRO 2TBSamsung MZWLJ1T9HBJR-0000760K120K180K240K300KSE +/- 566.85, N = 3SE +/- 558.10, N = 3SE +/- 222.32, N = 373802736342688251. (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 2TBCorsair MP700 PRO 2TBSamsung MZWLJ1T9HBJR-0000750K100K150K200K250KMin: 72952.91 / Avg: 73802.32 / Max: 74877.29Min: 72518.21 / Avg: 73633.64 / Max: 74227.15Min: 268427.15 / Avg: 268824.66 / Max: 269195.951. (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 2TBCorsair MP700 PRO 2TBSamsung MZWLJ1T9HBJR-000078K16K24K32K40KSE +/- 24.16, N = 3SE +/- 26.99, N = 3SE +/- 23.41, N = 33799138300386031. (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 2TBCorsair MP700 PRO 2TBSamsung MZWLJ1T9HBJR-000077K14K21K28K35KMin: 37946.12 / Avg: 37991.14 / Max: 38028.83Min: 38267.28 / Avg: 38300.48 / Max: 38353.94Min: 38558.45 / Avg: 38603.33 / Max: 38637.331. (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 2TBCorsair MP700 PRO 2TBSamsung MZWLJ1T9HBJR-0000720K40K60K80K100KSE +/- 2315.37, N = 9SE +/- 3430.94, N = 6SE +/- 80.60, N = 351810528641154161. (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 2TBCorsair MP700 PRO 2TBSamsung MZWLJ1T9HBJR-0000720K40K60K80K100KMin: 36839.63 / Avg: 51809.85 / Max: 58799.2Min: 36293.09 / Avg: 52863.76 / Max: 59032.29Min: 115256.13 / Avg: 115415.58 / Max: 115515.811. (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 2TBCorsair MP700 PRO 2TBSamsung MZWLJ1T9HBJR-0000730K60K90K120K150KSE +/- 2550.78, N = 9SE +/- 2173.20, N = 9SE +/- 91.45, N = 338325393231608971. (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 2TBCorsair MP700 PRO 2TBSamsung MZWLJ1T9HBJR-0000730K60K90K120K150KMin: 30509.56 / Avg: 38325.37 / Max: 48593.7Min: 32080.18 / Avg: 39322.79 / Max: 49699.13Min: 160765.88 / Avg: 160896.77 / Max: 161072.841. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

Micron 7450 Max 3.2TB

Processor: AMD EPYC 8534P 64-Core @ 2.30GHz (64 Cores / 128 Threads), Motherboard: AMD Cinnabar (RCB1009C BIOS), Chipset: AMD Device 14a4, Memory: 6 x 32GB DRAM-4800MT/s Samsung M321R4GA0BB0-CQKMG, Disk: 3201GB Micron_7450_MTFDKCB3T2TFS, Graphics: ASPEED, Network: 2 x Broadcom NetXtreme BCM5720 PCIe

OS: Ubuntu 23.10, Kernel: 6.8.1-060801-generic (x86_64), Desktop: GNOME Shell 45.2, Display Server: X Server 1.21.1.7, Compiler: GCC 13.2.0, File-System: ext4, Screen Resolution: 1920x1200

Kernel Notes: Transparent Huge Pages: madvise
Compiler Notes: --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 Notes: NONE / relatime,rw,stripe=64 / Block Size: 4096
Processor Notes: Scaling Governor: acpi-cpufreq performance (Boost: Enabled) - CPU Microcode: 0xaa00212
Java Notes: OpenJDK Runtime Environment (build 11.0.22+7-post-Ubuntu-0ubuntu223.10.1)
Python Notes: Python 3.11.6
Security Notes: 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

Testing initiated at 21 March 2024 20:37 by user phoronix.

Corsair MP700 PRO 2TB

Processor: AMD EPYC 8534P 64-Core @ 2.30GHz (64 Cores / 128 Threads), Motherboard: AMD Cinnabar (RCB1009C BIOS), Chipset: AMD Device 14a4, Memory: 6 x 32GB DRAM-4800MT/s Samsung M321R4GA0BB0-CQKMG, Disk: 3201GB Micron_7450_MTFDKCB3T2TFS + 2000GB Corsair MP700 PRO, Graphics: ASPEED, Network: 2 x Broadcom NetXtreme BCM5720 PCIe

OS: Ubuntu 23.10, Kernel: 6.8.1-060801-generic (x86_64), Desktop: GNOME Shell 45.2, Display Server: X Server 1.21.1.7, Compiler: GCC 13.2.0, File-System: ext4, Screen Resolution: 1920x1200

Kernel Notes: Transparent Huge Pages: madvise
Compiler Notes: --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 Notes: NONE / relatime,rw / Block Size: 4096
Processor Notes: Scaling Governor: acpi-cpufreq performance (Boost: Enabled) - CPU Microcode: 0xaa00212
Java Notes: OpenJDK Runtime Environment (build 11.0.22+7-post-Ubuntu-0ubuntu223.10.1)
Security Notes: 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

Testing initiated at 22 March 2024 12:03 by user phoronix.

Crucial T705 2TB

Processor: AMD EPYC 8534P 64-Core @ 2.30GHz (64 Cores / 128 Threads), Motherboard: AMD Cinnabar (RCB1009C BIOS), Chipset: AMD Device 14a4, Memory: 6 x 32GB DRAM-4800MT/s Samsung M321R4GA0BB0-CQKMG, Disk: 3201GB Micron_7450_MTFDKCB3T2TFS + 2000GB CT2000T705SSD5, Graphics: ASPEED, Network: 2 x Broadcom NetXtreme BCM5720 PCIe

OS: Ubuntu 23.10, Kernel: 6.8.1-060801-generic (x86_64), Desktop: GNOME Shell 45.2, Display Server: X Server 1.21.1.7, Compiler: GCC 13.2.0, File-System: ext4, Screen Resolution: 1920x1200

Kernel Notes: Transparent Huge Pages: madvise
Compiler Notes: --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 Notes: NONE / relatime,rw / Block Size: 4096
Processor Notes: Scaling Governor: acpi-cpufreq performance (Boost: Enabled) - CPU Microcode: 0xaa00212
Java Notes: OpenJDK Runtime Environment (build 11.0.22+7-post-Ubuntu-0ubuntu223.10.1)
Security Notes: 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

Testing initiated at 22 March 2024 18:14 by user phoronix.

Corsair MP700 2TB

Processor: AMD EPYC 8534P 64-Core @ 2.30GHz (64 Cores / 128 Threads), Motherboard: AMD Cinnabar (RCB1009C BIOS), Chipset: AMD Device 14a4, Memory: 6 x 32GB DRAM-4800MT/s Samsung M321R4GA0BB0-CQKMG, Disk: 3201GB Micron_7450_MTFDKCB3T2TFS + 2000GB Corsair MP700, Graphics: ASPEED, Network: 2 x Broadcom NetXtreme BCM5720 PCIe

OS: Ubuntu 23.10, Kernel: 6.8.1-060801-generic (x86_64), Desktop: GNOME Shell 45.2, Display Server: X Server 1.21.1.7, Compiler: GCC 13.2.0, File-System: ext4, Screen Resolution: 1920x1200

Kernel Notes: Transparent Huge Pages: madvise
Compiler Notes: --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 Notes: NONE / relatime,rw / Block Size: 4096
Processor Notes: Scaling Governor: acpi-cpufreq performance (Boost: Enabled) - CPU Microcode: 0xaa00212
Java Notes: OpenJDK Runtime Environment (build 11.0.22+7-post-Ubuntu-0ubuntu223.10.1)
Security Notes: 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

Testing initiated at 23 March 2024 13:43 by user phoronix.

Samsung MZWLJ1T9HBJR-00007

Processor: AMD EPYC 8534P 64-Core @ 2.30GHz (64 Cores / 128 Threads), Motherboard: AMD Cinnabar (RCB1009C BIOS), Chipset: AMD Device 14a4, Memory: 6 x 32GB DRAM-4800MT/s Samsung M321R4GA0BB0-CQKMG, Disk: 3201GB Micron_7450_MTFDKCB3T2TFS + 2 x 1920GB SAMSUNG MZWLJ1T9HBJR-00007, Graphics: ASPEED, Network: 2 x Broadcom NetXtreme BCM5720 PCIe

OS: Ubuntu 23.10, Kernel: 6.8.1-060801-generic (x86_64), Desktop: GNOME Shell 45.2, Display Server: X Server 1.21.1.7, Compiler: GCC 13.2.0, File-System: ext4, Screen Resolution: 1920x1200

Kernel Notes: Transparent Huge Pages: madvise
Compiler Notes: --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 Notes: NONE / relatime,rw / Block Size: 4096
Processor Notes: Scaling Governor: acpi-cpufreq performance (Boost: Enabled) - CPU Microcode: 0xaa00212
Java Notes: OpenJDK Runtime Environment (build 11.0.22+7-post-Ubuntu-0ubuntu223.10.1)
Security Notes: 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

Testing initiated at 1 April 2024 15:14 by user phoronix.