mysqld_exporter error after upgrading mysql to 5. 7

[vijay kumar]

Hi All ,

we have recently upgraded our mysql database from 5.6 to 5.7 after the upgrade mysqld_exporter is facing issue and getting below error . any help on this would be really appreciated . Thanks in advance . 

"Error pinging mysqld: Error 1226: User 'mysqld_exporter' has exceeded the 'max_user_connections' resource (current value: 5)" source="exporter.go:146"

[Matthias Rampke]

The exporter collects multiple pieces of information in parallel, and thus (I think) opens multiple connections. I don't know if there is an upper bound. It appears that your MySQL setup is limiting how many connections are allowed per user?

/MR

--
You received this message because you are subscribed to the Google Groups "Prometheus Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to prometheus-use...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/42c0ae11-4cfe-4d82-9ed0-b7128c59756cn%40googlegroups.com.