Nov 01, 2016
 All Things Open 2016
  Peter Zaitsev

Two exciting aspects of MySQL monitoring that require advanced data capture and visualization are diagnostics and capacity planning – understanding how the data helps resolve issues and using the data to plan future performance. In this talk we’ll look at how diagnostics use data to resolve an immediate problem. We’ll review some of the most common MySQL issues, how they present themselves in the data and how we use that data to come to a resolution. We’ll also discuss how we can use medium- to long-term trends to estimate future system capacity and how to find potential bottlenecks in order to avoid future problems due to resource constraints

About the Author

Peter Zaitsev

Peter Zaitsev co-founded Percona and assumed the role of CEO in 2006. As one of the foremost experts on MySQL strategy and optimization, Peter leveraged both his technical vision and entrepreneurial skills to grow Percona from a two-person shop to one of the most respected open source companies in the business. With over 200 professionals in 30 plus countries, Peter’s venture now serves over 3000 customers – including the “who’s who” of internet giants, large enterprises and many exciting startups. Percona was named to the Inc. 5000 in 2013, 2014, 2015 and 2016. Peter was an early employee at MySQL AB, eventually leading the company’s High Performance Group. A serial entrepreneur, Peter co-founded his first startup while attending Moscow State University where he majored in Computer Science. Peter is a co-author of High Performance MySQL: Optimization, Backups, and Replication, one of the most popular books on MySQL performance. Peter frequently speaks as an expert lecturer at MySQL and related conferences, and regularly posts on the Percona Database Performance Blog. He has also been tapped as a contributor to Fortune and DZone, and his recent ebook Practical MySQL Performance Optimization Volume 1 is one of’s most popular downloads. Peter lives in North Carolina with his wife and two children. In his spare time, Peter enjoys travel and spending time outdoors.