SSD Storage

Benchmarks for a future article. AMD EPYC 8534P 64-Core testing with a AMD Cinnabar (RCB1009C BIOS) and ASPEED on Ubuntu 23.10 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2403268-NE-SSDSTORAG25&grs&sro.

SSD StorageProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelDesktopDisplay ServerCompilerFile-SystemScreen ResolutionMicron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TBAMD 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_MTFDKCB3T2TFSASPEED2 x Broadcom NetXtreme BCM5720 PCIeUbuntu 23.106.8.1-060801-generic (x86_64)GNOME Shell 45.2X Server 1.21.1.7GCC 13.2.0ext41920x12003201GB Micron_7450_MTFDKCB3T2TFS + 2000GB Corsair MP700 PRO3201GB Micron_7450_MTFDKCB3T2TFS + 2000GB CT2000T705SSD53201GB Micron_7450_MTFDKCB3T2TFS + 2000GB Corsair MP700OpenBenchmarking.orgKernel Details- Transparent Huge Pages: madviseCompiler Details- --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-bootstrap --enable-cet --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,d,fortran,objc,obj-c++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-link-serialization=2 --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-defaulted --enable-offload-targets=nvptx-none=/build/gcc-13-XYspKM/gcc-13-13.2.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-13-XYspKM/gcc-13-13.2.0/debian/tmp-gcn/usr --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-build-config=bootstrap-lto-lean --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib=auto --with-tune=generic --without-cuda-driver -v Disk Details- Micron 7450 Max 3.2TB: NONE / relatime,rw,stripe=64 / Block Size: 4096- Corsair MP700 PRO 2TB: NONE / relatime,rw / Block Size: 4096- Crucial T705 2TB: NONE / relatime,rw / Block Size: 4096- Corsair MP700 2TB: NONE / relatime,rw / Block Size: 4096Processor Details- Scaling Governor: acpi-cpufreq performance (Boost: Enabled) - CPU Microcode: 0xaa00212Java Details- OpenJDK Runtime Environment (build 11.0.22+7-post-Ubuntu-0ubuntu223.10.1)Python Details- Micron 7450 Max 3.2TB: Python 3.11.6Security Details- gather_data_sampling: Not affected + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + reg_file_data_sampling: Not affected + retbleed: Not affected + spec_rstack_overflow: Mitigation of Safe RET + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced / Automatic IBRS IBPB: conditional STIBP: always-on RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected

SSD Storagesqlite: 8sqlite: 16sqlite: 1fio: Seq Read - IO_uring - Yes - 2MB - 64 - Default Test Directorycockroach: KV, 50% Reads - 256cockroach: KV, 60% Reads - 256fio: Seq Read - IO_uring - Yes - 2MB - 64 - Default Test Directoryclickhouse: 100M Rows Hits Dataset, Third Runclickhouse: 100M Rows Hits Dataset, First Run / Cold Cacheclickhouse: 100M Rows Hits Dataset, Second Runcassandra: Writesmariadb: oltp_point_select - 128mariadb: oltp_write_only - 128mariadb: oltp_read_write - 128mariadb: oltp_read_only - 128mysqlslap: 4096mysqlslap: 2048mysqlslap: 1024mysqlslap: 512mysqlslap: 256mysqlslap: 128mysqlslap: 64mysqlslap: 32mariadb: oltp_update_non_index - 128mariadb: oltp_update_index - 128fio: Seq Write - IO_uring - Yes - 2MB - 16 - Default Test Directoryfio: Seq Write - IO_uring - Yes - 2MB - 1 - Default Test Directorypgbench: 1000 - 1000 - Read Write - Average Latencypgbench: 1000 - 1000 - Read Writecockroach: KV, 95% Reads - 256fio: Seq Write - IO_uring - Yes - 2MB - 16 - Default Test Directoryfio: Seq Write - IO_uring - Yes - 2MB - 1 - Default Test DirectoryMicron 7450 Max 3.2TBCorsair MP700 PRO 2TBCrucial T705 2TBCorsair MP700 2TB4.4157.4542.2196549101366.5107941.1329.19329.86336.4925262124.36541046125152.64990495292.752123.97223.093341785287.594295.7340.17325.58335.8025072143.86722859131402.13341337487.676133.45823.773356283953.092691.11780338.17328.03332.7325237055985046.17521747131596.81122170493.244135.49923.212343285748.492980.01715330.69320.33339.952506463799173802121314262948179451011903345327643832551810545100043.90422868130978.510932004OpenBenchmarking.org

