Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

Troubleshooting Scenarios with Performance Schema

Troubleshooting Scenarios with Performance Schema

 20 April 11:10 AM - 12:00 PM @ Ballroom H
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Case Stories
Topics:
MySQL
Metrics
Monitoring

Description

In this talk we'll run through numerous performance problems and how to troubleshoot them using Performance Schema. Many of these performance issues are based off actual problems experienced in our production environment at Dropbox. The goal of this presentation is to give concrete real world examples of leveraging the features of performance schema so you can apply this to your own production environment. Examples of the following will be included: o How we leverage the sys schema o How we use ps snapshotting to examine query history. o Other techniques and examples of pinning down offending queries.

Speakers

David Turner's picture

David Turner

Storage SRE, Uber

Biography:

David Turner joined Uber in 2016. He has more than 10 years experience working with databases such as Oracle and MySQL. He was drawn to MySQL because of his interest in database internals and a deeper understanding of systems architecture. With MySQL he has found he has more freedom to explore. His experience in working at larger shops such as Dropbox, Facebook, Pinterest, Sprint, and Zendesk has given him a strong understanding of scaling issues and of managing massive amounts of data and databases.

René Cannaò's picture

René Cannaò

MySQL SRE, Dropbox / ProxySQL

Biography:

René has 10 years of working experience as System, Network and Database Administrator mainly on Linux/Unix platform. In the last 4-5 years his experience was focused mainly on MySQL, working as Senior MySQL Support Engineer at Sun/Oracle and now as Senior Operational DBA at Blackbird, (formerly PalominoDB). In this period he build an analytic and problem solving mindset and he is always eager to take on new challenges, especially if they are related to high performance.

Thomas Manville's picture

Thomas Manville

Software Engineer, Dropbox

Biography:

Tom joined Dropbox in 2015. He is privileged to be able to work on one of the largest MySQL deployments in the world. His MySQL projects include: * Automatic slave promotion * Region failover for disaster recovery * Multi-instance * Semi-sync binlog slaves

Share this talk