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 Fri, 22 Jan 2021 02:46:24 GMT.
6412.0%25611.5%3210.9%46.8%115.9%51211.7%87.0%1612.6%12811.7%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: 4

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

Additional benchmark metrics will come after OpenBenchmarking.org has collected a sufficient data-set.

OpenBenchmarking.orgDistribution Of Public Results - Clients: 4126 Results Range From 73 To 14637 Queries Per Second733656579491241153318252117240927012993328535773869416144534745503753295621591362056497678970817373766579578249854188339125941797091000110293105851087711169114611175312045123371262912921132131350513797140891438114673612182430

Based on OpenBenchmarking.org data, the selected test / test configuration (MariaDB 10.5.2 - Clients: 4) has an average run-time of 18 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: 4Run-Time1428425670Min: 1 / Avg: 17.13 / Max: 70

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

OpenBenchmarking.orgPercent, Fewer Is BetterAverage Deviation Between RunsClients: 4Deviation3691215Min: 0 / Avg: 1.48 / Max: 11

Recent Test Results

OpenBenchmarking.org Results Compare

8 Systems - 41 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

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 - 56 Benchmark Results

AMD Ryzen 9 5900X 12-Core - 14GB - 2 x 275GB Virtual Disk

Ubuntu 20.04 - 4.19.128-microsoft-standard - X Server

7 Systems - 41 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

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

7 Systems - 41 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

7 Systems - 41 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

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

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

Debian testing - 5.7.0-1-amd64 - GNOME Shell 3.36.4

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

15 Systems - 26 Benchmark Results

Intel Xeon Gold 6226R - 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

8 Systems - 30 Benchmark Results

AMD Ryzen 9 3900X 12-Core - ASUS TUF GAMING X570-PLUS - AMD Starship

Ubuntu 20.04 - 5.8.0-050800daily20200626-generic - GNOME Shell 3.36.1

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.4.0-42-generic - GCC 9.3.0

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

2 Systems - 56 Benchmark Results

AMD Ryzen 9 5900X 12-Core - 14GB - 2 x 275GB Virtual Disk

Ubuntu 20.04 - 4.19.128-microsoft-standard - X Server
Find More Test Results

OpenBenchmarking.org Community User Comments

Post A Comment