Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Fully merge mysqld_exporter with upstream

Description

In we merged upstream's master branch which should become v0.11 soon. We do not expect much changed between the current state and released version. Still, we need to merge with released version when it is available.
----------
2) Merge upstream - 8SP - 15SP

 

Option 2 has sense only if we will update it in some interval to dont get exporter outdated again, othervise we running in the circle.

 

List of changes, bugfixes between our and upstream version:

0.14.0 / 2022-01-05 

 

BREAKING CHANGES:

Metric names in the info_schema.processlist collector have been changed. #603
Metric names in the info_schema.replica_host collector have been changed. #496

  • [CHANGE] Rewrite processlist collector #603

  • [FEATURE] Add collector for replica_host_status #496

  • [ENHANCEMENT] Expose dates as timestamps grom GLOBAL STATUS #561

  • [BUGFIX] Fix mysql_slave_hosts_info for mysql 5.5 and mariadb 10.5 #577

  • [BUGFIX] Fix logging issues #562 #602
     

    0.13.0 / 2021-05-18

    BREAKING CHANGES:

Changes related to replication_group_member_stats collector:

  • metric "transaction_in_queue" was Counter instead of Gauge

  • renamed 3 metrics starting with mysql_perf_schema_transaction_ to start with mysql_perf_schema_transactions_ to be consistent with column names

  • exposing only server's own stats by matching MEMBER_ID with @@server_uuid resulting "member_id" label to be dropped.

Changes:

  • [CHANGE] Switch to go-kit for logs. #433

  • [FEATURE] Add tls.insecure-skip-verify flag to ignore tls verification errors #417

  • [FEATURE] Add collector for AWS Aurora information_schema.replica_host_status #435

  • [FEATURE] Add collector for replication_group_members #459

  • [FEATURE] Add new metrics to replication_group_member_stats collector to support MySQL 8.x. #462

  • [FEATURE] Add collector for performance_schema.memory_summary_global_by_event_name #515

  • [FEATURE] Support authenticating using mTLS client cert and no password #539

  • [FEATURE] Add TLS and basic authentication #522

  • [ENHANCEMENT] Support heartbeats in UTC #471

  • [ENHANCEMENT] Improve parsing of boolean strings #548

  • [BUGFIX] Fix binlog metrics on mysql 8.x #419

  • [BUGFIX] Fix output value of wsrep_cluster_status #473

  • [BUGFIX] Fix collect.info_schema.innodb_metrics for new field names (mariadb 10.5+) #494

  • [BUGFIX] Fix log output of collect[] params #505

  • [BUGFIX] Fix collect.info_schema.innodb_tablespaces for new table names #516

  • [BUGFIX] Fix innodb_metrics for mariadb 10.5+ #523

  • [BUGFIX] Allow perf_schema.memory summary current_bytes to be negative #517

    0.12.0 / 2019-07-10

    HTTPS://GITHUB.COM/PROMETHEUS/MYSQLD_EXPORTER/BLOB/MASTER/CHANGELOG.MD#BREAKING-CHANGES-2BREAKING CHANGES:

The minimum supported MySQL version is now 5.5.

Collector info_schema.tables is now disabled by default due to high cardinality danger.

