Performance Schema for MySQL Troubleshooting
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.
Principal Technical Services Engineer, Percona
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)