SQLite

Threads / Copies: 8

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

SQLite

Threads / Copies: 16

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

SQLite

Threads / Copies: 1

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

Flexible IO Tester

Type: Sequential Read - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 64 - Disk Target: Default Test Directory

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 2TBCorsair MP700 PRO 2TBCrucial T705 2TBMicron 7450 Max 3.2TB14002800420056007000SE +/- 0.00, N = 3SE +/- 0.00, N = 3SE +/- 1.45, N = 3SE +/- 9.45, N = 334323417356265491. (CC) gcc options: -rdynamic -ltcmalloc -ll -lnuma -lz -lm -laio -lpthread -ldl -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -march=native

CockroachDB

Workload: KV, 50% Reads - Concurrency: 256

OpenBenchmarking.orgops/s, More Is BetterCockroachDB 22.2Workload: KV, 50% Reads - Concurrency: 256Corsair MP700 2TBCorsair MP700 PRO 2TBCrucial T705 2TBMicron 7450 Max 3.2TB20K40K60K80K100KSE +/- 302.48, N = 3SE +/- 624.14, N = 3SE +/- 477.68, N = 3SE +/- 1341.10, N = 1585748.485287.583953.0101366.5

CockroachDB

Workload: KV, 60% Reads - Concurrency: 256

OpenBenchmarking.orgops/s, More Is BetterCockroachDB 22.2Workload: KV, 60% Reads - Concurrency: 256Corsair MP700 2TBCorsair MP700 PRO 2TBCrucial T705 2TBMicron 7450 Max 3.2TB20K40K60K80K100KSE +/- 388.03, N = 3SE +/- 504.72, N = 3SE +/- 733.23, N = 3SE +/- 1417.12, N = 1592980.094295.792691.1107941.1

Flexible IO Tester

