search

apache / hertzbeat

Apache HertzBeat(incubating) is a real-time monitoring system with agentless, performance cluster, prometheus-compatible, custom monitoring and status page building capabilities.
https://hertzbeat.apache.org/
Apache License 2.0
5.7k stars 986 forks source link

[Question] Mysql Monitor Template fields And Monitor Rule #2289

Open QBH-insist opened 3 months ago

QBH-insist commented 3 months ago

Question

"Version"： v1.6

  1. The Chinese explanation for the 'Connections' field in the MySQL monitoring template seems to be incorrect

image

https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html image

  1. Then, I want to set the rule '${threads_connected} >=({max_connections}*0.9)'. Is this rule available and feasible, considering that these two data points are located on different tabs?
tomsun28 commented 3 months ago

can you help sumbit a pr to fix it?

Yanshuming1 commented 3 months ago

Second, are you trying to set threshold rules? General calculates calculates should not write '>' matches, and they must be under the same name if you want to set display

QBH-insist commented 3 months ago

can you help sumbit a pr to fix it?

https://github.com/apache/hertzbeat/pull/2294

QBH-insist commented 3 months ago

Second, are you trying to set threshold rules? General calculates calculates should not write '>' matches, and they must be under the same name if you want to set display

Yes, I was wondering if it's possible to compare ${BasicInfo#MaxConnections} with ${ThreadInfo#ThreadsConnected} within a mysql threshold rule

Yanshuming1 commented 3 months ago

Second, are you trying to set threshold rules? General calculates calculates should not write '>' matches, and they must be under the same name if you want to set display

Yes, I was wondering if it's possible to compare ${BasicInfo#MaxConnections} with ${ThreadInfo#ThreadsConnected} within a mysql threshold rule

No, he collects data based on name each time, not all name data at one time, and the calculation of alarms can only be calculated based on the fields under name。 @tomsun28 Am I explaining this correctly？

tomsun28 commented 3 months ago

hi, yes, not support now. But this is a common requirement. Let's see how to implement it later.