Mysqld Exporter Versions Save

Exporter for MySQL server metrics

v0.15.1

3 months ago
  • Rebuild for dependency updates

v0.15.0

9 months ago

BREAKING CHANGES:

The exporter no longer supports the monolithic DATA_SOURCE_NAME environment variable. To configure connections to MySQL you can either use a my.cnf style config file or command line arguments.

For example:

export MYSQLD_EXPORTER_PASSWORD=secret
mysqld_exporter --mysqld.address=localhost:3306 --mysqld.username=exporter

We have also dropped some internal scrape metrics:

  • mysql_exporter_scrapes_total
  • mysql_exporter_scrape_errors_total
  • mysql_last_scrape_failed

The default client configuration file is now .my.cnf in the process working directory. Use --config.my-cnf="$HOME/.my.cnf" to retain the previous default.

Changes:

  • [CHANGE] Allow tlsCfg.InsecureSkipVerify outside of mTLS #631
  • [CHANGE] Update to exporter-toolkit v0.8.1 #677
  • [CHANGE] Fix shared metrics between requests #722
  • [CHANGE] Allow empty passwords #742
  • [CHANGE] Don't use HOME env in the my-cnf config path. #745
  • [FEATURE] Add support for collecting metrics from sys.user_summary #628
  • [FEATURE] Support for multi-target mysqld probes #651
  • [FEATURE] Add MySQL TLS configurations #718
  • [FEATURE] Add config reload via /-/reload #734
  • [ENHANCEMENT] Add UNIX domain socket support for multi-target scraping #707
  • [ENHANCEMENT] Use STRAIGHT_JOIN in infoSchemaAutoIncrementQuery #726
  • [BUGFIX] Fix infoSchemaInnodbMetricsEnabledColumnQuery #687
  • [BUGFIX] Allow empty passwords #742

v0.15.0-rc.0

11 months ago

BREAKING CHANGES:

The exporter no longer supports the monolithic DATA_SOURCE_NAME environment variable. To configure connections to MySQL you can either use a my.cnf style config file or command line arguments.

For example:

export MYSQLD_EXPORTER_PASSWORD=secret
mysqld_exporter --mysqld.address=localhost:3306 --mysqld.username=exporter

We have also dropped some internal scrape metrics:

  • mysql_exporter_scrapes_total
  • mysql_exporter_scrape_errors_total
  • mysql_last_scrape_failed

Changes:

  • [CHANGE] Allow tlsCfg.InsecureSkipVerify outside of mTLS #631
  • [CHANGE] Update to exporter-toolkit v0.8.1 #677
  • [CHANGE] Fix shared metrics between requests #722
  • [FEATURE] Add support for collecting metrics from sys.user_summary #628
  • [FEATURE] Support for multi-target mysqld probes #651
  • [FEATURE] Add MySQL TLS configurations #718
  • [ENHANCEMENT] Add UNIX domain socket support for multi-target scraping #707
  • [BUGFIX] Fix infoSchemaInnodbMetricsEnabledColumnQuery #687

v0.14.0

2 years ago

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

v0.13.0

2 years ago

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

v0.13.0-rc.0

2 years ago

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
  • [ENHANCEMENT] Support heartbeats in UTC #471
  • [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

v0.12.1

4 years ago

Changes:

  • Rebuild to update Docker packages.

v0.12.0

4 years ago

BREAKING CHANGES:

The minimum supported MySQL version is now 5.5.

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

Changes:

  • [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)

v0.11.0

5 years ago

BREAKING CHANGES:

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

This also changes the behavior of boolean flags.

  • Enable: --collector.global_status
  • Disable: --no-collector.global_status

Changes:

  • [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

v0.10.0

6 years ago

0.10.0 / 2017-04-25

  • [FEATURE] Add read/write query response time #166
  • [FEATURE] Add Galera gcache size metric #169
  • [FEATURE] Add MariaDB multi source replication support #178
  • [FEATURE] Implement heartbeat metrics #183
  • [FEATURE] Add basic file_summary_by_instance metrics #189
  • [BUGFIX] Workaround MySQL bug 79533 #173