test-mariadb

AMD GX-424CC SOC testing with a Advantech Co DPX-W256 (W2560000060V116 BIOS) and AMD Radeon R4/R5 256MB on Ubuntu 20.04 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 2108047-IB-TESTMARIA59
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
View Logs
Performance Per
Dollar
Date
Run
  Test
  Duration
AMD GX-424CC SOC - AMD Radeon R4/R5 256MB - Advantech
August 01 2021
  17 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):

AMD GX-424CC SOC - AMD Radeon R4/R5 256MB - Advantech

Processor: AMD GX-424CC SOC @ 2.40GHz (4 Cores), Motherboard: Advantech Co DPX-W256 (W2560000060V116 BIOS), Chipset: AMD 16h, Memory: 2 x 4096 MB DDR3-1600MT/s SQR-SD3N-4G1K6SSGB, Disk: 32GB SQF-SLMV1-32G-BS + 250GB SSD 860 EVO mSAT, Graphics: AMD Radeon R4/R5 256MB (300MHz), Audio: AMD Kabini HDMI/DP, Network: 2 x Realtek RTL8111/8168/8411

OS: Ubuntu 20.04, Kernel: 5.8.0-63-generic (x86_64), Desktop: GNOME Shell 3.36.9, Display Server: X Server, OpenGL: 4.5 Mesa 20.2.6 (LLVM 11.0.0), Compiler: GCC 9.3.0, File-System: ext4, Screen Resolution: 1920x1080

Kernel Notes: Transparent Huge Pages: madvise
Compiler Notes: --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++,gm2 --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-9-HskZEa/gcc-9-9.3.0/debian/tmp-nvptx/usr,hsa --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-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
Processor Notes: Scaling Governor: acpi-cpufreq ondemand - CPU Microcode: 0x7030105
Security Notes: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Full AMD retpoline STIBP: disabled RSB filling + srbds: Not affected + tsx_async_abort: Not affected

test-mariadbOpenBenchmarking.orgPhoronix Test SuiteAMD GX-424CC SOC @ 2.40GHz (4 Cores)Advantech Co DPX-W256 (W2560000060V116 BIOS)AMD 16h2 x 4096 MB DDR3-1600MT/s SQR-SD3N-4G1K6SSGB32GB SQF-SLMV1-32G-BS + 250GB SSD 860 EVO mSATAMD Radeon R4/R5 256MB (300MHz)AMD Kabini HDMI/DP2 x Realtek RTL8111/8168/8411Ubuntu 20.045.8.0-63-generic (x86_64)GNOME Shell 3.36.9X Server4.5 Mesa 20.2.6 (LLVM 11.0.0)GCC 9.3.0ext41920x1080ProcessorMotherboardChipsetMemoryDiskGraphicsAudioNetworkOSKernelDesktopDisplay ServerOpenGLCompilerFile-SystemScreen ResolutionTest-mariadb BenchmarksSystem Logs- Transparent Huge Pages: madvise- --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++,gm2 --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-9-HskZEa/gcc-9-9.3.0/debian/tmp-nvptx/usr,hsa --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-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 - Scaling Governor: acpi-cpufreq ondemand - CPU Microcode: 0x7030105 - itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Full AMD retpoline STIBP: disabled RSB filling + srbds: Not affected + tsx_async_abort: Not affected

test-mariadbhammerdb-mariadb: 8 - 250hammerdb-mariadb: 8 - 250hammerdb-mariadb: 8 - 500hammerdb-mariadb: 8 - 500hammerdb-mariadb: 16 - 250hammerdb-mariadb: 16 - 250hammerdb-mariadb: 16 - 500hammerdb-mariadb: 16 - 500hammerdb-mariadb: 32 - 250hammerdb-mariadb: 32 - 250hammerdb-mariadb: 32 - 500hammerdb-mariadb: 32 - 500hammerdb-mariadb: 64 - 250hammerdb-mariadb: 64 - 250hammerdb-mariadb: 64 - 500hammerdb-mariadb: 64 - 500mysqlslap: 1mysqlslap: 4mysqlslap: 8mysqlslap: 16mysqlslap: 32mysqlslap: 64mysqlslap: 128mysqlslap: 256mysqlslap: 512AMD GX-424CC SOC - AMD Radeon R4/R5 256MB - Advantech784123872770523300724421991711721520627518951446613486532516218474514240304618411198659339167776433OpenBenchmarking.org

