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

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

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

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

Intel Xeon Gold 6226R

100th

1948

AMD Ryzen 7 5800X 8-Core

97th

1778 ^{+/- 199}

Intel Xeon Gold 5218

97th

1725

Intel Xeon Silver 4214R

94th

1649

Intel Xeon Silver 4216

91st

1528 ^{+/- 339}

2 x Intel Xeon Platinum 8280

90th

1475 ^{+/- 30}

Intel Xeon Gold 5217

88th

1325

Intel Xeon Silver 4215R

85th

1280

AMD EPYC 7F72 24-Core

79th

1246 ^{+/- 16}

AMD EPYC 7282 16-Core

79th

1240

Mid-Tier

75th

< 1227

AMD EPYC 7542 32-Core

72nd

1155

AMD EPYC 7742 64-Core

70th

1134 ^{+/- 52}

AMD EPYC 7272 12-Core

70th

1114

AMD EPYC 7F52 16-Core

68th

1105

AMD EPYC 7402P 24-Core

66th

1103

AMD EPYC 7502P 32-Core

64th

1097

AMD EPYC 7502 32-Core

61st

1090

AMD EPYC 7642 48-Core

60th

1086

AMD EPYC 7552 48-Core

55th

1060

Median

50th

1051

AMD EPYC 7302P 16-Core

49th

1041

AMD EPYC 7702 64-Core

49th

1041 ^{+/- 33}

AMD EPYC 7662 64-Core

45th

1015

AMD EPYC 7452 32-Core

42nd

1002

AMD EPYC 7352 24-Core

40th

993

ARMv8 Neoverse-N1 64-Core

37th

972 ^{+/- 12}

AMD EPYC 7532 32-Core

36th

961

AMD EPYC 7232P 8-Core

32nd

889

AMD EPYC 7F32 8-Core

30th

876

2 x AMD EPYC 7742 64-Core

27th

849 ^{+/- 131}

AMD EPYC 7252 8-Core

27th

833

Low-Tier

25th

< 833

AMD EPYC 7262 8-Core

25th

743

AMD Ryzen Threadripper 3960X 24-Core

23rd

614

Intel Core i9-10980XE

15th

434

AMD Ryzen Threadripper 3990X 64-Core

12th

284 ^{+/- 2}

2 x Intel Xeon Gold 5220R

8th

199 ^{+/- 8}

Ampere eMAG ARMv8 32-Core

7th

193 ^{+/- 5}

Based on OpenBenchmarking.org data, the selected test / test configuration (MariaDB 10.5.2 - Clients: 64) has an average run-time of 19 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.

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

Linux 5.11 Change On 5950X Featured Kernel Comparison	5.11.0-051100rc2daily20210105-generic - 5.11.0-051100rc2daily20210106-generic
AMD EPYC 7702 Linux 5.11 Featured Kernel Comparison	5.10.2-051002-generic - 5.10.0-051000daily20201222-generic
ampere-160-cores 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
mysqlMgmt 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
mysqlComp 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
databases sabrent 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
multi-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
WD_BLACK SN850 Databases 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
mariadb-test-6client-ubuntu-vm 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
EPYC vs. Xeon Benchmarks On Ubuntu 20.10 19 Systems - 176 Benchmark Results	AMD EPYC 7F32 8-Core - ASRockRack EPYCD8 - AMD Starship Ubuntu 20.10 - 5.8.0-21-generic - GNOME Shell 3.38.0
Intel Xeon On Ubuntu 20.10 Featured Processor Comparison	Intel Xeon Gold 6226R - Intel Xeon Gold 5217 - Intel Xeon Silver 4215R - Intel Xeon Silver 4214R - Intel Xeon Gold 5218 - Intel Xeon Silver 4216
schopenhauer-pts-multicore-20-sept-2020 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

Core i9 Clear Linux Benchmarks 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
Amazon Graviton2 vs. AMD EPYC 7742 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
Intel Xeon On Ubuntu 20.10 Featured Processor Comparison	Intel Xeon Gold 5218 - Supermicro X11SPL-F v1.02 - Intel Sky Lake-E DMI3 Registers Ubuntu 20.10 - 5.8.0-20-generic - GNOME Shell 3.38.0
Kernel Compare 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
EPYC 7F72 Kernel Testing 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
EPYC 7F72 Kernel Testing 5 Systems - 200 Benchmark Results	AMD EPYC 7F72 24-Core - ASRockRack EPYCD8 - AMD Starship Ubuntu 20.04 - 5.9.0-rc4-pts - GNOME Shell 3.36.4
luxcore silver 15 Systems - 26 Benchmark Results	Intel Xeon Silver 4216 - GIGABYTE MD61-SC2-00 v01000100 - Intel Sky Lake-E DMI3 Registers Ubuntu 18.04 - 5.3.0-40-generic - GNOME Shell 3.28.4
AMD EPYC 7742 Ubuntu 19.04 In 2020 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
Core i9 Clear Linux 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
Amazon Graviton2 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
Ampere eMAG 3 Systems - 200 Benchmark Results	Ampere eMAG ARMv8 - AmpereComputing OSPREY - Applied Micro Circuits X-Gene Ubuntu 20.04 - 5.7.0-050700-generic - GNOME Shell 3.36.3
AMD EPYC 7702 Linux 5.11 Featured Kernel Comparison	AMD EPYC 7702 64-Core - ASRockRack EPYCD8 - AMD Starship Ubuntu 20.10 - 5.10.2-051002-generic - GNOME Shell 3.38.1