[Question] Mysql Monitor Template fields And Monitor Rule

[QBH-insist]

Question

"Version"： v1.6

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

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

2. 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]

can you help sumbit a pr to fix it?

[Yanshuming1]

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]

can you help sumbit a pr to fix it?

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

[QBH-insist]

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]

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]

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