The below graphs plot the throughput for various CPU bound MySQL
workloads generated by Sysbench 1.0, run with and without Dynimize
for comparison. Here Sysbench and MySQL were both run locally on the
same server. All changes measured represent the difference after
applying Dynimize. Plots illustrating the CPU stall events associated
with these tests can be found
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 Dynimize.
All Sysbench runs utilized ten OLTP tables of one million rows each.
A detailed description of how to recreate these runs can be found
, with the scripts and raw results uploaded to the github repository
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.
5.7.19-0ubuntu0.16.04.1 for Linux on x86_64 ((Ubuntu))
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')
Ubuntu 16.04.3 LTS (Xenial)
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