Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

MySQL Performance Schema in Action

MySQL Performance Schema in Action

 24 April - 9:30 AM - 12:30 PM @ Ballroom F
Experience level: 
Intermediate
Duration: 
3 hours tutorial
Tracks:
Operations
Developer
Topics:
MySQL
Optimization
Tools and Techniques

Description

Performance Schema in MySQL is becoming more mature from version to version. In version 5.7, it includes extended lock instrumentation, memory usage statistics, new tables for server variables, first time ever instrumentation for user variables, prepared statements and stored routines. A lot! Amazing! And complicated! In this tutorial we will try all these new instruments out. We will provide a test environment and a few typical problems that could be hardly solved before MySQL 5.7. Just few examples: "Where is memory going?" , "Why do these queries hang?", "How huge is the overhead of my stored procedures?", "Why are queries waiting for metadata locks?". You learn how to collect and use this information. You will also learn how to setup Performance Schema in details. The issues we are going to describe were pains for customers, consultants and support engineers for years. There are many workarounds for them that help to find only part of the source of the issue, and require much more work than can be done if we use Performance Schema. In this tutorial we will start from the problem and show how to diagnose and fix it. We will show which workarounds can be dropped and replaced with queries to Performance Schema. We will include some 8.0 features.

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)

Alexander Rubin's picture

Alexander Rubin

Principal Architect, Percona

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.

Share this talk