MySQL + Dynimize: 3.6 Million Queries per Second on a Single VM
In this post I describe the various steps that allowed me to reach 3.6 million queries per second on a single VM instance using MySQL 8.0 with the help of Dynimize. It's not every day that you get to break a record....
Continue Reading
Dynimize Quickstart Tutorial
Duration: 10 min Level: Beginner This tutorial will show you how to install Dynimize. We'll then use it to optimize a live MySQL process that's been running the Sysbench OLTP benchmark, obtaining a 46% increase in performance by applying Dynimize. ...
Continue Reading
Dynimize + MySQL Cross-Microarchitecture Analysis
In this blog post I will discuss how the Dynimize cross microarchitecture performance results were obtained, followed by an analysis of these results. You can download the scripts to generate similar graphs for your own system from here. Note this repository also...
Continue Reading
Measuring CPU stall reductions from Dynimize
Duration: 30 min Level: Intermediate In this tutorial we are going to install and experiment with Dynimize using MySQL running the Sysbench OLTP benchmark. We also play around with the Linux perf command, top and vmstat. This tutorial assumes that you...
Continue Reading