Monitoring MySQL with Sys Schema
davidstokes
So just who is hogging your database's I/O, using queries without indexes, and making a mess of your MySQL database? The Sys Schema is a free set of routines, views, and stored procedured that can easily tell you the answer to those questions and more easily. This level of information was the preview of high level DBAs until only recently. Now anyone with administrator privileges can investigate their performance of their MySQL instances. And by popular demand, the Sys Schema is included with the new MySQL 5.7 release.