In MySQL monitoring we use show global status (http://dev.mysql.com/doc/refman/5.7/en/show-variables.html) and show global variables (http://dev.mysql.com/doc/refman/5.7/en/show-status.html)
require any specific privileges, only an ability to connect to the server is
Thanks Jakub! This is the only place where I found this info. I wonder why there's no setup documentation for the MySQL plugin, like there is e.g. for https://www.dynatrace.com/support/help/technology-support/application-software/other-technologies/su...