MySQL Performance Schema in Action

Tuesday 2:00PM - 5:00PM

@ Hill Country C

MySQL/MariaDB

3 hours tutorial

Intermediate

Tracks:
MySQL, Observability & Monitoring

Performance Schema is a 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 tuning what to instrument. More than 100 consumers store collected data.

In this tutorial, we will try all the important instruments out. We will provide a test environment and a 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 a MySQL Support engineer since the year 2006. She is the 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 primary professional interest in recent years is finding better ways to solve DBA problems effectively.


Alexander Rubin

Alexander Rubin (VirtualHealth)

Director, Data Architecture

Biography:

Alexander has over 10 years industry experience with the MySQL database and related technologies. His specialties are performance tuning, full text search, high availability, database infrastructure architecture and data warehouses. He has helped many MySQL customers design extremely high performance databases with optimized schema and queries.


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