Tutorials

Measuring the Impact of Dynimize on Your MySQL Workload

While it's easier to measure the impact of Dynimize if you are running a MySQL benchmark with clear metrics, it can sometimes be a challenge on a production workload where you don't have precise performance analytics or metrics available. There are many...

February 08, 2021 -

by David Yeager

in Beginner Tutorials, Discussions, Tutorials

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

September 22, 2020 -

by David Yeager

in Advanced Tutorials, Discussions

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

July 15, 2019 -

by David Yeager

in Beginner Tutorials

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