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: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Operations and Management
Topics:
MySQL
Metrics
Monitoring

Description

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.

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