HammerDB - MariaDB

This is a MariaDB MySQL database server benchmark making use of the HammerDB benchmarking / load testing tool. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - MariaDB 10.5.9Virtual Users: 8 - Warehouses: 250AMD GX-424CC SOC - AMD Radeon R4/R5 256MB - Advantech2K4K6K8K10KSE +/- 46.64, N = 378411. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -llzma -lbz2 -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - MariaDB 10.5.9Virtual Users: 8 - Warehouses: 250AMD GX-424CC SOC - AMD Radeon R4/R5 256MB - Advantech5K10K15K20K25KSE +/- 162.87, N = 3238721. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -llzma -lbz2 -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - MariaDB 10.5.9Virtual Users: 8 - Warehouses: 500AMD GX-424CC SOC - AMD Radeon R4/R5 256MB - Advantech17003400510068008500SE +/- 44.76, N = 377051. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -llzma -lbz2 -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - MariaDB 10.5.9Virtual Users: 8 - Warehouses: 500AMD GX-424CC SOC - AMD Radeon R4/R5 256MB - Advantech5K10K15K20K25KSE +/- 87.93, N = 3233001. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -llzma -lbz2 -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - MariaDB 10.5.9Virtual Users: 16 - Warehouses: 250AMD GX-424CC SOC - AMD Radeon R4/R5 256MB - Advantech16003200480064008000SE +/- 88.10, N = 372441. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -llzma -lbz2 -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - MariaDB 10.5.9Virtual Users: 16 - Warehouses: 250AMD GX-424CC SOC - AMD Radeon R4/R5 256MB - Advantech5K10K15K20K25KSE +/- 255.44, N = 3219911. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -llzma -lbz2 -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - MariaDB 10.5.9Virtual Users: 16 - Warehouses: 500AMD GX-424CC SOC - AMD Radeon R4/R5 256MB - Advantech15003000450060007500SE +/- 63.61, N = 371171. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -llzma -lbz2 -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - MariaDB 10.5.9Virtual Users: 16 - Warehouses: 500AMD GX-424CC SOC - AMD Radeon R4/R5 256MB - Advantech5K10K15K20K25KSE +/- 193.92, N = 3215201. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -llzma -lbz2 -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - MariaDB 10.5.9Virtual Users: 32 - Warehouses: 250AMD GX-424CC SOC - AMD Radeon R4/R5 256MB - Advantech13002600390052006500SE +/- 54.69, N = 362751. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -llzma -lbz2 -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - MariaDB 10.5.9Virtual Users: 32 - Warehouses: 250AMD GX-424CC SOC - AMD Radeon R4/R5 256MB - Advantech4K8K12K16K20KSE +/- 85.83, N = 3189511. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -llzma -lbz2 -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - MariaDB 10.5.9Virtual Users: 32 - Warehouses: 500AMD GX-424CC SOC - AMD Radeon R4/R5 256MB - Advantech10002000300040005000SE +/- 19.70, N = 344661. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -llzma -lbz2 -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - MariaDB 10.5.9Virtual Users: 32 - Warehouses: 500AMD GX-424CC SOC - AMD Radeon R4/R5 256MB - Advantech3K6K9K12K15KSE +/- 80.71, N = 3134861. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -llzma -lbz2 -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - MariaDB 10.5.9Virtual Users: 64 - Warehouses: 250AMD GX-424CC SOC - AMD Radeon R4/R5 256MB - Advantech11002200330044005500SE +/- 66.08, N = 353251. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -llzma -lbz2 -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - MariaDB 10.5.9Virtual Users: 64 - Warehouses: 250AMD GX-424CC SOC - AMD Radeon R4/R5 256MB - Advantech3K6K9K12K15KSE +/- 299.52, N = 3162181. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -llzma -lbz2 -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

OpenBenchmarking.orgNew Orders Per Minute, More Is BetterHammerDB - MariaDB 10.5.9Virtual Users: 64 - Warehouses: 500AMD GX-424CC SOC - AMD Radeon R4/R5 256MB - Advantech10002000300040005000SE +/- 21.57, N = 347451. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -llzma -lbz2 -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

