Kontrollbase – queries to update your max_connections alert
If you have been reading the Kontrollbase performance reports and noticed that one alert says your connection usage vs max connections ration is too high but then recommends you to decrease the max_connections variable, then you will find this fix handy. Its two simple queries that execute on the Kontrollbase schema to update the max_connections alert name and description.
Since this particular alert’s logic was changed to display a recommendation for lowering and/or increasing the max_connections variable depending on the usage percentage, the name and description of the alert in the schema needs to be updated as well. If you prefer you can wait until the next version comes out that addresses this change, or you can run the following two queries on your Kontrollbase schema to update the information. Enjoy!
update alerts_def set alert_desc = 'Server connection usage ratio needs to be optimized.' where id = '5';
update alerts_def set alert_name = 'max_connections to max_used_connections ratio not optimal.' where id = '5';