MySQL Performance Schema in Action: the Complete Tutorial

Monday 9:00AM - 12:00PM

@ Wall Street 2+3

MySQL/MariaDB

3 hours tutorial

Intermediate

Tracks:
Tutorial

Performance Schema is powerful diagnostic instrument for:

- Query performance
- Complicated locking issues
- Memory leaks
- Resource usage
- Problematic behavior, caused by inappropriate settings
- More

It comes with hundreds of options which allow precisely tune what to instrument. More than 100 consumers store collected data.

In this tutorial we will try all important instruments out. We will provide test environment and few typical problems which could be hardly solved without Performance Schema. You will not only learn how to collect and use this information, but have experience with it.


Speakers

Sveta Smirnova

Sveta Smirnova (Percona)

Principal Support Escalation Specialist

Biography:

Sveta Smirnova works as MySQL Support engineer since year 2006. She is author of book "MySQL Troubleshooting" (http://shop.oreilly.com/product/0636920021964.do) and MySQL Labs project "JSON UDFs for MySQL": design prototype of today JSON support in MySQL. After starting her career as a web developer, Sveta moved to a role in Bugs Analysis MySQL Support Group in MySQL AB/Sun/Oracle, then, in March 2015, joined the Support Team in Percona. She works on MySQL software bugs, escalations and tricky Support issues on a daily basis. Her main professional interest in recent years is finding better ways to effectively solve DBA problems.


Alexander Rubin

Alexander Rubin (Percona)

Principal Architect (Consulting)

Biography:

Alexander joined Percona in 2013. Alexander worked with MySQL since 2000 as DBA and Application Developer. Before joining Percona he was doing MySQL consulting as a principal consultant for over 7 years (started with MySQL AB in 2006, then Sun Microsystems and then Oracle). He helped many customers design large, scalable and highly available MySQL systems and optimize MySQL performance. Alexander also helped customers design Big Data stores with Apache Hadoop and related technologies.


Slides



  Download Slides  

Connect with Percona

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863