Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

A MySQL Sys Schema Deep Dive

A MySQL Sys Schema Deep Dive

 19 April 3:50 PM - 04:40 PM @ Ballroom C
Experience level: 
50 minutes conference
Operations and Management


The MySQL sys schema was integrated fully into MySQL Server from version 5.7.7. Whether you are a DBA trying to determine where the resources are being used on your database instance and by whom, or a developer trying to figure out why your MySQL statements are running too slowly, the MySQL sys schema can help. Join this session to learn how to better use the MySQL sys schema to answer your day-to-day questions—from the original developer of the MySQL sys schema.


Mark Leith's picture

Mark Leith

Senior Software Development Manager, Oracle


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