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.
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.
6:30 - 7:00 -- Doors open/general socializing & food provided by Percona
7:00 - 7:15 -- Intro/announcements
7:15 - 8:00(ish) -- Main presentation
8:00 - 8:30 -- General discussion/Q&A/networking/etc.
Percona has made MySQL faster and more reliable for over 2,000 consulting and support customers worldwide since 2006. Percona provides enterprise-grade MySQL Support, Consulting, Training, Remote DBA, and Server Development services to companies including Cisco Systems, Alcatel-Lucent, Groupon and the BBC. Percona's founders authored the definitive book “High Performance MySQL” from O'Reilly Press and the widely read MySQL Performance Blog. Percona also develops software for MySQL users, including Percona Server, Percona XtraBackup, Percona XtraDB Cluster, and Percona Toolkit. The popular Percona Live conferences draw attendees and acclaimed speakers from around the world. For more information, visit www.percona.com
Lithium helps companies unlock the passion of their customers. Lithium software powers amazing Social Customer Experiences for more than 400 iconic brands including AT&T, BT, Best Buy, Indosat, Sephora, and Telstra. Lithium helps companies grow brand advocacy, drive sales, reduce costs and accelerate innovation to create social communities that redefine the customer experience.
Blackbird - formerly PalominoDB and DriveDev, we are a boutique of dapper DBAs, Engineers, and Open Source Operations professionals. For more info: http://blackbird.io/
O'Reilly Media spreads the knowledge of innovators through its books, online services, magazines, research, and conferences. Since 1978, O'Reilly has been a chronicler and catalyst of leading-edge development, homing in on the technology trends that really matter and galvanizing their adoption by amplifying "faint signals" from the alpha geeks who are creating the future. An active participant in the technology community, the company has a long history of advocacy, meme-making, and evangelism.