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 Sat, 23 Jan 2021 03:07:00 GMT.
6411.9%25611.4%3210.8%46.9%115.9%51211.7%87.2%1612.6%12811.6%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: 512

OpenBenchmarking.org metrics for this test profile configuration based on 212 public results since 9 May 2020 with the latest data as of 23 December 2020.

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: 512212 Results Range From 75 To 733 Queries Per Second751011271531792052312572833093353613874134394654915175435695956216476736997257511224364860

Based on OpenBenchmarking.org data, the selected test / test configuration (MariaDB 10.5.2 - Clients: 512) has an average run-time of 30 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: 512Run-Time306090120150Min: 14 / Avg: 30.03 / Max: 134

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

OpenBenchmarking.orgPercent, Fewer Is BetterAverage Deviation Between RunsClients: 512Deviation246810Min: 0 / Avg: 0.14 / Max: 2

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

AMD Ryzen 3 2200G - ASRock A320M-ITX - AMD Raven

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

3 Systems - 259 Benchmark Results

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

Ubuntu 20.04 - 5.9.0-rc4-pts-patch - GNOME Shell 3.36.4

Most Popular Test Results

OpenBenchmarking.org Results Compare

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

9 Systems - 412 Benchmark Results

2 x Intel Xeon Silver 4210 - GIGABYTE MD61-SC2-00 v01000100 - Intel Sky Lake-E DMI3 Registers

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

4 Systems - 176 Benchmark Results

AMD EPYC 7702 64-Core - ASRockRack EPYCD8 - AMD Starship

Ubuntu 20.04 - 5.8.0-050800-generic - GNOME Shell 3.36.4

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

15 Systems - 26 Benchmark Results

Intel Xeon Gold 5218 - 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 - 149 Benchmark Results

2 x AMD EPYC 7742 64-Core - AMD DAYTONA_X - AMD Device 1480

Ubuntu 19.04 - 5.0.0-13-generic - GNOME Shell 3.32.0

4 Systems - 116 Benchmark Results

2 x AMD EPYC 7742 64-Core - AMD DAYTONA_X - AMD Device 1480

Ubuntu 19.04 - 5.0.0-13-generic - GNOME Shell 3.32.0

5 Systems - 521 Benchmark Results

2 x Intel Xeon Silver 4214R - GIGABYTE MD61-SC2-00 v01000100 - Intel Sky Lake-E DMI3 Registers

Ubuntu 20.04 - 5.8.0-050800rc6daily20200721-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

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

Find More Test Results

OpenBenchmarking.org Community User Comments

Post A Comment