Page History
The Monyog Object model (MOM) abstracts all OS/MySQL values required for calculating all performance metric. It relieves the user from performing low level tasks like connecting to the servers, executing SQL statement, checking return codes, etc.
...
Similarly the following Object Models are defined as follows:
Variable | MOM Object |
|
|
|
|
|
|
OS-level counters |
|
Note |
---|
Operating system-level counters measure CPU, memory usage, and so on. |
MOM variable for SQL DM for MySQL tags and server names
AlertCondition:
This attribute expects an expression that should evaluate to one the following 3 values: " Critical", " Warning" , or " None". Generally, a JS expression or function is specified which compares some of the MOM values to the Warning or Critical threshold values defined above. (Optional) Consider two examples of a monitor to receive alerts based on an alert condition.
Code Block | ||
---|---|---|
| ||
function() { if(ToInt(MONyog.MySQL.GlobalStatus.Select_scan) > 1000) return GetWarnStatusInt(this.Value, this.Critical, this.Warning, true); else return "None"; } |
Code Block | ||
---|---|---|
| ||
function()
{
if(this.Value != "(n/a)" && this.Value > 1)
return "Critical";
else
return "None";
} |
WarmUpRequired: A values value of " Yes " specifies that this metric makes sense only if the server is running for a minimum period of time. If the server is not running for the minimum period, AlertCondition won't be is not evaluated and no alerts would be displayed or notified. The default value is 3 hours, if you want to change this value; go to Settings -> , select General you will find MYSQL WARMUP PERIOD.
...
NotifyStableOverride: A MOM variable that takes either "Yes" or "No" as a value and overrides the server-level "Notify when stable" setting at the counter-level.
Anchor MOM-variables MOM-variables
MOM-variables | |
MOM-variables |
MOM variables for SQL DM for MySQL tags and server names
...
MONyog.Connections.ConnectionName
Gives the name of that server. This can be extremely useful while setting different threshold levels (based on tags or server names) for a monitor. ExampleFor example:
The following can be added to the critical/warning field in Add/Edit server->View Advanced to set server and tag specific thresholds.
...
MONyog.MySQL.InnodbStatus.Deadlock_detected
: Any new Innodb deadlock is foundMONyog.MySQL.InnodbStatus.Last_detected_time
: Period in which last deadlock is detectedMONyog.MySQL.InnodbStatus.Latest_deadlock
: Latest deadlock is detected
Scroll pdf ignore | ||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Website Newtabfooter |
| Products | Buy | Support | Community | About Us | Resources | Legal
Newtabfooter |
Newtabfooter |
Newtabfooter |
Newtabfooter |
Newtabfooter |
Newtabfooter |
| |||||||||||||||||||||||||||||||||||||||||||||
Newtabfooter | ||||||||||||||||||||||||||||||||||||||||||||||||||||
|