mysql 5.1 working config

[deln...@gmail.com]

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?

[Ben Kochie]

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 deln...@gmail.com <deln...@gmail.com> 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 prometheus-use...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/00a0e627-563f-4c4f-a23e-fda3454f3427n%40googlegroups.com.

[deln...@gmail.com]

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

[Ben Kochie]

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 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.

To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/c0d52455-1e40-44ab-8714-a45a6c5b2308n%40googlegroups.com.

[deln...@gmail.com]

Thanks. Sadly no Go skills. Unless it's smth trivial. 

[deln...@gmail.com]

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?