Please enter a valid email address. The download links will be emailed to you.
The download links for
MONyog have been sent to
Back to Topics

New CSOs and CSCs

What makes a CSO?

Choose Manage CSO from the drop-down. This opens up a form with the following details

  • SQL: Any user defined SQL which returns a result set.
  • Data Collection Interval: Interval in which this SQL is queried periodically. We recommend 5 mins which also happens to be the default value.
  • Server(s): Comma separated names of the servers for which this SQL needs to be queried every Collection Interval.
  • Purging Interval: The data retention time & we recommend 7 days.

  • Key Columns: CSOs work with a result set which has unique rows. A combination of 1 or more columns of the result set can be made as a key column as long as long as this key column identifies a unique row in the result set.

image

Making its CSC:

We create a CSC like any other monitor. Go to monitors page and select ' Add new monitor' from the drop-down

  • Choose the type of counter as Custom SQL.
  • Type in the name of the group to which this counter is being added.
  • Enter the name of the counter being added.
  • Formula: A MySQL server parameter that would be needed to compute the value of this counter.
  • Value: This defines a function that computes the value. Here is a template
function() {
   var sqlObject = MONyog.UserObject('<Name of your Custom SQL Object>');
   if (!sqlObject || !sqlObject.isEnabled() || !MONyog.MySQL.Custom.Available)
      return '(n/a)';
   /* You will have to call select here to fetch the resultset. */
   var resultSet = sqlObject.select();
   var results = ''; /* results holds the resultset in the form of array of row(s).*/
   /*Get column(s) for each row from the result set */
   for (i in resultSet) {
      if (resultSet.length > 0)
         results += '<br>';
      results += resultSet[i].<Column name in resultset> +
         '.' + resultSet[i].<Column name in resultset>;
      }
   if (results.length == 0)
         results = 'None';
   return results;
}
  • Description: Description of Monitor/Advisor.
  • Advice Text: Advise text to the Monitor/Advisor being added.