Troubleshooting Scenarios with Performance Schema
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.
Storage SRE, Uber
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.
MySQL SRE, Dropbox / ProxySQL
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.
Software Engineer, Dropbox
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