MySQL SYS Schema Deep Dive
Mark Leith
Senior Software Development Manager MySQL Enterprise T ools, Oracle
Program Agenda
Introduction to the MySQL sys schema Installation Formatting / Helper Routines Tracing Routines Summary Views
1
2
3
4
5
Program Agenda
msinfo
Introduction to the MySQL sys schema Installation Formatting / Helper Routines Tracing Routines Summary Views
1
2
3
4
5
You are … :
•Using 5.1?
•Using 5.5?
•Using 5.6?
•Using 5.7?
•A Performance Schema user? •A Sys Schema user?
Why the sys schema?
•Performance Schema exposes a huge amount of data
•Many of its tables can implement multiple different use cases, depending on the type of data
•The sys schema layers on top the (sometimes complex) queries in to a packaged set of easy to use views
•It also adds a number of functions and procedures that help format, configure the output of, and record, Performance Schema data •Implements many of the common day to day DBA and Developer debugging and tuning use cases
Program Agenda
Introduction to the MySQL sys schema Installation Formatting / Helper Routines Tracing Routines Summary Views
1
2
3
4
5