Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

Performance schema and sys schema in MySQL 5.7

Performance schema and sys schema in MySQL 5.7

 19 April 02:20 PM - 3:10 PM @ Room 210
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Operations and Management
Topics:
MySQL
Metrics
Monitoring

Description

MySQL 5.7 now includes the sys schema by default, which builds upon the awesome instrumentation framework laid by Performance Schema. Performance Schema has had 23 worklogs completed in 5.7 alone, such as memory instrumentation, tying in transactions and stored programs in to the current statement/stage/wait instruments and wait graph, prepared statement instruments, metadata lock information, improved session status and variable reporting, the new structured replication tables, and more. The sys schema builds upon this strong foundation with easy reporting views and functions, as well as procedures to help both set up and manage the configuration of Performance Schema, and help diagnose performance issues with your database instances on the whole. Come along and hear from the original developer of the sys schema about all of these exciting improvements in MySQL instrumentation for the new MySQL 5.7 release!

Speakers

Mark Leith's picture

Mark Leith

Senior Software Development Manager, Oracle

Biography:

Mark has worked on MySQL, Oracle, Sybase and SQL Server servers, and monitoring and management tools for these, for an extensive time. He joined MySQL in 2005 as a Support Engineer and is now a Senior Software Development Manager in Oracle's MySQL Enterprise Tools group, where he helps lead development of MySQL Enterprise Monitor. He also works closely with the MySQL server team on the Performance Schema, and MySQL instrumentation in general, as well as the integration of the Sys schema. Mark is the original developer of the sys schema, a collection of views, procedures and functions, that can be used to help interpret Performance Schema and Information Schema data.

Share this talk


Slides