Thanks. Sadly no Go skills. Unless it's smth trivial. On Monday, August 24, 2020 at 10:44:12 AM UTC+2 [email protected] wrote:
> Ahh, I see, yes, it looks like that was added in msqld_exporter 0.11, so > you would have to run 0.10 or older. > > It looks like lock_wait_timeout > <https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_lock_wait_timeout> > was > introduced in 5.5. > > It looks like the way we implemented this is always enabled. I would > accept a PR to make it optional. > > On Mon, Aug 24, 2020 at 10:13 AM [email protected] <[email protected]> > wrote: > >> Think I'm already starting exporter with these collectors disabled - >> here's the no-collector arguments section: >> --no-collect.info_schema.innodb_metrics >> --no-collect.info_schema.innodb_cmp --no-collect.info_schema.innodb_cmpmem >> >> nohup.out >> time="2020-08-24T01:08:57-07:00" level=info msg="Starting mysqld_exporter >> (version=0.12.1, branch=HEAD, >> revision=48667bf7c3b438b5e93b259f3d17b70a7c9aff96)" >> source="mysqld_exporter.go:257" >> time="2020-08-24T01:08:57-07:00" level=info msg="Build context >> (go=go1.12.7, user=root0b3e56a7bc0a, date=20190729-12:35:58)" >> source="mysqld_exporter.go:258" >> time="2020-08-24T01:08:57-07:00" level=info msg="Enabled scrapers:" >> source="mysqld_exporter.go:269" >> time="2020-08-24T01:08:57-07:00" level=info msg=" >> --collect.global_status" source="mysqld_exporter.go:273" >> time="2020-08-24T01:08:57-07:00" level=info msg=" >> --collect.global_variables" source="mysqld_exporter.go:273" >> time="2020-08-24T01:08:57-07:00" level=info msg=" --collect.slave_status" >> source="mysqld_exporter.go:273" >> time="2020-08-24T01:08:57-07:00" level=info msg=" >> --collect.info_schema.query_response_time" source="mysqld_exporter.go:273" >> time="2020-08-24T01:08:57-07:00" level=info msg="Listening on >> 0.0.0.0:9104" source="mysqld_exporter.go:283" >> time="2020-08-24T01:09:01-07:00" level=error msg="Error pinging mysqld: >> Error 1193: Unknown system variable 'lock_wait_timeout'" >> source="exporter.go:146" >> time="2020-08-24T01:09:06-07:00" level=error msg="Error pinging mysqld: >> Error 1193: Unknown system variable 'lock_wait_timeout'" >> source="exporter.go:146" >> time="2020-08-24T01:09:11-07:00" level=error msg="Error pinging mysqld: >> Error 1193: Unknown system variable 'lock_wait_timeout'" >> source="exporter.go:146" >> time="2020-08-24T01:09:16-07:00" level=error msg="Error pinging mysqld: >> Error 1193: Unknown system variable 'lock_wait_timeout'" >> source="exporter.go:146" >> time="2020-08-24T01:09:21-07:00" level=error msg="Error pinging mysqld: >> Error 1193: Unknown system variable 'lock_wait_timeout'" >> source="exporter.go:146" >> time="2020-08-24T01:09:26-07:00" level=error msg="Error pinging mysqld: >> Error 1193: Unknown system variable 'lock_wait_timeout'" >> source="exporter.go:146" >> time="2020-08-24T01:09:31-07:00" level=error msg="Error pinging mysqld: >> Error 1193: Unknown system variable 'lock_wait_timeout'" >> source="exporter.go:146" >> time="2020-08-24T01:09:36-07:00" level=error msg="Error pinging mysqld: >> Error 1193: Unknown system variable 'lock_wait_timeout'" >> source="exporter.go:146" >> time="2020-08-24T01:09:41-07:00" level=error msg="Error pinging mysqld: >> Error 1193: Unknown system variable 'lock_wait_timeout'" >> source="exporter.go:146" >> time="2020-08-24T01:09:46-07:00" level=error msg="Error pinging mysqld: >> Error 1193: Unknown system variable 'lock_wait_timeout'" >> source="exporter.go:146" >> time="2020-08-24T01:09:51-07:00" level=error msg="Error pinging mysqld: >> Error 1193: Unknown system variable 'lock_wait_timeout'" >> source="exporter.go:146" >> time="2020-08-24T01:09:56-07:00" level=error msg="Error pinging mysqld: >> Error 1193: Unknown system variable 'lock_wait_timeout'" >> source="exporter.go:146" >> time="2020-08-24T01:10:01-07:00" level=error msg="Error pinging mysqld: >> Error 1193: Unknown system variable 'lock_wait_timeout'" >> source="exporter.go:146" >> time="2020-08-24T01:10:06-07:00" level=error msg="Error pinging mysqld: >> Error 1193: Unknown system variable 'lock_wait_timeout'" >> source="exporter.go:146" >> time="2020-08-24T01:10:11-07:00" level=error msg="Error pinging mysqld: >> Error 1193: Unknown system variable 'lock_wait_timeout'" >> source="exporter.go:146 >> On Monday, August 24, 2020 at 9:32:27 AM UTC+2 [email protected] wrote: >> >>> Although it's not officially supported, the latest version should still >>> work. You will need to disable some collectors that are incompatible with >>> 5.1. >>> >>> See: https://github.com/prometheus/mysqld_exporter/pull/318 >>> >>> On Mon, Aug 24, 2020 at 9:28 AM [email protected] <[email protected]> >>> wrote: >>> >>>> I'm aware that MySQL 5.1 is not supported. Wondering if someone can >>>> help with pointing what version of MySQL_exporter is compatible with 5.1 >>>> version? >>>> >>>> -- >>>> 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/00a0e627-563f-4c4f-a23e-fda3454f3427n%40googlegroups.com >>>> >>>> <https://groups.google.com/d/msgid/prometheus-users/00a0e627-563f-4c4f-a23e-fda3454f3427n%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/c0d52455-1e40-44ab-8714-a45a6c5b2308n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/prometheus-users/c0d52455-1e40-44ab-8714-a45a6c5b2308n%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/cea83fa6-a6a4-4d98-82bc-c9db998b6fe9n%40googlegroups.com.
