A collection of scripts to help MySQL DBAs
Latest commit 500b9bf Dec 19, 2013 @MarkLeith Merge pull request #6 from aadant/master
Merge changes from Arnaud Adant to add schema to statement views, as well as first and last seen, and a couple of extra stats.
Permalink
Failed to load latest commit information.
functions
procedures
views adding db, first_seen, last_seen Dec 18, 2013
README.md
after_setup.sql
before_setup.sql
ps_helper_55.sql
ps_helper_56.sql
ps_helper_57.sql

README.md

dbahelper

A collection of scripts to help MySQL DBAs

There are install files available for 5.5, 5.6 and 5.7 respectively. To load these, you must position yourself within the directory that you downloaded to, as these top level files SOURCE individual files that are shared across versions in most cases (though not all).

For instance if you download to /tmp/dbahelper/ you should:

cd /tmp/dbahelper/
mysql -u user -p < ./ps_helper_<version>.sql

Or if you would like to log in to the client:

cd /tmp/dbahelper/
mysql -u user -p 
SOURCE ./ps_helper_<version>.sql

Alternatively, you could just choose to load individual files based on your needs, but beware, certain objects have dependencies on other objects.