Dynimizer Cross-Microarchitecture Performance Comparision

Throughput Results


Overview


The below graphs plot the throughput for various CPU bound MySQL workloads generated by Sysbench 1.0, run with and without Dynimizer for comparison. Here Sysbench and MySQL were both run locally on the same server. All changes measured represent the difference after applying Dynimizer. Plots illustrating the CPU stall events associated with these tests can be found here. This was done across three systems that each utilize a very different Intel CPU microarchitecture, spanning five years of Intel CPU designs. As can be seen below, each microarchitecture benefits from Dynimizer. All Sysbench runs utilized ten OLTP tables of one million rows each. A detailed description of how to recreate these runs can be found here, with the scripts and raw results uploaded to the github repository here. The traces of every command executed by the scripts for each run can be found in the output.log files in the results directories of that repository.

Note that Kaby Lake, Broadwell, and Ivy Bridge are the names of the different Intel CPU microarchitectures that were tested.


Software Specifications:

MySQL Version: 5.7.19-0ubuntu0.16.04.1 for Linux on x86_64 ((Ubuntu))
MariaDB Version: 10.2.7-MariaDB-10.2.7+maria~xenial-log for debian-linux-gnu on x86_64 (mariadb.org binary distribution)
Percona Server Version: 5.7.18-16 for debian-linux-gnu on x86_64 (Percona Server (GPL), Release '16', Revision 'd7301f8')
Linux Distro: Ubuntu 16.04.3 LTS (Xenial)
Linux Kernel: Linux ns3042788.ip-51-255-93.eu 4.4.0-87-generic #110-Ubuntu SMP Tue Jul 18 12:55:35 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux
Sysbench Version: 1.0.8
Dynimizer Version: 1.1.0 Beta


Hardware Specifications:

Kaby Lake System:

CPU: Intel(R) Xeon(R) CPU E3-1270 v6 @ 3.80GHz, 4 cores, 8 Threads
RAM: 32 GB of 2400 MHz DDR4
Storage: HGST Ultrastar HUS726020AL, SoftRaid 2x2TB HDD
*This is a dedicated server rented from OVH, model: SP-32 Server, data center BHS 5


Broadwell System:

CPU: Intel(R) Xeon(R) CPU D-1521 @ 2.40GHz, 4 cores, 8 Threads
RAM: 32 GB of 2400 MHz DDR4
Storage: HGST Ultrastar HUS724020AL, SoftRaid 2x2TB HDD
*This is a dedicated server rented from OVH, model: HOST-32L Server, data center BHS 5


Ivy Bridge System:

CPU: Intel(R) Xeon(R) CPU E5-1620 v2 @ 3.70GHz, 4 cores, 8 Threads
RAM: 16 GB of DDR3 1333 MHz
Storage: SAMSUNG MZ7LM240, SoftRaid 2x240GB SSD
*This is a dedicated server rented from OVH, model: GPU-970-S Server, data center GRA 1


MySQL 5.7 with Sysbench 1.0
Microarchitecture: Kaby Lake

Increase in Transactions/Second

OLTP Read-Only

OLTP Simple

Select

Select Random Ranges
Microarchitecture: Broadwell

Increase in Transactions/Second

OLTP Read-Only

OLTP Simple

Select

Select Random Ranges
Microarchitecture: Ivy Bridge

Increase in Transactions/Second

OLTP Read-Only

OLTP Simple

Select

Select Random Ranges

MariaDB 10.2 with Sysbench 1.0
Microarchitecture: Kaby Lake

Increase in Transactions/Second

OLTP Read-Only

OLTP Simple

Select

Select Random Ranges
Microarchitecture: Broadwell

Increase in Transactions/Second

OLTP Read-Only

OLTP Simple

Select

Select Random Ranges
Microarchitecture: Ivy Bridge

Increase in Transactions/Second

OLTP Read-Only

OLTP Simple

Select

Select Random Ranges

Percona Server 5.7 with Sysbench 1.0
Microarchitecture: Kaby Lake

Increase in Transactions/Second

OLTP Read-Only

OLTP Simple

Select

Select Random Ranges
Microarchitecture: Broadwell

Increase in Transactions/Second

OLTP Read-Only

OLTP Simple

Select

Select Random Ranges
Microarchitecture: Ivy Bridge

Increase in Transactions/Second

OLTP Read-Only

OLTP Simple

Select

Select Random Ranges

Discussions






COPYRIGHT © DYNIMIZE INC.