https://github.com/prometheus/mysqld_exporter/blob/master/CHANGELOG.md#changes-2Changes:

  • [CHANGE] Update defaults for MySQL 5.5 #318

  • [CHANGE] Update innodb buffer pool mappings #369

  • [CHANGE] Disable info_schema.tables collector by default #406

  • [BUGFIX] Sanitize metric names in global variables #307

  • [BUGFIX] Use GLOBAL to prevent mysql deadlock #336

  • [BUGFIX] Clear last_scrape_error on every scrape (PR #368) #367

  • [ENHANCEMENT] Add help for some GLOBAL VARIABLES metrics. #326

  • [FEATURE] Abort on timeout. #323

  • [FEATURE] Add minimal MySQL version to Scraper interface #328

  • [FEATURE] Add by_user and by_host metrics to info_schema.processlist collector (PR #333) #334

  • [FEATURE] Add wsrep_evs_repl_latency metric collecting. (PR #338)

  • [FEATURE] Add collector for mysql.user (PR #341)

  • [FEATURE] Add perf_schema.eventsstatementssum collector #347

  • [FEATURE] Add collector to get table stats grouped by schema (PR #354)

  • [FEATURE] Add replication_applier_status_by_worker metric collecting. (PR #366)

https://github.com/prometheus/mysqld_exporter/blob/master/CHANGELOG.md#0110--2018-06-290.11.0 / 2018-06-29

https://github.com/prometheus/mysqld_exporter/blob/master/CHANGELOG.md#breaking-changes-3BREAKING CHANGES:

  • Flags now use the Kingpin library, and require double-dashes. #222

This also changes the behavior of boolean flags.

  • Enable: --collect.global_status

  • Disable: --no-collect.global_status

https://github.com/prometheus/mysqld_exporter/blob/master/CHANGELOG.md#changes-3Changes:

  • [CHANGE] Limit number and lifetime of connections #208

  • [ENHANCEMENT] Move session params to DSN #259

  • [ENHANCEMENT] Use native DB.Ping() instead of self-written implementation #210

  • [FEATURE] Add collector duration metrics #197

  • [FEATURE] Add 'collect[]' URL parameter to filter enabled collectors #235

  • [FEATURE] Set a lock_wait_timeout on the MySQL connection #252

  • [FEATURE] Set last_scrape_error when an error occurs #237

  • [FEATURE] Collect metrics from performance_schema.replication_group_member_stats #271

  • [FEATURE] Add innodb compression statistic #275

  • [FEATURE] Add metrics for the output of SHOW SLAVE HOSTS #279

  • [FEATURE] Support custom CA truststore and client SSL keypair. #255

  • [BUGFIX] Fix perfEventsStatementsQuery #213

  • [BUGFIX] Fix file_instances metric collector #205

  • [BUGFIX] Fix prefix removal in perf_schema_file_instances #257

  • [BUGFIX] Fix 32bit compile issue #273

  • [BUGFIX] Ignore boolean keys in my.cnf. #283

How to test

None

How to document

None

Attachments

1

Smart Checklist

hide

Activity

rasika.chivate May 23, 2022 at 10:26 AM

Thanks  

Taras Shcherban May 23, 2022 at 10:23 AM

here's list of changes for updating exporter in markdown format:

might be useful when writing release notes

FYI  

Taras Shcherban May 9, 2022 at 11:36 AM
Edited

tls.insecure-skip-verify flag was introduced in upstream. Going to leave both (our is mysql.ssl-skip-verify) for backward compatibility.

collect.info_schema.processlist.min_time, collect.info_schema.processlist flags were renamed to avoid collision with ours (added suffix .prometheus). Will have our/upstream collectors implementations respectively.

FYI

Nurlan Moldomurov October 11, 2021 at 1:58 PM

, please check if description is up to date.

Jira Bot March 9, 2021 at 12:56 PM

To:
CC:

Hi, I'm jira-bot, Percona's Jira automation tool. I've detected that someone from
Percona has made an edit to the Summary field of an issue that you reported.

I'm not sentient (yet) so I'm not sure whether the person fixed a typo, changed
a few words, or completely rewrote the text. In any case, it is Percona Engineering's
intention to make the Summary and Description of an issue as accurate as possible
so that we're fixing the actual problem you're encountering, and to avoid
misunderstandings about symptoms and causes.

If the current Summary does not accurately reflect the problem you are reporting,
or if you feel the change was otherwise inappropriate in some way, please add a
new comment explaining things and we'll address it as soon as we can.

This message will be added only once per issue, regardless of how many times
the Summary is edited.

message-code:summary-edited

Done

Details

Assignee

Reporter

Priority

Components

Labels

Fix versions

Story Points

Smart Checklist Progress

Smart Checklist

Created February 9, 2018 at 1:17 PM
Updated November 13, 2024 at 9:46 AM
Resolved May 23, 2022 at 2:42 PM