SSD Storage

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

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2403226-NE-SSDSTORAG64
Jump To Table - Results

Statistics

Remove Outliers Before Calculating Averages

Graph Settings

Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
Micron 7450 Max 3.2TB
March 21
  5 Days, 20 Hours, 47 Minutes
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

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_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.0ext41920x1200ProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelDesktopDisplay 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 - NONE / relatime,rw,stripe=64 / 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)- 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

SSD Storagesqlite: 1sqlite: 8sqlite: 16fio: Rand Read - IO_uring - Yes - 2MB - 1 - Default Test Directoryfio: Rand Read - IO_uring - Yes - 2MB - 1 - Default Test Directoryfio: Rand Read - IO_uring - Yes - 4KB - 1 - Default Test Directoryfio: Rand Read - IO_uring - Yes - 4KB - 1 - Default Test Directoryfio: Rand Read - IO_uring - Yes - 2MB - 16 - Default Test Directoryfio: Rand Read - IO_uring - Yes - 2MB - 16 - Default Test Directoryfio: Rand Read - IO_uring - Yes - 2MB - 64 - Default Test Directoryfio: Rand Read - IO_uring - Yes - 2MB - 64 - Default Test Directoryfio: Rand Read - IO_uring - Yes - 4KB - 16 - Default Test Directoryfio: Rand Read - IO_uring - Yes - 4KB - 16 - Default Test Directoryfio: Rand Read - IO_uring - Yes - 4KB - 64 - Default Test Directoryfio: Rand Read - IO_uring - Yes - 4KB - 64 - Default Test Directoryfio: Rand Write - IO_uring - Yes - 2MB - 1 - Default Test Directoryfio: Rand Write - IO_uring - Yes - 2MB - 1 - Default Test Directoryfio: Rand Write - IO_uring - Yes - 4KB - 1 - Default Test Directoryfio: Rand Write - IO_uring - Yes - 4KB - 1 - Default Test Directoryfio: Rand Write - IO_uring - Yes - 2MB - 16 - Default Test Directoryfio: Rand Write - IO_uring - Yes - 2MB - 16 - Default Test Directoryfio: Rand Write - IO_uring - Yes - 2MB - 64 - Default Test Directoryfio: Rand Write - IO_uring - Yes - 2MB - 64 - Default Test Directoryfio: Rand Write - IO_uring - Yes - 4KB - 16 - Default Test Directoryfio: Rand Write - IO_uring - Yes - 4KB - 16 - Default Test Directoryfio: Rand Write - IO_uring - Yes - 4KB - 64 - Default Test Directoryfio: Rand Write - IO_uring - Yes - 4KB - 64 - Default Test Directoryfio: Seq Read - IO_uring - Yes - 2MB - 1 - Default Test Directoryfio: Seq Read - IO_uring - Yes - 2MB - 1 - Default Test Directoryfio: Seq Read - IO_uring - Yes - 4KB - 1 - Default Test Directoryfio: Seq Read - IO_uring - Yes - 4KB - 1 - Default Test Directoryfio: Seq Read - IO_uring - Yes - 2MB - 16 - Default Test Directoryfio: Seq Read - IO_uring - Yes - 2MB - 16 - Default Test Directoryfio: Seq Read - IO_uring - Yes - 2MB - 64 - Default Test Directoryfio: Seq Read - IO_uring - Yes - 2MB - 64 - Default Test Directoryfio: Seq Read - IO_uring - Yes - 4KB - 16 - Default Test Directoryfio: Seq Read - IO_uring - Yes - 4KB - 16 - Default Test Directoryfio: Seq Read - IO_uring - Yes - 4KB - 64 - Default Test Directoryfio: Seq Read - IO_uring - Yes - 4KB - 64 - Default Test Directoryfio: Seq Write - IO_uring - Yes - 2MB - 1 - Default Test Directoryfio: Seq Write - IO_uring - Yes - 2MB - 1 - Default Test Directoryfio: Seq Write - IO_uring - Yes - 4KB - 1 - Default Test Directoryfio: Seq Write - IO_uring - Yes - 4KB - 1 - Default Test Directoryfio: Seq Write - IO_uring - Yes - 2MB - 16 - Default Test Directoryfio: Seq Write - IO_uring - Yes - 2MB - 16 - Default Test Directoryfio: Seq Write - IO_uring - Yes - 2MB - 64 - Default Test Directoryfio: Seq Write - IO_uring - Yes - 2MB - 64 - Default Test Directoryfio: Seq Write - IO_uring - Yes - 4KB - 16 - Default Test Directoryfio: Seq Write - IO_uring - Yes - 4KB - 16 - Default Test Directoryfio: Seq Write - IO_uring - Yes - 4KB - 64 - Default Test Directoryfio: Seq Write - IO_uring - Yes - 4KB - 64 - Default Test Directoryclickhouse: 100M Rows Hits Dataset, First Run / Cold Cacheclickhouse: 100M Rows Hits Dataset, Second Runclickhouse: 100M Rows Hits Dataset, Third Runspark-tpcds: 50 - Q01spark-tpcds: 50 - Q02spark-tpcds: 50 - Q03spark-tpcds: 50 - Q05spark-tpcds: 50 - Q07spark-tpcds: 50 - Q08spark-tpcds: 50 - Q09spark-tpcds: 50 - Q10spark-tpcds: 50 - Q12spark-tpcds: 50 - Q13spark-tpcds: 50 - Q14spark-tpcds: 50 - Q15spark-tpcds: 50 - Q18spark-tpcds: 50 - Q19spark-tpcds: 50 - Q20spark-tpcds: 50 - Q21spark-tpcds: 50 - Q22spark-tpcds: 50 - Q26spark-tpcds: 50 - Q27spark-tpcds: 50 - Q28spark-tpcds: 50 - Q30spark-tpcds: 50 - Q31spark-tpcds: 50 - Q32spark-tpcds: 50 - Q33spark-tpcds: 50 - Q34spark-tpcds: 50 - Q35spark-tpcds: 50 - Q36spark-tpcds: 50 - Q37spark-tpcds: 50 - Q39spark-tpcds: 50 - Q40spark-tpcds: 50 - Q41spark-tpcds: 50 - Q42spark-tpcds: 50 - Q43spark-tpcds: 50 - Q44spark-tpcds: 50 - Q45spark-tpcds: 50 - Q46spark-tpcds: 50 - Q47spark-tpcds: 50 - Q48spark-tpcds: 50 - Q49spark-tpcds: 50 - Q52spark-tpcds: 50 - Q53spark-tpcds: 50 - Q54spark-tpcds: 50 - Q55spark-tpcds: 50 - Q56spark-tpcds: 50 - Q57spark-tpcds: 50 - Q58spark-tpcds: 50 - Q59spark-tpcds: 50 - Q60spark-tpcds: 50 - Q61spark-tpcds: 50 - Q62spark-tpcds: 50 - Q63spark-tpcds: 50 - Q66spark-tpcds: 50 - Q68spark-tpcds: 50 - Q69spark-tpcds: 50 - Q70spark-tpcds: 50 - Q71spark-tpcds: 50 - Q73spark-tpcds: 50 - Q75spark-tpcds: 50 - Q76spark-tpcds: 50 - Q77spark-tpcds: 50 - Q79spark-tpcds: 50 - Q81spark-tpcds: 50 - Q82spark-tpcds: 50 - Q83spark-tpcds: 50 - Q84spark-tpcds: 50 - Q85spark-tpcds: 50 - Q86spark-tpcds: 50 - Q88spark-tpcds: 50 - Q89spark-tpcds: 50 - Q90spark-tpcds: 50 - Q91spark-tpcds: 50 - Q92spark-tpcds: 50 - Q94spark-tpcds: 50 - Q95spark-tpcds: 50 - Q96spark-tpcds: 50 - Q98spark-tpcds: 50 - Q99spark-tpcds: 50 - Q87spark-tpcds: 50 - Q97spark-tpch: 50 - Geometric Mean Of All Queriesspark-tpch: 50 - Q01spark-tpch: 50 - Q02spark-tpch: 50 - Q03spark-tpch: 50 - Q04spark-tpch: 50 - Q05spark-tpch: 50 - Q06spark-tpch: 50 - Q07spark-tpch: 50 - Q08spark-tpch: 50 - Q09spark-tpch: 50 - Q10spark-tpch: 50 - Q11spark-tpch: 50 - Q12spark-tpch: 50 - Q13spark-tpch: 50 - Q14spark-tpch: 50 - Q15spark-tpch: 50 - Q16spark-tpch: 50 - Q17spark-tpch: 50 - Q18spark-tpch: 50 - Q19spark-tpch: 50 - Q20spark-tpch: 50 - Q21spark-tpch: 50 - Q22cockroach: KV, 50% Reads - 256cockroach: KV, 60% Reads - 256cockroach: KV, 95% Reads - 256apache-iotdb: 800 - 100 - 500 - 100apache-iotdb: 800 - 100 - 500 - 100apache-iotdb: 800 - 100 - 500 - 400apache-iotdb: 800 - 100 - 500 - 400apache-iotdb: 800 - 100 - 800 - 100apache-iotdb: 800 - 100 - 800 - 100apache-iotdb: 800 - 100 - 800 - 400apache-iotdb: 800 - 100 - 800 - 400duckdb: IMDBduckdb: TPC-H Parquetpgbench: 1000 - 1000 - Read Onlypgbench: 1000 - 1000 - Read Only - Average Latencypgbench: 1000 - 1000 - Read Writepgbench: 1000 - 1000 - Read Write - Average Latencycassandra: Writesrocksdb: Overwriterocksdb: Rand Fillrocksdb: Rand Readrocksdb: Update Randrocksdb: Seq Fillrocksdb: Rand Fill Syncrocksdb: Read While Writingrocksdb: Read Rand Write Randspeedb: Rand Fillspeedb: Rand Readspeedb: Update Randspeedb: Seq Fillspeedb: Rand Fill Syncspeedb: Read While Writingspeedb: Read Rand Write RandMicron 7450 Max 3.2TB2.2194.4157.454628731427501920006255312662733135751192333753192667509025445371373334967248249572477538137333535137000655332754621180006554327565493273467119667456116667495224745391380004990249349722484544139333541138333329.86336.49329.197.705.965.3712.597.946.848.569.312.557.8118.907.487.967.642.545.9810.227.058.6515.017.7213.735.709.317.1810.096.817.684.4611.483.445.105.463.307.388.0011.846.0714.275.295.329.785.558.087.719.017.819.413.195.935.528.497.628.747.307.366.7322.928.0910.237.887.558.167.236.5710.185.739.877.015.086.156.017.927.923.652.516.0515.7414.614.9217384813.663266826.8252097819.3535970015.1319335320.543671939.1426086418.3724721320.1103680925.4361565918.439212165.4459891314.930562028.1078095412.5730015411.257689487.0783934627.6126912430.4582697611.9157966015.3563855566.307975776.39924034101366.5107941.1125152.610299678046.13103788525176.6911654720565.61117249637255.96123.672171.19014317270.6994104624.365252621460592460413295332937445144463571296249103260453830310357972297019045337355355741224349125539152560373OpenBenchmarking.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.2TB0.49930.99861.49791.99722.4965SE +/- 0.000, N = 32.2191. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 8Micron 7450 Max 3.2TB0.99341.98682.98023.97364.967SE +/- 0.036, N = 34.4151. (CC) gcc options: -O2 -lreadline -ltermcap -lz -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.41.2Threads / Copies: 16Micron 7450 Max 3.2TB246810SE +/- 0.031, N = 37.4541. (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: Random Read - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 1 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB13002600390052006500SE +/- 11.89, N = 362871. (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: Random Read - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 1 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB7001400210028003500SE +/- 5.81, N = 331421. (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: Random Read - Engine: IO_uring - Direct: Yes - Block Size: 4KB - Job Count: 1 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB160320480640800SE +/- 2.52, N = 37501. (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: Random Read - Engine: IO_uring - Direct: Yes - Block Size: 4KB - Job Count: 1 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB40K80K120K160K200KSE +/- 577.35, N = 31920001. (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: Random Read - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 16 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB13002600390052006500SE +/- 6.06, N = 362551. (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: Random Read - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 16 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB7001400210028003500SE +/- 3.18, N = 331261. (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: Random Read - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 64 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB13002600390052006500SE +/- 13.68, N = 362731. (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: Random Read - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 64 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB7001400210028003500SE +/- 6.67, N = 331351. (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: Random Read - Engine: IO_uring - Direct: Yes - Block Size: 4KB - Job Count: 16 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB160320480640800SE +/- 1.20, N = 37511. (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: Random Read - Engine: IO_uring - Direct: Yes - Block Size: 4KB - Job Count: 16 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB40K80K120K160K200KSE +/- 333.33, N = 31923331. (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: Random Read - Engine: IO_uring - Direct: Yes - Block Size: 4KB - Job Count: 64 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB160320480640800SE +/- 1.45, N = 37531. (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: Random Read - Engine: IO_uring - Direct: Yes - Block Size: 4KB - Job Count: 64 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB40K80K120K160K200KSE +/- 333.33, N = 31926671. (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: Random Write - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 1 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB11002200330044005500SE +/- 56.78, N = 350901. (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: Random Write - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 1 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB5001000150020002500SE +/- 28.10, N = 325441. (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: Random Write - Engine: IO_uring - Direct: Yes - Block Size: 4KB - Job Count: 1 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB120240360480600SE +/- 1.76, N = 35371. (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: Random Write - Engine: IO_uring - Direct: Yes - Block Size: 4KB - Job Count: 1 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB30K60K90K120K150KSE +/- 333.33, N = 31373331. (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: Random Write - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 16 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB11002200330044005500SE +/- 24.89, N = 349671. (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: Random Write - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 16 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB5001000150020002500SE +/- 12.60, N = 324821. (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: Random Write - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 64 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB11002200330044005500SE +/- 3.21, N = 349571. (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: Random Write - Engine: IO_uring - Direct: Yes - Block Size: 2MB - Job Count: 64 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB5001000150020002500SE +/- 1.76, N = 324771. (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: Random Write - Engine: IO_uring - Direct: Yes - Block Size: 4KB - Job Count: 16 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB120240360480600SE +/- 1.20, N = 35381. (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: Random Write - Engine: IO_uring - Direct: Yes - Block Size: 4KB - Job Count: 16 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB30K60K90K120K150KSE +/- 333.33, N = 31373331. (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: Random Write - Engine: IO_uring - Direct: Yes - Block Size: 4KB - Job Count: 64 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB120240360480600SE +/- 0.58, N = 35351. (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: Random Write - Engine: IO_uring - Direct: Yes - Block Size: 4KB - Job Count: 64 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB30K60K90K120K150KSE +/- 0.00, N = 31370001. (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: 1 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB14002800420056007000SE +/- 13.97, N = 365531. (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: 1 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB7001400210028003500SE +/- 6.98, N = 332751. (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: 4KB - Job Count: 1 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB100200300400500SE +/- 4.67, N = 34621. (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: 4KB - Job Count: 1 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB30K60K90K120K150KSE +/- 1000.00, N = 31180001. (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: 16 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB14002800420056007000SE +/- 17.21, N = 365541. (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: 16 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB7001400210028003500SE +/- 8.76, N = 332751. (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.2TB14002800420056007000SE +/- 9.45, N = 365491. (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 DirectoryMicron 7450 Max 3.2TB7001400210028003500SE +/- 4.73, N = 332731. (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: 4KB - Job Count: 16 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB100200300400500SE +/- 5.29, N = 34671. (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: 4KB - Job Count: 16 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB30K60K90K120K150KSE +/- 1452.97, N = 31196671. (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: 4KB - Job Count: 64 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB100200300400500SE +/- 1.33, N = 34561. (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: 4KB - Job Count: 64 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB20K40K60K80K100KSE +/- 333.33, N = 31166671. (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.2TB11002200330044005500SE +/- 6.74, N = 349521. (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.2TB5001000150020002500SE +/- 3.28, N = 324741. (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: 4KB - Job Count: 1 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB120240360480600SE +/- 2.65, N = 35391. (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: 4KB - Job Count: 1 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB30K60K90K120K150KSE +/- 577.35, N = 31380001. (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.2TB11002200330044005500SE +/- 9.21, N = 349901. (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.2TB5001000150020002500SE +/- 4.48, N = 324931. (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: 64 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB11002200330044005500SE +/- 14.43, N = 349721. (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: 64 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB5001000150020002500SE +/- 7.13, N = 324841. (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: 4KB - Job Count: 16 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB120240360480600SE +/- 0.67, N = 35441. (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: 4KB - Job Count: 16 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB30K60K90K120K150KSE +/- 333.33, N = 31393331. (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: 4KB - Job Count: 64 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB120240360480600SE +/- 1.00, N = 35411. (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: 4KB - Job Count: 64 - Disk Target: Default Test DirectoryMicron 7450 Max 3.2TB30K60K90K120K150KSE +/- 333.33, N = 31383331. (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.2TB70140210280350SE +/- 3.71, N = 3329.86MIN: 38.34 / MAX: 5000

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse 22.12.3.5100M Rows Hits Dataset, Second RunMicron 7450 Max 3.2TB70140210280350SE +/- 3.46, N = 3336.49MIN: 37.9 / MAX: 3750

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse 22.12.3.5100M Rows Hits Dataset, Third RunMicron 7450 Max 3.2TB70140210280350SE +/- 2.21, N = 3329.19MIN: 38.63 / MAX: 3000

Apache Spark

This is a benchmark of Apache Spark with its PySpark interface. Apache Spark is an open-source unified analytics engine for large-scale data processing and dealing with big data. This test profile benchmars the Apache Spark in a single-system configuration using spark-submit. The test makes use of DIYBigData's pyspark-benchmark (https://github.com/DIYBigData/pyspark-benchmark/) for generating of test data and various Apache Spark operations. Learn more via the OpenBenchmarking.org test page.

Row Count: 10000000 - Partitions: 500

Micron 7450 Max 3.2TB: The test run did not produce a result. E: _pickle.PicklingError: Could not serialize object: IndexError: tuple index out of range

Apache Spark TPC-DS

This is a benchmark of Apache Spark using the TPC-DS data-set. Apache Spark is an open-source unified analytics engine for large-scale data processing and dealing with big data. This test profile benchmarks the Apache Spark in a single-system configuration and leverages the https://github.com/databricks/tpcds-kit and https://github.com/IBM/spark-tpc-ds-performance-test/ projects for testing. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q01Micron 7450 Max 3.2TB246810SE +/- 0.08, N = 37.701. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q02Micron 7450 Max 3.2TB1.3412.6824.0235.3646.705SE +/- 0.11, N = 35.961. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q03Micron 7450 Max 3.2TB1.20832.41663.62494.83326.0415SE +/- 0.06, N = 35.371. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q05Micron 7450 Max 3.2TB3691215SE +/- 0.31, N = 212.591. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q07Micron 7450 Max 3.2TB246810SE +/- 0.21, N = 37.941. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q08Micron 7450 Max 3.2TB246810SE +/- 0.24, N = 36.841. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q09Micron 7450 Max 3.2TB246810SE +/- 0.39, N = 38.561. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q10Micron 7450 Max 3.2TB3691215SE +/- 0.19, N = 39.311. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q12Micron 7450 Max 3.2TB0.57381.14761.72142.29522.869SE +/- 0.00, N = 32.551. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q13Micron 7450 Max 3.2TB246810SE +/- 0.16, N = 37.811. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q14Micron 7450 Max 3.2TB510152025SE +/- 0.18, N = 318.901. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q15Micron 7450 Max 3.2TB246810SE +/- 0.14, N = 37.481. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q18Micron 7450 Max 3.2TB246810SE +/- 0.41, N = 37.961. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q19Micron 7450 Max 3.2TB246810SE +/- 0.17, N = 37.641. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q20Micron 7450 Max 3.2TB0.57151.1431.71452.2862.8575SE +/- 0.02, N = 32.541. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q21Micron 7450 Max 3.2TB1.34552.6914.03655.3826.7275SE +/- 0.33, N = 35.981. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q22Micron 7450 Max 3.2TB3691215SE +/- 0.83, N = 310.221. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q26Micron 7450 Max 3.2TB246810SE +/- 0.65, N = 37.051. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q27Micron 7450 Max 3.2TB246810SE +/- 0.23, N = 38.651. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q28Micron 7450 Max 3.2TB48121620SE +/- 0.35, N = 315.011. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q30Micron 7450 Max 3.2TB246810SE +/- 0.13, N = 37.721. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q31Micron 7450 Max 3.2TB48121620SE +/- 0.16, N = 313.731. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q32Micron 7450 Max 3.2TB1.28252.5653.84755.136.4125SE +/- 0.12, N = 35.701. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q33Micron 7450 Max 3.2TB3691215SE +/- 0.27, N = 39.311. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q34Micron 7450 Max 3.2TB246810SE +/- 0.09, N = 37.181. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q35Micron 7450 Max 3.2TB3691215SE +/- 0.13, N = 310.091. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q36Micron 7450 Max 3.2TB246810SE +/- 0.14, N = 36.811. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q37Micron 7450 Max 3.2TB246810SE +/- 0.40, N = 37.681. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q39Micron 7450 Max 3.2TB1.00352.0073.01054.0145.0175SE +/- 0.04, N = 34.461. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q40Micron 7450 Max 3.2TB3691215SE +/- 0.02, N = 311.481. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q41Micron 7450 Max 3.2TB0.7741.5482.3223.0963.87SE +/- 0.02, N = 33.441. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q42Micron 7450 Max 3.2TB1.14752.2953.44254.595.7375SE +/- 0.31, N = 35.101. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q43Micron 7450 Max 3.2TB1.22852.4573.68554.9146.1425SE +/- 0.30, N = 35.461. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q44Micron 7450 Max 3.2TB0.74251.4852.22752.973.7125SE +/- 0.02, N = 33.301. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q45Micron 7450 Max 3.2TB246810SE +/- 0.13, N = 37.381. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q46Micron 7450 Max 3.2TB246810SE +/- 0.09, N = 38.001. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q47Micron 7450 Max 3.2TB3691215SE +/- 0.01, N = 211.841. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q48Micron 7450 Max 3.2TB246810SE +/- 0.42, N = 36.071. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q49Micron 7450 Max 3.2TB48121620SE +/- 0.18, N = 314.271. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q52Micron 7450 Max 3.2TB1.19032.38063.57094.76125.9515SE +/- 0.07, N = 35.291. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q53Micron 7450 Max 3.2TB1.1972.3943.5914.7885.985SE +/- 0.03, N = 35.321. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q54Micron 7450 Max 3.2TB3691215SE +/- 0.04, N = 39.781. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q55Micron 7450 Max 3.2TB1.24882.49763.74644.99526.244SE +/- 0.23, N = 35.551. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q56Micron 7450 Max 3.2TB246810SE +/- 0.18, N = 38.081. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q57Micron 7450 Max 3.2TB246810SE +/- 0.26, N = 37.711. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q58Micron 7450 Max 3.2TB3691215SE +/- 0.28, N = 39.011. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q59Micron 7450 Max 3.2TB246810SE +/- 0.04, N = 37.811. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q60Micron 7450 Max 3.2TB3691215SE +/- 0.39, N = 39.411. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q61Micron 7450 Max 3.2TB0.71781.43562.15342.87123.589SE +/- 0.01, N = 33.191. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q62Micron 7450 Max 3.2TB1.33432.66864.00295.33726.6715SE +/- 0.17, N = 35.931. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q63Micron 7450 Max 3.2TB1.2422.4843.7264.9686.21SE +/- 0.20, N = 35.521. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q66Micron 7450 Max 3.2TB246810SE +/- 0.20, N = 38.491. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q68Micron 7450 Max 3.2TB246810SE +/- 0.37, N = 37.621. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q69Micron 7450 Max 3.2TB246810SE +/- 0.07, N = 38.741. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q70Micron 7450 Max 3.2TB246810SE +/- 0.48, N = 37.301. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q71Micron 7450 Max 3.2TB246810SE +/- 0.12, N = 37.361. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q73Micron 7450 Max 3.2TB246810SE +/- 0.50, N = 36.731. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q75Micron 7450 Max 3.2TB510152025SE +/- 0.19, N = 322.921. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q76Micron 7450 Max 3.2TB246810SE +/- 0.28, N = 38.091. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q77Micron 7450 Max 3.2TB3691215SE +/- 0.38, N = 310.231. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q79Micron 7450 Max 3.2TB246810SE +/- 0.09, N = 37.881. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q81Micron 7450 Max 3.2TB246810SE +/- 0.07, N = 37.551. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q82Micron 7450 Max 3.2TB246810SE +/- 0.18, N = 38.161. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q83Micron 7450 Max 3.2TB246810SE +/- 0.22, N = 37.231. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q84Micron 7450 Max 3.2TB246810SE +/- 0.21, N = 36.571. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q85Micron 7450 Max 3.2TB3691215SE +/- 0.18, N = 310.181. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q86Micron 7450 Max 3.2TB1.28932.57863.86795.15726.4465SE +/- 0.35, N = 35.731. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q88Micron 7450 Max 3.2TB3691215SE +/- 0.35, N = 39.871. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q89Micron 7450 Max 3.2TB246810SE +/- 0.18, N = 37.011. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q90Micron 7450 Max 3.2TB1.1432.2863.4294.5725.715SE +/- 0.12, N = 35.081. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q91Micron 7450 Max 3.2TB246810SE +/- 0.11, N = 36.151. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q92Micron 7450 Max 3.2TB246810SE +/- 0.15, N = 36.011. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q94Micron 7450 Max 3.2TB246810SE +/- 0.06, N = 37.921. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q95Micron 7450 Max 3.2TB246810SE +/- 0.11, N = 37.921. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q96Micron 7450 Max 3.2TB0.82131.64262.46393.28524.1065SE +/- 0.09, N = 33.651. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q98Micron 7450 Max 3.2TB0.56481.12961.69442.25922.824SE +/- 0.02, N = 32.511. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q99Micron 7450 Max 3.2TB246810SE +/- 0.18, N = 36.051. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q87Micron 7450 Max 3.2TB4812162015.741. (CC) gcc options: -O3 -fcommon -lm

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-DS 3.5Scale Factor: 50 - Q97Micron 7450 Max 3.2TB4812162014.61. (CC) gcc options: -O3 -fcommon -lm

Apache Spark TPC-H

This is a benchmark of Apache Spark using TPC-H data-set. Apache Spark is an open-source unified analytics engine for large-scale data processing and dealing with big data. This test profile benchmarks the Apache Spark in a single-system configuration using spark-submit. The test makes use of https://github.com/ssavvides/tpch-spark/ for facilitating the TPC-H benchmark. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Geometric Mean Of All QueriesMicron 7450 Max 3.2TB48121620SE +/- 0.14, N = 314.92MIN: 5.36 / MAX: 67.83
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q01Micron 7450 Max 3.2TB48121620SE +/- 0.13, N = 313.66
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q02Micron 7450 Max 3.2TB246810SE +/- 0.19269132, N = 36.82520978
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q03Micron 7450 Max 3.2TB510152025SE +/- 0.52, N = 319.35
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q04Micron 7450 Max 3.2TB48121620SE +/- 0.31, N = 315.13
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q05Micron 7450 Max 3.2TB510152025SE +/- 0.09, N = 320.54
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q06Micron 7450 Max 3.2TB3691215SE +/- 0.02466738, N = 39.14260864
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q07Micron 7450 Max 3.2TB510152025SE +/- 0.19, N = 318.37
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q08Micron 7450 Max 3.2TB510152025SE +/- 0.33, N = 320.11
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q09Micron 7450 Max 3.2TB612182430SE +/- 0.23, N = 325.44
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q10Micron 7450 Max 3.2TB510152025SE +/- 0.24, N = 318.44
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q11Micron 7450 Max 3.2TB1.22532.45063.67594.90126.1265SE +/- 0.04582449, N = 35.44598913
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q12Micron 7450 Max 3.2TB48121620SE +/- 0.36, N = 314.93
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q13Micron 7450 Max 3.2TB246810SE +/- 0.46108800, N = 38.10780954
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q14Micron 7450 Max 3.2TB3691215SE +/- 0.17, N = 312.57
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q15Micron 7450 Max 3.2TB3691215SE +/- 0.14, N = 311.26
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q16Micron 7450 Max 3.2TB246810SE +/- 0.04045296, N = 37.07839346
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q17Micron 7450 Max 3.2TB612182430SE +/- 0.16, N = 327.61
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q18Micron 7450 Max 3.2TB714212835SE +/- 0.35, N = 330.46
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q19Micron 7450 Max 3.2TB3691215SE +/- 0.21, N = 311.92
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q20Micron 7450 Max 3.2TB48121620SE +/- 0.08, N = 315.36
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q21Micron 7450 Max 3.2TB1530456075SE +/- 0.77, N = 366.31
OpenBenchmarking.orgSeconds, Fewer Is BetterApache Spark TPC-H 3.5Scale Factor: 50 - Q22Micron 7450 Max 3.2TB246810SE +/- 0.16298925, N = 36.39924034

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.2TB20K40K60K80K100KSE +/- 1341.10, N = 15101366.5

OpenBenchmarking.orgops/s, More Is BetterCockroachDB 22.2Workload: KV, 60% Reads - Concurrency: 256Micron 7450 Max 3.2TB20K40K60K80K100KSE +/- 1417.12, N = 15107941.1

OpenBenchmarking.orgops/s, More Is BetterCockroachDB 22.2Workload: KV, 95% Reads - Concurrency: 256Micron 7450 Max 3.2TB30K60K90K120K150KSE +/- 2278.37, N = 15125152.6

Apache IoTDB

Apache IotDB is a time series database and this benchmark is facilitated using the IoT Benchmaark [https://github.com/thulab/iot-benchmark/]. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgpoint/sec, More Is BetterApache IoTDB 1.2Device Count: 800 - Batch Size Per Write: 100 - Sensor Count: 500 - Client Number: 100Micron 7450 Max 3.2TB20M40M60M80M100MSE +/- 1210278.48, N = 4102996780

OpenBenchmarking.orgAverage Latency, Fewer Is BetterApache IoTDB 1.2Device Count: 800 - Batch Size Per Write: 100 - Sensor Count: 500 - Client Number: 100Micron 7450 Max 3.2TB1020304050SE +/- 0.55, N = 446.13MAX: 23895.37

OpenBenchmarking.orgpoint/sec, More Is BetterApache IoTDB 1.2Device Count: 800 - Batch Size Per Write: 100 - Sensor Count: 500 - Client Number: 400Micron 7450 Max 3.2TB20M40M60M80M100MSE +/- 609625.44, N = 3103788525

OpenBenchmarking.orgAverage Latency, Fewer Is BetterApache IoTDB 1.2Device Count: 800 - Batch Size Per Write: 100 - Sensor Count: 500 - Client Number: 400Micron 7450 Max 3.2TB4080120160200SE +/- 2.23, N = 3176.69MAX: 27898.93

OpenBenchmarking.orgpoint/sec, More Is BetterApache IoTDB 1.2Device Count: 800 - Batch Size Per Write: 100 - Sensor Count: 800 - Client Number: 100Micron 7450 Max 3.2TB20M40M60M80M100MSE +/- 303862.14, N = 3116547205

OpenBenchmarking.orgAverage Latency, Fewer Is BetterApache IoTDB 1.2Device Count: 800 - Batch Size Per Write: 100 - Sensor Count: 800 - Client Number: 100Micron 7450 Max 3.2TB1530456075SE +/- 0.14, N = 365.61MAX: 22599.94

OpenBenchmarking.orgpoint/sec, More Is BetterApache IoTDB 1.2Device Count: 800 - Batch Size Per Write: 100 - Sensor Count: 800 - Client Number: 400Micron 7450 Max 3.2TB30M60M90M120M150MSE +/- 652301.47, N = 3117249637

OpenBenchmarking.orgAverage Latency, Fewer Is BetterApache IoTDB 1.2Device Count: 800 - Batch Size Per Write: 100 - Sensor Count: 800 - Client Number: 400Micron 7450 Max 3.2TB60120180240300SE +/- 1.55, N = 3255.96MAX: 27116.15

Dragonflydb

Dragonfly is an open-source database server that is a "modern Redis replacement" that aims to be the fastest memory store while being compliant with the Redis and Memcached protocols. For benchmarking Dragonfly, Memtier_benchmark is used as a NoSQL Redis/Memcache traffic generation plus benchmarking tool developed by Redis Labs. Learn more via the OpenBenchmarking.org test page.

Clients Per Thread: 20 - Set To Get Ratio: 1:10

Micron 7450 Max 3.2TB: The test run did not produce a result. E: Connection error: Connection refused

Clients Per Thread: 20 - Set To Get Ratio: 1:100

Micron 7450 Max 3.2TB: The test run did not produce a result. E: Connection error: Connection refused

DuckDB

DuckDB is an in-progress SQL OLAP database management system optimized for analytics and features a vectorized and parallel engine. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgSeconds, Fewer Is BetterDuckDB 0.9.1Benchmark: IMDBMicron 7450 Max 3.2TB306090120150SE +/- 0.43, N = 3123.671. (CXX) g++ options: -O3 -rdynamic -lssl -lcrypto -ldl

OpenBenchmarking.orgSeconds, Fewer Is BetterDuckDB 0.9.1Benchmark: TPC-H ParquetMicron 7450 Max 3.2TB4080120160200SE +/- 0.30, N = 3171.191. (CXX) g++ options: -O3 -rdynamic -lssl -lcrypto -ldl

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 OnlyMicron 7450 Max 3.2TB300K600K900K1200K1500KSE +/- 14572.86, N = 314317271. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only - Average LatencyMicron 7450 Max 3.2TB0.15730.31460.47190.62920.7865SE +/- 0.007, N = 30.6991. (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.2TB9K18K27K36K45KSE +/- 310.04, N = 3410461. (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.2TB612182430SE +/- 0.18, N = 324.371. (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.2TB50K100K150K200K250KSE +/- 1354.41, N = 3252621

RocksDB

OpenBenchmarking.orgOp/s, More Is BetterRocksDB 9.0Test: OverwriteMicron 7450 Max 3.2TB100K200K300K400K500KSE +/- 538.15, N = 34605921. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

OpenBenchmarking.orgOp/s, More Is BetterRocksDB 9.0Test: Random FillMicron 7450 Max 3.2TB100K200K300K400K500KSE +/- 857.70, N = 34604131. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

OpenBenchmarking.orgOp/s, More Is BetterRocksDB 9.0Test: Random ReadMicron 7450 Max 3.2TB60M120M180M240M300MSE +/- 258617.98, N = 32953329371. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

OpenBenchmarking.orgOp/s, More Is BetterRocksDB 9.0Test: Update RandomMicron 7450 Max 3.2TB100K200K300K400K500KSE +/- 967.72, N = 34451441. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

OpenBenchmarking.orgOp/s, More Is BetterRocksDB 9.0Test: Sequential FillMicron 7450 Max 3.2TB100K200K300K400K500KSE +/- 1128.25, N = 34635711. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

OpenBenchmarking.orgOp/s, More Is BetterRocksDB 9.0Test: Random Fill SyncMicron 7450 Max 3.2TB60K120K180K240K300KSE +/- 490.47, N = 32962491. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

OpenBenchmarking.orgOp/s, More Is BetterRocksDB 9.0Test: Read While WritingMicron 7450 Max 3.2TB2M4M6M8M10MSE +/- 121089.12, N = 3103260451. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

OpenBenchmarking.orgOp/s, More Is BetterRocksDB 9.0Test: Read Random Write RandomMicron 7450 Max 3.2TB800K1600K2400K3200K4000KSE +/- 19773.38, N = 338303101. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

Speedb

Speedb is a next-generation key value storage engine that is RocksDB compatible and aiming for stability, efficiency, and performance. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgOp/s, More Is BetterSpeedb 2.7Test: Random FillMicron 7450 Max 3.2TB80K160K240K320K400KSE +/- 959.88, N = 33579721. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

OpenBenchmarking.orgOp/s, More Is BetterSpeedb 2.7Test: Random ReadMicron 7450 Max 3.2TB60M120M180M240M300MSE +/- 99742.78, N = 32970190451. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

OpenBenchmarking.orgOp/s, More Is BetterSpeedb 2.7Test: Update RandomMicron 7450 Max 3.2TB70K140K210K280K350KSE +/- 973.98, N = 33373551. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

OpenBenchmarking.orgOp/s, More Is BetterSpeedb 2.7Test: Sequential FillMicron 7450 Max 3.2TB80K160K240K320K400KSE +/- 840.48, N = 33557411. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

OpenBenchmarking.orgOp/s, More Is BetterSpeedb 2.7Test: Random Fill SyncMicron 7450 Max 3.2TB50K100K150K200K250KSE +/- 672.90, N = 32243491. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

OpenBenchmarking.orgOp/s, More Is BetterSpeedb 2.7Test: Read While WritingMicron 7450 Max 3.2TB3M6M9M12M15MSE +/- 125324.59, N = 6125539151. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

OpenBenchmarking.orgOp/s, More Is BetterSpeedb 2.7Test: Read Random Write RandomMicron 7450 Max 3.2TB500K1000K1500K2000K2500KSE +/- 7774.19, N = 325603731. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

167 Results Shown

SQLite:
  1
  8
  16
Flexible IO Tester:
  Rand Read - IO_uring - Yes - 2MB - 1 - Default Test Directory:
    MB/s
    IOPS
  Rand Read - IO_uring - Yes - 4KB - 1 - Default Test Directory:
    MB/s
    IOPS
  Rand Read - IO_uring - Yes - 2MB - 16 - Default Test Directory:
    MB/s
    IOPS
  Rand Read - IO_uring - Yes - 2MB - 64 - Default Test Directory:
    MB/s
    IOPS
  Rand Read - IO_uring - Yes - 4KB - 16 - Default Test Directory:
    MB/s
    IOPS
  Rand Read - IO_uring - Yes - 4KB - 64 - Default Test Directory:
    MB/s
    IOPS
  Rand Write - IO_uring - Yes - 2MB - 1 - Default Test Directory:
    MB/s
    IOPS
  Rand Write - IO_uring - Yes - 4KB - 1 - Default Test Directory:
    MB/s
    IOPS
  Rand Write - IO_uring - Yes - 2MB - 16 - Default Test Directory:
    MB/s
    IOPS
  Rand Write - IO_uring - Yes - 2MB - 64 - Default Test Directory:
    MB/s
    IOPS
  Rand Write - IO_uring - Yes - 4KB - 16 - Default Test Directory:
    MB/s
    IOPS
  Rand Write - IO_uring - Yes - 4KB - 64 - Default Test Directory:
    MB/s
    IOPS
  Seq Read - IO_uring - Yes - 2MB - 1 - Default Test Directory:
    MB/s
    IOPS
  Seq Read - IO_uring - Yes - 4KB - 1 - Default Test Directory:
    MB/s
    IOPS
  Seq Read - IO_uring - Yes - 2MB - 16 - Default Test Directory:
    MB/s
    IOPS
  Seq Read - IO_uring - Yes - 2MB - 64 - Default Test Directory:
    MB/s
    IOPS
  Seq Read - IO_uring - Yes - 4KB - 16 - Default Test Directory:
    MB/s
    IOPS
  Seq Read - IO_uring - Yes - 4KB - 64 - Default Test Directory:
    MB/s
    IOPS
  Seq Write - IO_uring - Yes - 2MB - 1 - Default Test Directory:
    MB/s
    IOPS
  Seq Write - IO_uring - Yes - 4KB - 1 - Default Test Directory:
    MB/s
    IOPS
  Seq Write - IO_uring - Yes - 2MB - 16 - Default Test Directory:
    MB/s
    IOPS
  Seq Write - IO_uring - Yes - 2MB - 64 - Default Test Directory:
    MB/s
    IOPS
  Seq Write - IO_uring - Yes - 4KB - 16 - Default Test Directory:
    MB/s
    IOPS
  Seq Write - IO_uring - Yes - 4KB - 64 - Default Test Directory:
    MB/s
    IOPS
ClickHouse:
  100M Rows Hits Dataset, First Run / Cold Cache
  100M Rows Hits Dataset, Second Run
  100M Rows Hits Dataset, Third Run
Apache Spark TPC-DS:
  50 - Q01
  50 - Q02
  50 - Q03
  50 - Q05
  50 - Q07
  50 - Q08
  50 - Q09
  50 - Q10
  50 - Q12
  50 - Q13
  50 - Q14
  50 - Q15
  50 - Q18
  50 - Q19
  50 - Q20
  50 - Q21
  50 - Q22
  50 - Q26
  50 - Q27
  50 - Q28
  50 - Q30
  50 - Q31
  50 - Q32
  50 - Q33
  50 - Q34
  50 - Q35
  50 - Q36
  50 - Q37
  50 - Q39
  50 - Q40
  50 - Q41
  50 - Q42
  50 - Q43
  50 - Q44
  50 - Q45
  50 - Q46
  50 - Q47
  50 - Q48
  50 - Q49
  50 - Q52
  50 - Q53
  50 - Q54
  50 - Q55
  50 - Q56
  50 - Q57
  50 - Q58
  50 - Q59
  50 - Q60
  50 - Q61
  50 - Q62
  50 - Q63
  50 - Q66
  50 - Q68
  50 - Q69
  50 - Q70
  50 - Q71
  50 - Q73
  50 - Q75
  50 - Q76
  50 - Q77
  50 - Q79
  50 - Q81
  50 - Q82
  50 - Q83
  50 - Q84
  50 - Q85
  50 - Q86
  50 - Q88
  50 - Q89
  50 - Q90
  50 - Q91
  50 - Q92
  50 - Q94
  50 - Q95
  50 - Q96
  50 - Q98
  50 - Q99
  50 - Q87
  50 - Q97
Apache Spark TPC-H
CockroachDB:
  KV, 50% Reads - 256
  KV, 60% Reads - 256
  KV, 95% Reads - 256
Apache IoTDB:
  800 - 100 - 500 - 100:
    point/sec
    Average Latency
  800 - 100 - 500 - 400:
    point/sec
    Average Latency
  800 - 100 - 800 - 100:
    point/sec
    Average Latency
  800 - 100 - 800 - 400:
    point/sec
    Average Latency
DuckDB:
  IMDB
  TPC-H Parquet
PostgreSQL:
  1000 - 1000 - Read Only
  1000 - 1000 - Read Only - Average Latency
  1000 - 1000 - Read Write
  1000 - 1000 - Read Write - Average Latency
Apache Cassandra
RocksDB:
  Overwrite
  Rand Fill
  Rand Read
  Update Rand
  Seq Fill
  Rand Fill Sync
  Read While Writing
  Read Rand Write Rand
Speedb:
  Rand Fill
  Rand Read
  Update Rand
  Seq Fill
  Rand Fill Sync
  Read While Writing
  Read Rand Write Rand

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.