Before MySQL® 5.6 with Performance Schema, monitoring and troubleshooting were limited to "show global status/show engine InnoDB status" as well as "slow query log." This made it very difficult to get "per-user" and "per-schema" or "per-table" metrics (as opposed to global server and per session metrics). Not anymore.
If you are running MySQL 5.6.6 or higher, Performance Schema is already enabled and ready to use. Performance Schema can be very useful for troubleshooting and ad-hoc monitoring, especially in large, multi-tenant environments. For example, if you are running a database-as-a-service installation for your internal or external clients, you can find out the precise MySQL utilization per user and even be able to "charge by IO or operation."
In this webinar, Percona Principal Consultant Alexander Rubin will show you how to use Performance Schema to:
At the end of the webinar, you will know how to use Performance Schema in MySQL 5.6 to better monitor and troubleshoot your MySQL issues.