MySQL 5.7: Performance Schema Improvements

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

Experience level: 
Intermediate
Duration: 
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.


Speakers

Software Development Senior 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 Senior Software Development Manager in Oracle's MySQL Enterprise Tools group where he helps lead development of MySQL Enterprise Monitor, MySQL Proxy, and works closely with the MySQL server team on the Performance Schema, and MySQL instrumentation in general. Mark also develops ps_helper, a collection of views, procedures and functions, that can be used to help interpret Performance Schema data.