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

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

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

OpenBenchmarking.orgDistribution Of Public Results - Clients: 8106 Results Range From 187 To 11721 Queries Per Second1874186498801111134215731804203522662497272829593190342136523883411443454576480750385269550057315962619364246655688671177348757978108041827285038734896591969427965898891012010351105821081311044112751150611737510152025

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

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

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

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

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

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

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

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

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

3 Systems - 143 Benchmark Results

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

Ubuntu 20.04 - 5.4.0-1009-aws - GCC 9.3.0

15 Systems - 26 Benchmark Results

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

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

3 Systems - 200 Benchmark Results

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

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

2 Systems - 64 Benchmark Results

Intel Xeon E3-1275 v6 - ASUS P10S-M WS - Intel Xeon E3-1200 v6

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

Find More Test Results

OpenBenchmarking.org Community User Comments

Post A Comment