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 Sat, 23 Jan 2021 03:07:00 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: 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.

Component

Percentile Rank

# Matching Public Results

Queries Per Second (Average)

Intel Xeon Gold 6226R

100th

733

Intel Xeon Gold 5218

100th

646

Intel Xeon Silver 4216

96th

592 ^{+/- 72}

Intel Xeon Silver 4214R

93rd

556

2 x Intel Xeon Gold 6258R

89th

548 ^{+/- 2}

2 x Intel Xeon Platinum 8280

87th

534 ^{+/- 9}

AMD Ryzen 7 5800X 8-Core

85th

518 ^{+/- 105}

AMD EPYC 7F72 24-Core

80th

457 ^{+/- 9}

AMD EPYC 7282 16-Core

80th

454

Mid-Tier

75th

< 449

2 x Intel Xeon Silver 4210

74th

443 ^{+/- 3}

AMD EPYC 7542 32-Core

73rd

432

AMD EPYC 7402P 24-Core

71st

415

AMD EPYC 7502P 32-Core

69th

409

AMD EPYC 7502 32-Core

67th

408

AMD EPYC 7F52 16-Core

63rd

387

Intel Xeon Gold 5217

60th

385 ^{+/- 26}

AMD EPYC 7642 48-Core

60th

383

AMD EPYC 7302P 16-Core

60th

383

Intel Xeon Silver 4215R

55th

378

AMD EPYC 7552 48-Core

55th

378

AMD EPYC 7272 12-Core

51st

377

AMD EPYC 7452 32-Core

51st

377

Median

50th

377

AMD EPYC 7352 24-Core

47th

376

AMD EPYC 7702 64-Core

44th

368 ^{+/- 23}

AMD EPYC 7532 32-Core

36th

355

AMD EPYC 7662 64-Core

34th

354

Low-Tier

25th

< 304

2 x AMD EPYC 7742 64-Core

24th

289 ^{+/- 43}

AMD EPYC 7232P 8-Core

24th

280

AMD EPYC 7F32 8-Core

21st

279

AMD EPYC 7252 8-Core

19th

263

AMD EPYC 7262 8-Core

16th

236

2 x Intel Xeon Gold 5220R

14th

231

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.

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

AMD EPYC 7702 Linux 5.11 Featured Kernel Comparison	5.10.2-051002-generic - 5.10.0-051000daily20201222-generic
EPYC 7F72 2P Linux 5.11 Featured Kernel Comparison	5.10.1-051001-generic - 5.10.0-051000daily20201219-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
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
theseus-pts-multicore-14-sept-2020 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
EPYC 7F72 Kernel Testing 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

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 6226R - Supermicro X11SPL-F v1.02 - Intel Sky Lake-E DMI3 Registers Ubuntu 20.10 - 5.8.0-20-generic - GNOME Shell 3.38.0
Server New 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
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
luxcore silver 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
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
AMD EPYC 7742 + Xeon Platinum 8280 In 2020 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
Server New 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
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
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
kyoko-pop-2004 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

MariaDB

Project Site

Test Created

Last Updated

Test Maintainer

Test Type

Average Install Time

Average Run Time

Accolades

Supported Platforms

Revision History

Suites Using This Test

Performance Metrics

MariaDB 10.5.2

Clients: 512

Recent Test Results

Most Popular Test Results

User Comments