MySQL Performance Schema - FOSSAsia 2015

Published on: Sunday, 15 March 2015

Topic: MySQL Performance Schema - Monitoring MySQL Server with Perfromance Schema and enhancement in MySQL 5.7

Speaker: Mayank Prasad, Oracle India Private Limited

The MySQL Performance Schema is a feature for monitoring Oracle's
MySQL Server execution at a low level. This versatile and tightly
integrated component collects performance and session data from
various subsystems within the server during runtime with minimal
impact on overall server performance. This feature was introduced in
MySQL 5.5 and MySQL 5.6 was released with great enhancements in
it for performance monitoring and tuning. In 5.7 milestone releases as
well, there are multiple new functionalities have been added. This talk
aims to give an overview of Performance Schema and how/what
statistical information user is provided with using Performance
Schema and how that information can be used for monitoring and
trouble shooting to track an issue back to the relevant file and line of
code in source file.

Produced by Engineers.SG

Help us caption & translate this video!