addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwchatcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgoogleimageimagesinstagramlinklocation-pinmagnifying-glassmailminusmoremuplabelShape 3 + Rectangle 1outlookpersonplusprice-ribbonImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruseryahoo

Optimizing MySQL Performance: Choosing the Right Tool for the Job

  • Mar 13, 2014 · 6:30 PM
  • This location is shown only to members

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.

Agenda: 
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.

Sponsors: 
Percona has made MySQL faster and more reliable for over 2,000 consulting and support customers worldwide since 2006. Percona provides enterprise-grade MySQL SupportConsultingTrainingRemote 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 ServerPercona XtraBackupPercona 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.


Join or login to comment.

  • Tom D.

    Hey everyone! Percona's community manager here. In addition to the pizza and refreshing beverages, we've given Erin and Mike 2 FULL-ACCESS passes to the fast-approaching Percona Live conference April 1-4 in Santa Clara. But wait there's more! There is a THIRD Percona Live pass available. But here's the only way to win: Tweet the session you're most looking forward to along with the hashtag #perconalive to enter! Here's the full program: http://bit.ly/1cBEkUI

    We'll pick one of the tweets at random tomorrow afternoon Eastern time and contact the lucky winner with the details.
    Good luck!

    March 13, 2014

    • Tom D.

      forgot to add to please include hashtag #sfmysql so I can separate those out. Thanks all!

      March 13, 2014

  • fuad

    See you there!!! Also- FYI- We have a Job Fair TODAY! If you are looking for work- Join us!!!! http://www.meetup.com/renttesters/events/161622412/#event-comments-section

    March 11, 2014

Our Sponsors

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy