New features in Performance Schema 5.7 in action

Performance Optimization
21 September 1:30PM - 4:30PM @ Matterhorn 2

Duration: 
3 hours tutorial
MySQL introduced memory footprint and performance fixes and many amazing new features in Performance Schema 5.7. They include memory, extended lock, including metadata lock, stored routines, transactions, event scheduler, replication instrumentation and much more. And while these features look amazing, they can look complicated. In this tutorial we will let you to try them out! We will provide test environment and few typical problems which can be hardly solved before MySQL 5.7. In the end of the session you will not only know how to collect and use this new information, but have experience with it. Release notes up to version 5.7.7 contain at least 18 big improvements for Performance Schema if compare with version 5.6. But they do not contain information how and why to use them. In contrast we will start from the problem and will show how Performance Schema can help to diagnose it. Just few examples: "Where are your memory going?" , "Why these queries hang?", "How huge overhead from my storage procedures?", "What part of mysql makes I/O?" and "Why queries awaiting for metadata locks?".


Speakers

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)
Senior Support Engineer, Percona
Since 2011 Nickolay handled emergency and data recovery cases, switched to Support Department and for last several years helping Percona's customers with complex performance issues and mysql crashes. Before joining Percona, worked in a variety of fields: web and mysql servers scalability for biggest Russian cinema site,  ISP and IPTV billing systems development in C++, performance and stability fixes for oldest Russian's e-commerce sites.

Slides