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

Chart Values Inaccurate

forums forums Monyog Using Monyog Chart Values Inaccurate

Tagged: ,

  • This topic is empty.
Viewing 7 reply threads
  • Author
    Posts
    • #13330
      ggreen
      Member

      For a while I’ve been having a problem with the values for charts being inaccurate, I have just upgrade to the latest version and the problem persists.

      The screenshot below shows there are thousands of connections to my database servers with millions of statements per second.

      [attachment=2020:monyog.png]

      The reality is much different, about 20-40 connections on each server with each doing between 6k and 12k queries per second

      [attachment=2021:innotop.png]

       

      Why is Monyog reporting such vastly different numbers and how can I fix it or is it a bug?

    • #35231
      peterlaursen
      Participant

      MONyog executes “SHOW GLOBAL STATUS” and retrieves the information from the server using this statement. Can you please try to execute the same? It may of course be a calculation/database error in MONyog but it can also be a server bug. What is the server version?

    • #35232
      ggreen
      Member

      Server version: 5.5.33a-MariaDB-log MariaDB Server

       

      Here is the info regarding connections;

       

      MariaDB [(none)]> show global status like ‘connections’;

      +


      +


      +

      | Variable_name | Value     |

      +


      +


      +

      | Connections   | 655600285 |

      +


      +


      +

      1 row in set (0.00 sec)

       

      MariaDB [(none)]> show global status like ‘connections’;

      +


      +


      +

      | Variable_name | Value     |

      +


      +


      +

      | Connections   | 655600322 |

      +


      +


      +

      1 row in set (0.00 sec)

       

      These were taken about a second apart, the difference between the 2 = 37

      According to monyog there are close to 4,500 connections

       

      Here are the queries:

      +


      +


      +

      | Variable_name | Value        |

      +


      +


      +

      | Queries       | 335655404406 |

      +


      +


      +

      1 row in set (0.00 sec)

       

      MariaDB [(none)]> show global status like ‘quer%’;

      +


      +


      +

      | Variable_name | Value        |

      +


      +


      +

      | Queries       | 335655440037 |

      +


      +


      +

       

      Difference 35,631

      According to monyog there are close to 3 million

    • #35233
      ggreen
      Member

      Something new to add;

      Chrome on Windows shows the values in the screenshot of the first post. Chrome on my Linux box shows correct values.

      Firefox on Windows and Linux shows the high values.

      I tried from IE and I get the same crazy high values even though I’ve never accessed Monyog with IE before.

       

    • #35234
      siddhant
      Member

      Hi,

       

      Can you please tell us on which OS have you installed MONyog. Also, send us the mysql.data file of the problematic server by writing back to us on support@webyog.com. To identify the directory associated with the server, hover the mouser over the server name and you’ll notice the directory number like 0001. Now depending on the OS and the mode of installation, navigate to the data directory inside MONyog directory and send us the mysql.data file inside the directory number corresponding to the server.

       

      Windows:

      ProgramDataWebyogMONyogdata

       

      Linux:

       

      tar: /MONyog/data/

      rpm: /usr/local/MONyog/data/

    • #35235
      peterlaursen
      Participant

      We will check.

    • #35236
      ggreen
      Member

      Monyog is running on CentOS 6.5

      It isn’t just one server with the problem, all servers have the problem. Since it looks correct with Chrome on Linux it seems to me that is a problem on the client side rather than server side.

    • #35237
      siddhant
      Member

      Hi,

       

      We are unable to reproduce the issue i.e. the chart values are consistent on both windows and linux platform browser’s. Can you please write back to us at support@webyog.com and send us the mysql.data file of any of the server showing problematic behavior.

Viewing 7 reply threads
  • You must be logged in to reply to this topic.