Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Performance Schema for MySQL Troubleshooting

Performance Schema for MySQL Troubleshooting

 25 April - 11:30 AM - 12:20 PM @ Ballroom A
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Operations
Developer
Topics:
MySQL
Optimization
Tools and Techniques

Description

Performance Schema in version 5.6, released in February, 2013, is really powerful tool which can help DBA to find why every trickiest issue started to occur. Version 5.7 introduces even more instruments and tables. And while all these give you great power, you can stuck choosing which instrument to use. In this session I will start from typical problems description, then guide you how to use Performance Schema to find out what causes the issue, what is the reason for wrong behavior and how information received can help you to solve particular problem. Traditionally Performance Schema sessions teach about what is in the tables. I will, in contrast, start from the issue, then show which instruments and tables can help to solve it. We will discuss how to setup Performance Schema, so it would have minimal impact on your server.

Speakers

Sveta Smirnova's picture

Sveta Smirnova

Principal Technical Services Engineer, Percona

Biography:

Sveta Smirnova works as MySQL Support engineer since year 2006, she is also author of book "MySQL Troubleshooting" and author of JSON UDF functions for MySQL. In years 2006 - 2015 she worked in in Bugs Analysis MySQL Support Group in MySQL AB, then Sun, then Oracle. In March 2015 Sveta joined Support Team in Percona. In years 2012-2015 she worked on bugs priority. She was also Support representative in MySQL Backup Development Team. She works on tricky support issues and MySQL software bugs on a daily basis. Before starting at MySQL in 2006, she worked as web developer on several closed CRM systems. In years 2012-2015 she worked on MySQL Labs project "JSON UDFs for MySQL". She is active participant in the open source community. Her main interests in recent years is solving DBA problems, finding ways to semi-automate this process and effective backup techniques. Sveta is author of the book "MySQL Troubleshooting" (http://shop.oreilly.com/product/0636920021964.do)

Share this talk