Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Add New Monitor/advisor > Table Size In Mb Has Reached Threshold

forums forums Monyog Monyog customisation Add New Monitor/advisor > Table Size In Mb Has Reached Threshold

This topic contains 4 replies, has 0 voices, and was last updated by  Sayan Chaliha 9 years, 4 months ago.

  • Author
    Posts
  • #11990

    webwilliam
    Member

    I'm a licensed user and am currently using MONyog Ultimate 4.0 Beta 1 on a Windows 2008 server. I have read the documentation, but am still have issues adding a new Monitor/Advisor. It's not that I am getting any errors per say, but am having trouble trying to create a new Monitor/Advisor that will check the physical file size of a table in MB. If the size of a certain table has reached a threshold of 100 MB, then I would like to get an email alert.

    I am familiar with JavaScript syntax, but unfamiliar with MONyog Object Model (MOM).

    Can somebody please tell me what values I can enter to create this new Monitor/Advisor?

    Thanks!

  • #30916

    Hi William,

    Firstly, here's a quick little tutorial on the MySQL bit of the MOM:

    — MONyog executes SHOW GLOBAL STATUS and SHOW GLOBAL VARIABLES on MySQL

    — For each of the variable/status returned by MySQL, a Javascript object is created in the MOM

    — So basically you have:

    Code:
    MONyog.MySQL.GlobalVariables.
    MONyog.MySQL.GlobalStatus.

    I don't think there are any global variables/status that keep track of individual table sizes. The 'Disk Info' component is completely separated from 'Monitors/Advisors' and they don't share any information. Maybe we could build a feature which allows you to set alerts for databases/tables in 'Disk Info'. Sound like a good idea?

  • #30917

    peterlaursen
    Participant

    One problem is that the 'table size'  (size of data + indexes) and the 'table size on disk' is not necessarily the same. There may be unused space inside the tablespace (details depends on storage engine).  MySQL data folder may be mounted to another disk system than the system disk (like a RAID system/rack) and even the InnoDB tablespace may be stored a 3rd. place.  You will find other discussions like this here (one user requested an 'alert when a table is full'). 

    It is actually very difficult to provide meaningful alerts. It will also result in one more background thread running (more CPU-load, more I/O).

    So it is important to understand WHY you want this, WHAT you want to achieve and WHAT EXACTLY should be the alert condition.

  • #30918

    webwilliam
    Member

    Thanks for taking the time to reply. I do think it would be a great idea to build a feature which allows you to set alerts for databases/tables in 'Disk Info'. Even better, it include the indexes as well.

    I do understand that there is unused space within a database, but by the time the database size has reached the threshold, I would like to be alerted so I can run some purge scripts.

    Since MONyog 4.0 is in Beta, is it possible to include this in the next deploy 4.1?

  • #30919

    Hey William,

    I'll have get back to you on that one; will have to discuss this with the rest of team as well. I'll keep you updated on that.

  • #30920

    Hi William,

    We've put your request for a feature on our wish-list. You'll definitely see it in one of the future versions of MONyog; I'll keep you updated on that as well!

You must be logged in to reply to this topic.