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

Tables Metric_Master And Snapshot_Master

forums › forums › Monyog › Using Monyog › Tables Metric_Master And Snapshot_Master

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • February 20, 2013 at 3:12 pm #12931
      mtrekker
      Member

      I have a concern regarding some of the status variables that are being logged into table “snapshot_master”.

      Variable “Innodb_log_waits” has a very low rate of occurrence. Usually there are thousands of other “Innodb*” variables in snapshot_master.

      Can somebody share the light ? I am using MONyog 4.71.

    • February 21, 2013 at 5:03 am #34205
      Mahesh
      Member

      This is because value of 'innodb_log_waits' most of the time remains to '0' and We do not always INSERT into [snapshot_master]. Only if the particular metric was changed since last time something was INSERTED for that metric we will INSERT again. So if you want to find the value of a metric at some particular time you will need to find the most recent value stored before that particular time for that particular metric.

      MySQL documentation says `Innodb_log_waits` – The number of times that the log buffer was too small and a wait was required for it to be flushed before continuing.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.