mysqld_exporter icon indicating copy to clipboard operation
mysqld_exporter copied to clipboard

NO label mysql_info_schema_threads

Open yangvipguang opened this issue 4 years ago • 11 comments

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?

yangvipguang avatar Jul 03 '20 02:07 yangvipguang

Same problem. Any suggestion?

Edmodo-Luo avatar Jan 21 '21 03:01 Edmodo-Luo

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

micah avatar Apr 05 '21 16:04 micah

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

how to do?

id-id-id avatar May 12 '21 01:05 id-id-id

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

id-id-id avatar May 12 '21 01:05 id-id-id

I have the same problem. What is the solution?

sancfc avatar Jun 15 '21 08:06 sancfc

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

ZhenlanJi avatar May 20 '22 03:05 ZhenlanJi

来信已收到,祝好!

id-id-id avatar May 20 '22 03:05 id-id-id

same problem with mysqld-exporter 0.14.0 mysql 5.7.37

artemus717 avatar Aug 02 '22 06:08 artemus717

Can try mysql_info_schema_processlist_threads.

Reference: https://github.com/prometheus/mysqld_exporter/pull/603

djFFFFF avatar Aug 03 '22 07:08 djFFFFF

Changing mysql_info_schema_threads to mysql_info_schema_processlist_threads helped. Thanks!

roorq avatar Mar 05 '24 13:03 roorq