-
Notifications
You must be signed in to change notification settings - Fork 750
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Feature request: include collection of SSL expiration from SHOW GLOBAL STATUS output #457
Comments
I have minimal Go experience, but #338 looks like a good example of the changes required when adding new metrics that aren't initially floating point values. Also blackbox-exporter collects SSL expiration with HTTP requests, https://github.com/prometheus/blackbox_exporter/blob/master/prober/http.go#L260 may be another good example. EDIT: Also related https://programming.guide/go/format-parse-string-time-date-example.html |
Figured I'd update with a recent discovery: we can covert the value to epoch time using
|
Hi, I use latest version of So I don't think this issue is resolved ... or I have missed something 🤷 The only metrics I have are the following :
|
I have more information about my last comment, I think there is an issue in cf. following screens (I have edited the source code locally to debug the issue) : For information, with a SQL Client, the 2 variables are as following :
But the |
Issue
It appears that mysqld-exporter does not collect any non-floating point values from
SHOW GLOBAL STATUS;
mysql_global_status_ssl_finished_connects
andmysql_global_status_ssl_session_cache_hits
metricsmysql_global_status_ssl_server_not_after
ormysql_global_status_ssl_server_not_before
metricsMy assumption is that these metrics are skipped due to the SQL command output format being timestamps and not a floating point value.
It would be great to have the SSL expiration metrics available in Prometheus, as then I can create "SSL Expiring Soon" alerts for the certificates loaded by MariaDB.
Thanks :)
Host operating system:
mysqld_exporter version:
MySQL server version
Percona XtraDB (i.e. MariaDB)
The text was updated successfully, but these errors were encountered: