I setup 6 shiny new MySQL 5.6.13 MySQL servers, ready for testing and production deployment tomorrow.
I found that the New Relic MySQL Monitoring was throwing the following error.
[2013-08-08 03:53:33 +0000] com.newrelic.plugins.mysql.MySQL | SEVERE | An SQL error occured running 'SHOW ENGINE INNODB STATUS' Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
Simple fix, the user I am gathering metrics requires the PROCESS privilege. Again simple enough.… [Read more...]