MariaDB

This is a MariaDB MySQL database server benchmark making use of mysqlslap.

To run this test with the Phoronix Test Suite, the basic command is: phoronix-test-suite benchmark mysqlslap.

Project Site

mariadb.com

Test Created

29 July 2018

Last Updated

9 May 2020

Test Maintainer

Michael Larabel

Test Type

System

Average Install Time

11 Minutes, 8 Seconds

Average Run Time

9 Minutes, 30 Seconds

Accolades

20k+ Downloads

Supported Platforms


Public Result UploadsReported Installs*Test Completions*OpenBenchmarking.orgEventsMariaDB Popularity Statisticspts/mysqlslap2018.072018.082018.092018.102018.112018.122019.012019.022019.032019.042019.052019.062019.072019.082019.092019.102019.112019.122020.012020.022020.032020.042020.052020.062020.072020.082020.092020.102020.112020.122021.012K4K6K8K10K
* Data based on those opting to upload their test results to OpenBenchmarking.org and users enabling the opt-in anonymous statistics reporting while running benchmarks from an Internet-connected platform.
Data current as of Mon, 18 Jan 2021 20:55:56 GMT.
6412.3%25611.8%3211.2%46.5%115.5%51212.1%86.2%1612.5%12812.0%Clients Option PopularityOpenBenchmarking.org

Revision History

pts/mysqlslap-1.1.0   [View Source]   Sat, 09 May 2020 10:33:24 GMT
Update against upstream MariaDB 10.5.2.

pts/mysqlslap-1.0.8   [View Source]   Fri, 31 May 2019 18:13:43 GMT
Add zlib-development as an external dependency per https://github.com/phoronix-test-suite/test-profiles/issues/81

pts/mysqlslap-1.0.6   [View Source]   Wed, 13 Mar 2019 07:03:34 GMT
Update download links.

pts/mysqlslap-1.0.5   [View Source]   Sat, 01 Dec 2018 09:23:20 GMT
Fix for possible data directory rights issue - https://github.com/phoronix-test-suite/test-profiles/issues/47

pts/mysqlslap-1.0.4   [View Source]   Tue, 02 Oct 2018 13:56:13 GMT
Set --no-defaults per GitHub bug report to ensure nothing gets picked up from an installed MySQL configuration.

pts/mysqlslap-1.0.3   [View Source]   Sun, 29 Jul 2018 17:08:06 GMT
Few other external dependencies were missing.

pts/mysqlslap-1.0.2   [View Source]   Sun, 29 Jul 2018 16:26:13 GMT
Add ncurses development external dependency.

pts/mysqlslap-1.0.1   [View Source]   Sun, 29 Jul 2018 16:09:05 GMT
Set ResultPrecision = 0

pts/mysqlslap-1.0.0   [View Source]   Sun, 29 Jul 2018 14:36:52 GMT
Initial commit of MariaDB MySQL benchmark using mysqlslap to facilitate the testing.

Suites Using This Test

Database Test Suite

Multi-Core

Server

CPU Massive

Server CPU Tests


Performance Metrics

Analyze Test Configuration:

MariaDB 10.5.2

Clients: 32

OpenBenchmarking.org metrics for this test profile configuration based on 192 public results since 9 May 2020 with the latest data as of 6 January 2021.

Below is an overview of the generalized performance for components where there is sufficient statistically significant data based upon user-uploaded results. It is important to keep in mind particularly in the Linux/open-source space there can be vastly different OS configurations, with this overview intended to offer just general guidance as to the performance expectations.

OpenBenchmarking.orgDistribution Of Public Results - Clients: 32192 Results Range From 170 To 4069 Queries Per Second1702483264044825606387167948729501028110611841262134014181496157416521730180818861964204221202198227623542432251025882666274428222900297830563134321232903368344635243602368037583836391439924070612182430

Based on OpenBenchmarking.org data, the selected test / test configuration (MariaDB 10.5.2 - Clients: 32) has an average run-time of 12 minutes. By default this test profile is set to run at least 3 times but may increase if the standard deviation exceeds pre-defined defaults or other calculations deem additional runs necessary for greater statistical accuracy of the result.

OpenBenchmarking.orgMinutesTime Required To Complete BenchmarkClients: 32Run-Time1632486480Min: 3 / Avg: 11.68 / Max: 83

Based on public OpenBenchmarking.org results, the selected test / test configuration has an average standard deviation of 0.2%.

OpenBenchmarking.orgPercent, Fewer Is BetterAverage Deviation Between RunsClients: 32Deviation246810Min: 0 / Avg: 0.16 / Max: 3

Recent Test Results

OpenBenchmarking.org Results Compare

2 Systems - 116 Benchmark Results

Ampere Altra ARMv8 Neoverse-N1 - WIWYNN Mt.Jade - Ampere Computing LLC Device e100

Ubuntu 20.10 - 5.10.0-051000rc6daily20201206-generic - X Server 1.20.9

