Benchmark Noise Reduction: How to Configure Your Machines for Stable Results

Tuesday 4:50PM-5:15PM

@ Room M1

MySQL / MariaDBMongoDBOpen Source Databases

25 minutes conference

Intermediate

Tracks:
Operations

This talk is about measuring and reducing noise in benchmark results. Properly tuning the operating system and hardware to achieve stable results in benchmarks becomes an art in itself these days. There may be many reasons for that:

- jitter in CPU and I/O schedulers
- dynamic CPU frequency scaling
- process address space randomization
- kernel configuration
- etc.

If you are not seeing stable results in your performance comparisons, you are wasting your time. Since I do a lot of MySQL benchmarks as a part of my job, I have collected a number of recipes to measure and reduce system noise and achieve more stable numbers in benchmarks. I'm going to describe those recipes as well as the new sysbench module implemented to automate those tasks and simplify system tuning for other people.


Speakers

Alexey Kopytov

Alexey Kopytov (.)

Software Engineer

Biography:

Alexey worked at MySQL AB/Sun/Oracle as a Performance Engineer in the High Performance group and Software Engineer in the MySQL development team. He also worked at Percona on Percona Server, XtraBackup and XtraDB cluster. He is also the maintainer of sysbench, a popular benchmark tool.


Slides



  Download Slides  

Connect with Percona

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863
  • 8081 Arco Corporate Drive - Suite 330 - Raleigh, NC 27617, USA