Failing to find proper syntax for mysqld_exporter version 0.10 for disabling collectors. I'm getting scrape time ~1.5 minutes when running curl http://127.0.0:1:9104/metrics. I would like to disable all collectors and try with enabling one by one. Any advice?
On Monday, August 24, 2020 at 11:38:35 AM UTC+2 [email protected] wrote: > 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/54b51aa2-a2f0-4d80-b68a-4df0de916033n%40googlegroups.com.
