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: 16

OpenBenchmarking.org metrics for this test profile configuration based on 229 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.

Component
Percentile Rank
# Matching Public Results
Queries Per Second (Average)
92nd
13
6340 +/- 61
Mid-Tier
75th
< 5608
Median
50th
4816
37th
6
2787 +/- 824
Low-Tier
25th
< 795
15th
9
537 +/- 137
6th
10
238 +/- 17
OpenBenchmarking.orgDistribution Of Public Results - Clients: 16229 Results Range From 184 To 8220 Queries Per Second184345506667828989115013111472163317941955211622772438259927602921308232433404356537263887404842094370453146924853501451755336549756585819598061416302646366246785694671077268742975907751791280738234612182430

Based on OpenBenchmarking.org data, the selected test / test configuration (MariaDB 10.5.2 - Clients: 16) has an average run-time of 13 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: 16Run-Time1326395265Min: 1 / Avg: 12.52 / Max: 69

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

OpenBenchmarking.orgPercent, Fewer Is BetterAverage Deviation Between RunsClients: 16Deviation510152025Min: 0 / Avg: 0.97 / Max: 19

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

1 System - 178 Benchmark Results

AMD EPYC 7302P 16-Core - Supermicro H12SSW-NT v1.01 - AMD Starship

Red Hat Enterprise Linux 7.9 - 3.10.0-1160.2.2.el7.x86_64 - GNOME Shell 3.28.3

1 System - 62 Benchmark Results

AMD EPYC 7302P 16-Core - Supermicro H12SSW-NT v1.01 - AMD Starship

Red Hat Enterprise Linux 7.9 - 3.10.0-1160.2.2.el7.x86_64 - GNOME Shell 3.28.3

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

1 System - 1 Benchmark Result

Intel Core i7-8565U - LENOVO 20N5S2GP05 - 16GB

Ubuntu 20.04.1 LTS - 5.4.0-54-generic - GCC 9.3.0

1 System - 1 Benchmark Result

Intel Core i7-8565U - LENOVO 20N5S2GP05 - 16GB

Ubuntu 20.04.1 LTS - 5.4.0-54-generic - GCC 9.3.0

2 Systems - 56 Benchmark Results

AMD Ryzen 9 5900X 12-Core - 16GB - 931GB

Ubuntu 20.04 - 4.4.0-19041-Microsoft - GCC 9.3.0

Most Popular Test Results

Find More Test Results

OpenBenchmarking.org Community User Comments

Post A Comment