1 System - 9 Benchmark Results

Intel Xeon Silver 4210R - Wistron SV7220G3 - Intel Sky Lake-E DMI3 Registers

Ubuntu 20.04 - 5.4.0-58-generic - GCC 9.3.0

1 System - 9 Benchmark Results

Intel Xeon Silver 4210R - Wistron SV7220G3 - Intel Sky Lake-E DMI3 Registers

Ubuntu 20.04 - 5.4.0-58-generic - GCC 9.3.0

2 Systems - 45 Benchmark Results

AMD Ryzen 7 5800X 8-Core - ASRock X570 Pro4 - AMD Starship

Ubuntu 20.10 - 5.8.0-31-generic - GNOME Shell 3.38.1

1 System - 189 Benchmark Results

Intel Core i7-4790K - ASRock Z97 Pro4 - Intel 4th Gen Core DRAM

Arch rolling - 5.9.10-arch1-1 - Xfce 4.14

2 Systems - 45 Benchmark Results

POWER9 - PowerNV T2P9D01 REV 1.01 - 64GB

Ubuntu 20.10 - 5.9.10-050910-generic - GCC 10.2.0

2 Systems - 437 Benchmark Results

AMD Ryzen 7 5800X 8-Core - ASRock X570 Pro4 - AMD Starship

Ubuntu 20.10 - 5.8.0-29-generic - GNOME Shell 3.38.1

1 System - 188 Benchmark Results

Intel Core i7 960 - ASUS P6T SE - Intel 5520

Ubuntu 20.04 - 5.4.0-47-generic - GNOME Shell 3.36.4

1 System - 290 Benchmark Results

Intel Xeon E5-1680 v3 - ASUS X99-A - Intel Xeon E7 v3

Ubuntu 20.04 - 5.4.0-47-generic - GNOME Shell 3.36.3

5 Systems - 200 Benchmark Results

AMD EPYC 7F72 24-Core - ASRockRack EPYCD8 - AMD Starship

Ubuntu 20.04 - 5.9.0-rc5-14sep-patch - GNOME Shell 3.36.4

Most Popular Test Results

OpenBenchmarking.org Results Compare

6 Systems - 136 Benchmark Results

Intel Core i9-10980XE - ASRock X299 Steel Legend - Intel Sky Lake-E DMI3 Registers

openSUSE Tumbleweed 20200727 - 5.7.9-1-default - KDE Plasma 5.19.3

3 Systems - 143 Benchmark Results

AMD EPYC 7742 64-Core - AMD DAYTONA_X - AMD Starship

Ubuntu 20.04 - 5.4.0-31-generic - GNOME Shell 3.36.1

3 Systems - 259 Benchmark Results

AMD EPYC 7F72 24-Core - ASRockRack EPYCD8 - AMD Starship

Ubuntu 20.04 - 5.8.0-pts - GNOME Shell 3.36.4

5 Systems - 200 Benchmark Results

AMD EPYC 7F72 24-Core - ASRockRack EPYCD8 - AMD Starship

Ubuntu 20.04 - 5.9.0-rc5-14sep-patch - GNOME Shell 3.36.4

15 Systems - 26 Benchmark Results

2 x Intel Xeon Gold 6250 - GIGABYTE MD61-SC2-00 v01000100 - Intel Sky Lake-E DMI3 Registers

Ubuntu 18.04 - 5.3.0-40-generic - GNOME Shell 3.28.4

1 System - 144 Benchmark Results

Intel Core i9-10980XE - ASRock X299 Steel Legend - Intel Sky Lake-E DMI3 Registers

Clear Linux OS 33540 - 5.7.10-972.native - GNOME Shell 3.36.4

1 System - 207 Benchmark Results

ARMv8 Neoverse-N1 - Amazon EC2 m6g.metal v1.0 - 252GB

Ubuntu 20.04 - 5.4.0-1009-aws - GCC 9.3.0

3 Systems - 200 Benchmark Results

Ampere eMAG ARMv8 - AmpereComputing OSPREY - Applied Micro Circuits X-Gene

Ubuntu 20.04 - 5.7.0-050700-generic - GNOME Shell 3.36.3

1 System - 181 Benchmark Results

Intel Xeon E5-2609 v4 - MSI X99A RAIDER - Intel Xeon E7 v4

Ubuntu 20.04 - 5.4.0-33-generic - GNOME Shell 3.36.2

8 Systems - 15 Benchmark Results

AMD Ryzen 7 3800X 8-Core - ASRock X570 Taichi - AMD Starship

Pop 20.04 - 5.4.18-050418-generic - GNOME Shell 3.36.4

1 System - 167 Benchmark Results

Intel Xeon Silver 4216 - TYAN S7100AG2NR - Intel Sky Lake-E DMI3 Registers

Ubuntu 20.04 - 5.4.0-39-generic - GNOME Shell 3.36.1

Find More Test Results

OpenBenchmarking.org Community User Comments

Post A Comment