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.
Roel leads Percona's QA team. Before coming to Percona, he contributed significantly to the QA infrastructure at Oracle. Roel has a varied background in IT, backed up by many industry leading certifications. He also enjoys time with God, his wife and 5 children, or heading into nature.