Nov 06, 2018
 Percona Live Open Source Database Conference Europe 2018
  Roel Van de Paar

In this presentation attendees will see the performance of a MySQL Server increase by automatic tuning using an open source GA (Genetic Algorithm) with surrounding smart bits. The full interface code will be made publicly available as open source on GitHub.

Genetic Algorithms - a kind of Artificial Intelligence - have been used for a long time, but only recently the interest towards database applications has spiked.

You will see the transactions per second increase and increase again as the server is being adjusted automatically.

You will walk away with a better understanding of Genetic Algorithms, it's application to automated database tuning, and how to start with (or continue) your own experiments in this area.

All new work, this setup has not been showcased anywhere before.

About the Author

Roel Van de Paar

Roel joined Percona in July, 2012. A seasoned professional, Roel has an extensive and varied background in IT, backed up by many industry leading certifications. Previously Roel was a Senior QA Engineer at Oracle, contributing significantly to the MySQL QA infrastructure. Prior to this he was a Senior Support Engineer at Oracle/Sun, supporting enterprise scale MySQL deployments across a variety of platforms. Roel's prior IT career also included being a Support/Systems Engineer at Siemens, and a Project Manager for Volvo IT, where he led several major projects. He currently works from his home office in NSW, Australia. Roel also enjoys time with God, his wife and 5 children, or in just being out and about.