Using the sys schema
The sys schema helps you interpret the data collected from the performance_schema in an easy and more understandable form. performance_schema should be enabled for sys schema to work. To use the sys schema to its fullest extent, you need to enable all the consumers and timers on performance_schema, but this impacts the performance of the server. So, enable consumers for only those that you are looking for.
A view with the x$ prefix displays data in picoseconds, which is used by other tools for further processing; other tables are human readable.
How to do it...
Enable a instrument from the sys schema:
mysql> CALL sys.ps_setup_enable_instrument('statement');
+------------------------+
| summary |
+------------------------+
| Enabled 22 instruments |
+------------------------+
1 row in set (0.08 sec)
Query OK, 0 rows affected (0.08 sec)If you want to reset to default, do this:
mysql> CALL sys.ps_setup_reset_to_default(TRUE)\G
*************************...
