Percona Live: Open Source Database Performance Conference - Amsterdam 2016 Logo

October 3-5, 2016

Amsterdam, Netherlands

MySQL Performance Schema & Sys Schema

MySQL Performance Schema & Sys Schema

 5 October 5:25 PM - 6:15 PM @ Matterhorn 2
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
MySQL
Topics:
MySQL
Tools and Techniques
Metrics

Description

The MySQL sys schema was integrated fully into MySQL Server from version 5.7.7 and has been improved in MySQL 8.0. 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, MySQL @ 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