I’ve configured the MySQL monitoring user as stated in the documentation with
I’m using performance schema service and everything works fine, except that I have “gaps” in the MySQL metrics. Checking the logs I found
... pmm-agent ... Error pinging mysqld: Error 1226: User 'pmm' has exceeded the 'max_connections_per_hour'.
Already increased the value to 50, but still errors (and gaps).
So my resolution would be to set the max_connections_per_hour for this user to ‘0’, but is this advisable (as the documentation states a value of ‘10’)?