Type: Sequential Read - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 64 - Disk Target: Default Test Directory

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 DirectoryCorsair MP700 2TBCrucial T705 2TB400800120016002000SE +/- 0.00, N = 3SE +/- 0.88, N = 3171517801. (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

100M Rows Hits Dataset, Third Run

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

ClickHouse

100M Rows Hits Dataset, First Run / Cold Cache

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

ClickHouse

100M Rows Hits Dataset, Second Run

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

Apache Cassandra

Test: Writes

OpenBenchmarking.orgOp/s, More Is BetterApache Cassandra 4.1.3Test: WritesCorsair MP700 2TBCorsair MP700 PRO 2TBCrucial T705 2TBMicron 7450 Max 3.2TB50K100K150K200K250KSE +/- 1156.33, N = 3SE +/- 415.66, N = 3SE +/- 856.73, N = 3SE +/- 1354.41, N = 3250646250721252370252621

MariaDB

Test: oltp_point_select - Threads: 128

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.5Test: oltp_point_select - Threads: 128Corsair MP700 2TB8K16K24K32K40KSE +/- 24.16, N = 3379911. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

MariaDB

Test: oltp_write_only - Threads: 128

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.5Test: oltp_write_only - Threads: 128Corsair MP700 2TB16K32K48K64K80KSE +/- 566.85, N = 3738021. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

MariaDB

Test: oltp_read_write - Threads: 128

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.5Test: oltp_read_write - Threads: 128Corsair MP700 2TB30K60K90K120K150KSE +/- 173.52, N = 31213141. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

MariaDB

Test: oltp_read_only - Threads: 128

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.5Test: oltp_read_only - Threads: 128Corsair MP700 2TB6K12K18K24K30KSE +/- 9.76, N = 3262941. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

MariaDB mariadb-slap

Clients: 4096

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 4096Corsair MP700 2TB20406080100SE +/- 0.57, N = 3811. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

MariaDB mariadb-slap

Clients: 2048

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 2048Corsair MP700 2TB20406080100SE +/- 0.74, N = 9791. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

MariaDB mariadb-slap

Clients: 1024

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 1024Corsair MP700 2TB1020304050SE +/- 0.53, N = 9451. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

MariaDB mariadb-slap

Clients: 512

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 512Corsair MP700 2TB20406080100SE +/- 0.14, N = 31011. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

MariaDB mariadb-slap

Clients: 256

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 256Corsair MP700 2TB4080120160200SE +/- 0.21, N = 31901. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

MariaDB mariadb-slap

Clients: 128

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 128Corsair MP700 2TB70140210280350SE +/- 0.04, N = 33341. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

MariaDB mariadb-slap

Clients: 64

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 64Corsair MP700 2TB120240360480600SE +/- 0.34, N = 35321. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

MariaDB mariadb-slap

Clients: 32

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 32Corsair MP700 2TB160320480640800SE +/- 0.39, N = 37641. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

MariaDB

Test: oltp_update_non_index - Threads: 128

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.5Test: oltp_update_non_index - Threads: 128Corsair MP700 2TB8K16K24K32K40KSE +/- 2550.78, N = 9383251. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

MariaDB

Test: oltp_update_index - Threads: 128

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.5Test: oltp_update_index - Threads: 128Corsair MP700 2TB11K22K33K44K55KSE +/- 2315.37, N = 9518101. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++

Flexible IO Tester

Type: Sequential Write - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 16 - Disk Target: Default Test Directory

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 DirectoryCorsair MP700 2TBCrucial T705 2TB120240360480600SE +/- 38.56, N = 15SE +/- 71.93, N = 135455591. (CC) gcc options: -rdynamic -ltcmalloc -ll -lnuma -lz -lm -laio -lpthread -ldl -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -march=native

Flexible IO Tester

Type: Sequential Write - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 1 - Disk Target: Default Test Directory

OpenBenchmarking.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 DirectoryCorsair MP700 2TBCrucial T705 2TB2004006008001000SE +/- 85.95, N = 15SE +/- 65.28, N = 1510008501. (CC) gcc options: -rdynamic -ltcmalloc -ll -lnuma -lz -lm -laio -lpthread -ldl -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -march=native

PostgreSQL

Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write - Average Latency

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

PostgreSQL

Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write

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

CockroachDB

Workload: KV, 95% Reads - Concurrency: 256

OpenBenchmarking.orgops/s, More Is BetterCockroachDB 22.2Workload: KV, 95% Reads - Concurrency: 256Corsair MP700 2TBCorsair MP700 PRO 2TBCrucial T705 2TBMicron 7450 Max 3.2TB30K60K90K120K150KSE +/- 671.03, N = 3SE +/- 1221.80, N = 3SE +/- 88.84, N = 3SE +/- 2278.37, N = 15130978.5131402.1131596.8125152.6

Flexible IO Tester

Type: Sequential Write - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 16 - Disk Target: Default Test Directory

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 2TBCorsair MP700 PRO 2TBCrucial T705 2TBMicron 7450 Max 3.2TB11002200330044005500SE +/- 77.06, N = 15SE +/- 16.76, N = 3SE +/- 143.79, N = 13SE +/- 9.21, N = 310933341112249901. (CC) gcc options: -rdynamic -ltcmalloc -ll -lnuma -lz -lm -laio -lpthread -ldl -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -march=native

Flexible IO Tester

Type: Sequential Write - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 1 - Disk Target: Default Test Directory

OpenBenchmarking.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 2TBCorsair MP700 PRO 2TBCrucial T705 2TBMicron 7450 Max 3.2TB11002200330044005500SE +/- 171.84, N = 15SE +/- 0.33, N = 3SE +/- 130.58, N = 15SE +/- 6.74, N = 320043374170449521. (CC) gcc options: -rdynamic -ltcmalloc -ll -lnuma -lz -lm -laio -lpthread -ldl -lcurl -lssl -lcrypto -std=gnu99 -ffast-math -include -O3 -fcommon -march=native

Phoronix Test Suite v10.8.5