Hi,
I had an alert yesterday for the Threads_connected datapoint on the MySQL Global Stats datasource. We actually increased the max_connections in the my.cnf config file.
Is it possible to either read my.cnf file (assuming SSH credentials are available), or get the max connections variable to see what it is actually configured as?
This will negate the need to manually check the value in the config and adjust thresholds.
Yes, you could write a property source that would SSH into the server and get the max_connections from the config file and set it as a property on the device. Then you'd need to slightly modify the mysql global stats datasource so that it used that property in a complex datapoint that uses a formula like this:
if(un(##max_connections##), threads_connected, threads_connected / ##max_connections##)
I haven't tested this, but this is the gist of how it would work.
There's an example Expect script here: https://github.com/sweenig/monitoring-recipes/blob/master/DataSources/Groovy/Expect/Groovy_Expect_Example.groovy
ProfessorOr, you could not add SSH overhead and just use a query :).
MariaDB [(none)]> show variables like '%conn%';
+-----------------------------------------------+-----------------+
| Variable_name | Value |
+-----------------------------------------------+-----------------+
| character_set_connection | utf8 |
| collation_connection | utf8_general_ci |
| connect_timeout | 10 |
| default_master_connection | |
| extra_max_connections | 1 |
| init_connect | |
| max_connect_errors | 100 |
| max_connections | 151 |
| max_user_connections | 0 |
| performance_schema_session_connect_attrs_size | -1 |
+-----------------------------------------------+-----------------+
10 rows in set (0.00 sec)
Confirmed via same user with GRANT USAGE as normally required for "show global status" results.
Even better. To be clear @mnagel, you're suggesting the query in the property source, right?
ProfessorEither way, but a property has the advantage of being able to be referenced in alert messages, so sure :). If you want to reference it for percentage utilization, I think it still needs to be a DP as well.
ProfessorI don't think so, but perhaps. global status should have current statistics and variables should have static settings. Could be wrong, of course.
As far as the DP versus property issue, yeah, I have run into this before. We wanted to be able to reference a property in widgets and you simply can't, so we had to create a datapoint from the property (this is to be able to display resource commit usage for our clients). So, we have a DS applied to collectors that only has complex groovy datapoints with the value ##property## for each. Rough edges :).
