Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

NO label mysql_info_schema_threads #487

Open
yangvipguang opened this issue Jul 3, 2020 · 11 comments
Open

NO label mysql_info_schema_threads #487

yangvipguang opened this issue Jul 3, 2020 · 11 comments

Comments

@yangvipguang
Copy link

Host operating system: output of uname -a

Centos 7

mysqld_exporter version: output of mysqld_exporter --version

MySQL server version

mysql 5.7

mysqld_exporter command line flags

--collect.slave_status
--collect.slave_hosts
--log.level=error
--collect.info_schema.processlist
--collect.info_schema.innodb_metrics
--collect.info_schema.innodb_tablespaces
--collect.info_schema.innodb_cmp
--collect.info_schema.innodb_cmpmem
--collect.perf_schema.eventsstatements
--collect.perf_schema.eventsstatements.digest_text_limit
--collect.perf_schema.eventsstatements.limit
--collect.perf_schema.eventsstatements.timelimit
--collect.perf_schema.file_events
--collect.perf_schema.indexiowaits
--collect.perf_schema.tableiowaits
--collect.perf_schema.tablelocks
--collect.info_schema.query_response_time
--collect.info_schema.processlist.min_time
--collect.perf_schema.eventsstatementssum

What did you do that produced an error?

can't find the label of mysql_info_schema_threads in the prometheus .Does it change or have been removed ?

What did you expect to see?

What did you see instead?

@Edmodo-Luo
Copy link

Same problem.
Any suggestion?

@micah
Copy link

micah commented Apr 5, 2021

When I pass --collect.info_schema.processlist to the exporter, then I do get that label in prometheus.

@id-id-id
Copy link

When I pass --collect.info_schema.processlist to the exporter, then I do get that label in prometheus.

how to do?

@id-id-id
Copy link

I have the same problem. my exporter is enable info_schema.processlist, but prometheus can not find label mysql_info_schema_threads.

@sancfc
Copy link

sancfc commented Jun 15, 2021

I have the same problem. What is the solution?

@ZhenlanJi
Copy link

I have the same problem. I also add --collect.info_schema.processlist to the args of the exporter, but still fail to get mysql_info_schema_threads

@id-id-id
Copy link

id-id-id commented May 20, 2022 via email

@artemus717
Copy link

same problem with mysqld-exporter 0.14.0 mysql 5.7.37

@djFFFFF
Copy link

djFFFFF commented Aug 3, 2022

Can try mysql_info_schema_processlist_threads.

Reference: #603

@roorq
Copy link

roorq commented Mar 5, 2024

Changing mysql_info_schema_threads to mysql_info_schema_processlist_threads helped. Thanks!

@s4ntos
Copy link

s4ntos commented Oct 17, 2024

Changing mysql_info_schema_threads to mysql_info_schema_processlist_threads helped. Thanks!

This ticket can be closed with this answer, must people are complaining because the grafana dashboard used to monitor mysql its still using the old format

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

10 participants