MySQL Performance Schema - A great insight of running MySQL Server - Mayank Prasad - FOSSASIA 2018

Published on: Sunday, 25 March 2018

Speaker: Mayank Prasad
Info: https://2018.fossasia.org/event/speakers.html#mayank-prasad3078

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.With help of few real world use cases, this talk aims to explain how/what statistical information user is provided with using Performance Schema. With these use cases, it also explains how this 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. Again, with some use cases, this talk also explains how Performance Schema gives consolidated view of different activities of MySQL server behind the scene with the multiple summary tables and how this can be tuned and used. This talk also covers the manual/automatic configuration of Performance Schema to suite to individual requirement in a specific scenario.This talk is targeted to many database users which includes DBA, Database Application developers, Database developers, Students. This talk is to give overview of MySQL Performance Schema and also how/what information can be collected using it and how this information could be used further for debugging/trouble shooting Database users' issue.Takeaways from the talk: - Overview of tuning and monitoring MySQL Server activities using Performance Schema. - Understanding of how to tailor the Performance Schema to track the data you want. - With few real world usecases, explain how to diagnosing problems with the Performance Schema.  - A glimpse of new features in Performance Schema in MySQL 5.7 GA.

Track: Database
Room: Training room 2-1
Date: Sunday, 25th March, 2018

Event Page: http://2018.fossasia.org
Follow FOSSASIA on Twitter: https://twitter.com/fossasia/
Like FOSSASIA on Facebook: https://www.facebook.com/fossasia/

Produced by Engineers.SG

Organization