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 On Thu, Sep 3, 2020 at 11:06 AM vijay kumar <[email protected]> wrote: > 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" > > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/prometheus-users/42c0ae11-4cfe-4d82-9ed0-b7128c59756cn%40googlegroups.com > <https://groups.google.com/d/msgid/prometheus-users/42c0ae11-4cfe-4d82-9ed0-b7128c59756cn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/CAMV%3D_gaUMmNY0TeRVCBBD9E1_bxhNwCOBKKB-%3DhZYJaiDqP3Eg%40mail.gmail.com.
