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