MySQL 5.7.7 and higher includes the sys schema,
This has View, Stored Procedures and Functions to gather the performance related information, as it works on Performance Schema the Performance Schema must be enabled for the sys database.
Following some of the important tables:
sys_config: Contains information about configurations (variables).
We can enabled the performance related events as follows:
It is recommended to enable only default instruments and consumers so that if you like you can restore it quick instead to make customized and having problem for restore/resetup.
Sys schema is introduced MySQL 5.7.7 so still DBA has to explore it more as most of the environments are still earlier then this