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

Improving Performance Of Monyog Itself

forums › forums › Monyog › Using Monyog › Improving Performance Of Monyog Itself

Tagged: 

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • December 19, 2012 at 3:09 pm #12888
      dvanhollen
      Participant

      Our production MONyog instance monitors two MySQL servers and their Linux hosts. We are having problems getting short-term historical data summaries in a timely manner, which impacts our forensics of critical events.

      Our current configuration is: 5 second collection interval, 32 day data retention timeframe. Our typical mysql.data size is 2G, system.data 422M.

      Under this configuration it takes about 25 minutes to generate the “history details” of a 15 minute period of history, which is about 180 data points. This is after rebuilding the database (it was worse before).

      What is the best way to improve the retrieval speed of historical data? Reduce the data retention timeframe? Increase the collection interval? Disable as many monitors as we can?

      We're running MONyog 5.52 N4 on a 12 CPU, 50G Linux host, which runs other applications, but still shows 80% idle, 4G RAM free, less than 1% i/o wait. Is there a way to tell MONyog it can use more system resources?

    • December 20, 2012 at 4:09 am #34063
      Mahesh
      Member
      Quote:
      What is the best way to improve the retrieval speed of historical data? Reduce the data retention timeframe? Increase the collection interval? Disable as many monitors as we can

      –> There is an option you can either view History report grouped by “Minutes”, “Hours”, “Weeks” etc .. you can choose as per your requirement.You have given 32 days as data retention timeframe, if you think you want to get historical data for a month you can keep it otherwise change it (default is 7 days). Also as you have mentioned data collection as 5 seconds, MONyog will work for such a small interval but it's recommended to use data collection interval as 5 minutes (5 minutes is default collection interval)

      If you can share “mysql.data” and “system.data” with us it will be better also it does not contain any authentication details about your server.

      You can create a support ticket by sending an email to [email protected] , I will share our FTP server details there for privacy concern.

      Quote:
      Is there a way to tell MONyog it can use more system resources?

      –> MONyog configuration does not have any limit on use of system resources, it's dependant on OS.

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