MySQL 5.7: Performance Schema Improvements

2 April 3:50PM - 4:40PM @ Ballroom D

Experience level: 
50 minutes conference
Performance Schema within MySQL 5.6 exposed a wealth of new instrumentation useful to DBAs and Developers, bringing statement instrumentation, table usage statistics and more. But the work has not stopped there, there are still plenty of gaps left within the MySQL Server that are not instrumented (or need a different approach to instrumentation), as well as different levels of the life cycle of a session within MySQL that were not yet covered. Come to this session for an overview of what is already available within MySQL 5.6, and to learn what has been added within Performance Schema for MySQL 5.7, including: * Memory Usage * Metadata Locks * Stored Programs (procedures, triggers, functions) * Transactions * Replication Configuration & Status The session will include a brief overview of ps_helper as well, including some practical examples of using this new instrumentation within MySQL 5.7.


Senior Software Development Manager, MySQL @ 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.