Chart Values Inaccurate

[ggreen]

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?

[peterlaursen]

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?

[ggreen]

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

[ggreen]

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.

 

[siddhant]

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 [email protected]. 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/

[peterlaursen]

We will check.

[ggreen]

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.

[siddhant]

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 [email protected] and send us the mysql.data file of any of the server showing problematic behavior.

[Author]

Posts