MariaDB

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

Learn more about this test at the upstream project site: https://mariadb.com/.

This benchmark test profile is maintained by Michael Larabel. This OpenBenchmarking.org test profile was created on 29 July 2018 and last updated on 9 May 2020. To run this test with the Phoronix Test Suite, the basic command is: phoronix-test-suite benchmark mysqlslap.

This test has an average install time of 5 minutes, 39 seconds and an average run-time of 9 minutes, 30 seconds.

20k+ Downloads

Installation StatsTest Completion StatsPublic Result UploadsOpenBenchmarking.orgEventsMariaDB Popularitypts/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.117001400210028003500

* Data based on those opting to upload their test results to OpenBenchmarking.org and users enabling the opt-in anonymous statistics reporting.

6413.7%25612.8%3212.5%45.8%115.7%51213.4%1613.1%12813.1%Clients Option PopularityOpenBenchmarking.org

Revision History

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

pts/mysqlslap-1.0.8   [View Source]   31 May 2019 18:13 EDT
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]   13 Mar 2019 07:03 EDT
Update download links.

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

pts/mysqlslap-1.0.4   [View Source]   02 Oct 2018 13:56 EDT
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]   29 Jul 2018 17:08 EDT
Few other external dependencies were missing.

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

pts/mysqlslap-1.0.1   [View Source]   29 Jul 2018 16:09 EDT
Set ResultPrecision = 0

pts/mysqlslap-1.0.0   [View Source]   29 Jul 2018 14:36 EDT
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: 1

OpenBenchmarking.org metrics for this test profile configuration based on 239 public samples since 9 May 2020 with the latest data as of 2 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: 1239 Results Range From 251 To 18920 Queries Per Second251625999137317472121249528693243361739914365473951135487586162356609698373577731810584798853922796019975103491072311097114711184512219125931296713341137151408914463148371521115585159591633316707170811745517829182031857718951816243240

Based on OpenBenchmarking.org data, the selected test / test configuration (MariaDB 10.5.2 - Clients: 1) 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: 1Run-Time1428425670Min: 1 / Avg: 11.42 / Max: 74

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: 1Deviation3691215Min: 0 / Avg: 1.52 / Max: 10

Recent Test Results

Compare

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 - 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 - 1 Benchmark Result

AMD Ryzen 3 3100 4-Core - QEMU Standard PC - Intel 82G33

Ubuntu 20.04 - 5.4.0-54-generic - GCC 9.3.0

2 Systems - 80 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 - 64 Benchmark Results

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

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

Most Popular Test 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

5 Systems - 68 Benchmark Results

AMD Ryzen 9 3900X 12-Core - MSI MPG X570 GAMING PLUS - AMD Starship

Debian testing - 5.7.10-xanmod1 - X Server 1.20.8

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 5220R - 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 5 3600X 6-Core - ASRock B450M Pro4 - AMD Starship

Arch rolling - 5.7.7-arch1-1 - Xfce 4.14

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

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

Find More Test Results


User Comments

Post A Comment