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

Percona
Biography: 
Ryan worked for a variety of companies, including several startups, and he has a background in many different database technologies. He has extensive experience as a developer, DBA, manager, and consultant. In addition, he has worked in a broad range of industries across the globe, including health care, telecommunications, social networking, and defense. His specialties include full-stack performance optimization, scaling, and high availability.
Support Engineer, Percona
Biography: 
Marcos Albe has been doing web development for over ten years, providing solutions for various media and technology companies of different sizes. He is now a member of the Percona Support Team. Born and raised in the city of Montevideo, Uruguay, he became passionate about computers at the age of 11, when he got a 25Mhz i386-SX. Some ten years later, he became one of the pioneers in telecommuting in Uruguay while leading the IT efforts for the second largest newspaper in the country. Marcos also has a passion for teaching. As the first Zend Certified Engineer in Uruguay, he provided PHP training for several companies, and he also gave free workshops to public college students. His motto is: Teaching is the best way to learn. At the age of 32, he became a father and husband, which has made him truly happy. He is planning to move to a more quiet town to raise his toddler.