Oracle DBAs have has the luxury of their V$ variables for a long time while we MySQL DBAs pretended we were not envious. With MySQL 5.6 and 5.7 we were gifted with the PERFORMANCE_SCHEMA tables. But there is such a wealth of information in those tables that it is intimidating to plunge in to them. Thankfully Mark Leith has given us the SYS Schema. The SYS Schema is a collection of views, functions and procedures to help MySQL administrators get insight in to MySQL Database usage.
The first step is to get a copy of the SYS
SCHEMA files.
git clone https://github.com/MarkLeith/mysql-sys
Next install the SYS Schema (here for MySQL
5.7)
mysql -u root -p < ./sys_57.sql
Now run MySQL and look at this …
[Read more]