A Systematic Approach to Performance

Tools
3 April 1:00PM - 1:50PM @ Ballroom A

Experience level: 
Intermediate
Duration: 
50 minutes conference
Application performance is a key aspect of ensuring a good experience for your end users. But finding and fixing performance bottlenecks is difficult in the complex systems that define today's web applications. Having a method and knowing how to use the tools available can significantly reduce the amount of time between problems manifesting and fixes being deployed. The purpose of this talk is to introduce the primary tools used for performance optimization of MySQL running on Linux. This talk will cover vmstat, iostat, top, netstat, ethtool, oprofile, perf, pt-diskstats, pt-ioprofile, pt-pmp, and more. By the end of the session, attendees will know how to choose the right tool for the right problem, understand system components and how their inter-relationships affect performance, and fix identified bottlenecks.


Speakers

Production Engineer, Square, Inc.
Biography: 
Ryan is a Platform Engineer at Square, where he manages thousands of instances of MySQL and PostgreSQL. Before joining Square, Ryan helped build and scale some of the largest web, social, gaming, and mobile properties as a Consultant at Percona. As an author, speaker, and active contributor to F/OSS projects, his expertise extends to a variety of data stores, cloud and big data, and beyond.
Senior Support Engineer, Percona
Biography: 
After 12 years working as a PHP/JS developer for local and remote firms, Marcos decided to pursuit true love and become full time DBA, so he has been doing MySQL Support at Percona for the past 5 years providing lead web properties with advise on anything-MySQL and in-depth system performance diagnostic help.