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:

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.

function()
{
    if(ToInt(MONyog.MySQL.GlobalStatus.Select_scan) > 1000)
        return GetWarnStatusInt(this.Value, this.Critical, this.Warning, true);
    else
        return "None";
}

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 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 found
• MONyog.MySQL.InnodbStatus.Last_detected_time: Period in which last deadlock is detected
• MONyog.MySQL.InnodbStatus.Latest_deadlock: Latest deadlock is detected