OpenBenchmarking.orgTransactions Per Minute, More Is BetterHammerDB - MariaDB 10.5.9Virtual Users: 64 - Warehouses: 500AMD GX-424CC SOC - AMD Radeon R4/R5 256MB - Advantech3K6K9K12K15KSE +/- 46.70, N = 3142401. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -llzma -lbz2 -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

MariaDB

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

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 1AMD GX-424CC SOC - AMD Radeon R4/R5 256MB - Advantech7001400210028003500SE +/- 3.09, N = 330461. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -llzma -lbz2 -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 4AMD GX-424CC SOC - AMD Radeon R4/R5 256MB - Advantech400800120016002000SE +/- 2.98, N = 318411. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -llzma -lbz2 -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 8AMD GX-424CC SOC - AMD Radeon R4/R5 256MB - Advantech30060090012001500SE +/- 2.99, N = 311981. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -llzma -lbz2 -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 16AMD GX-424CC SOC - AMD Radeon R4/R5 256MB - Advantech140280420560700SE +/- 0.90, N = 36591. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -llzma -lbz2 -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 32AMD GX-424CC SOC - AMD Radeon R4/R5 256MB - Advantech70140210280350SE +/- 1.87, N = 33391. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -llzma -lbz2 -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 64AMD GX-424CC SOC - AMD Radeon R4/R5 256MB - Advantech4080120160200SE +/- 0.16, N = 31671. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -llzma -lbz2 -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 128AMD GX-424CC SOC - AMD Radeon R4/R5 256MB - Advantech20406080100SE +/- 0.51, N = 3771. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -llzma -lbz2 -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 256AMD GX-424CC SOC - AMD Radeon R4/R5 256MB - Advantech1428425670SE +/- 0.27, N = 3641. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -llzma -lbz2 -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 512AMD GX-424CC SOC - AMD Radeon R4/R5 256MB - Advantech816243240SE +/- 0.23, N = 3331. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -llzma -lbz2 -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

25 Results Shown

HammerDB - MariaDB:
  8 - 250:
    New Orders Per Minute
    Transactions Per Minute
  8 - 500:
    New Orders Per Minute
    Transactions Per Minute
  16 - 250:
    New Orders Per Minute
    Transactions Per Minute
  16 - 500:
    New Orders Per Minute
    Transactions Per Minute
  32 - 250:
    New Orders Per Minute
    Transactions Per Minute
  32 - 500:
    New Orders Per Minute
    Transactions Per Minute
  64 - 250:
    New Orders Per Minute
    Transactions Per Minute
  64 - 500:
    New Orders Per Minute
    Transactions Per Minute
MariaDB:
  1
  4
  8
  16
  32
  64
  128
  256
  512

AMD GX-424CC SOC - AMD Radeon R4/R5 256MB - Advantech

Processor: AMD GX-424CC SOC @ 2.40GHz (4 Cores), Motherboard: Advantech Co DPX-W256 (W2560000060V116 BIOS), Chipset: AMD 16h, Memory: 2 x 4096 MB DDR3-1600MT/s SQR-SD3N-4G1K6SSGB, Disk: 32GB SQF-SLMV1-32G-BS + 250GB SSD 860 EVO mSAT, Graphics: AMD Radeon R4/R5 256MB (300MHz), Audio: AMD Kabini HDMI/DP, Network: 2 x Realtek RTL8111/8168/8411

OS: Ubuntu 20.04, Kernel: 5.8.0-63-generic (x86_64), Desktop: GNOME Shell 3.36.9, Display Server: X Server, OpenGL: 4.5 Mesa 20.2.6 (LLVM 11.0.0), Compiler: GCC 9.3.0, File-System: ext4, Screen Resolution: 1920x1080

Kernel Notes: Transparent Huge Pages: madvise
Compiler Notes: --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++,gm2 --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-9-HskZEa/gcc-9-9.3.0/debian/tmp-nvptx/usr,hsa --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-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
Processor Notes: Scaling Governor: acpi-cpufreq ondemand - CPU Microcode: 0x7030105
Security Notes: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Full AMD retpoline STIBP: disabled RSB filling + srbds: Not affected + tsx_async_abort: Not affected

Testing initiated at 1 August 2021 21:23 by user root.