I have a very simple SCADA system with Mango 2.7.10:
-360 data sources in two groups of 180.
-One group has 72 data points per source that update once every 5 minutes.
-The other has 327 data points per source that update once every 24h.
-There is 1 virtual source with 1620 virtual points.
-There is 1 meta source with ~182 meta points
-180 meta points use a simple script that compares certain data point values and returns 0, 1, 2, 3 or 4.
-1 meta point uses a simple script that adds 180 data point values together and divides them by 180 to find the average.
-1 meta point uses a simple script that adds certain data point values together.
-There are 180 hierarchy folders.
-There are ~180 watch lists.
-There are no events and no alarms.
-Server with Mango installed has no other application than Mango
Now, this has all worked well until recently when I added a further 120 data sources with their respective data points, hierarchy folders and watch lists, to make the current total of 360 data sources. After adding this, I've experienced Server Timeouts, but only on data sources page. I am able to check every other page as much as I want, but when I open the data sources page, it starts loading data sources into the list, but stops with the last data point before the timeout being always the same one. It does manage to load them all after some, long, time, but usually it never does and Mango needs to be restarted. If it does manage to load all the sources, it may also go into timeout while waiting to open the edit page for some source. As with the previous case, it can also manage to load it after some long time, but usually it never does and Mango needs to be restarted. I am using the embedded H2 database that has 8.8GB. When Mango goes into timeout, Memory is only 27% used, but all 8 CPU cores go into ~100% usage.
I have all the licences,
Are there too much data points now ~75 000, or too much data sources~180? Is the database too large, if so how large it should be at max? Why is Mango going into timeout like this?
Regards, Stefan Radunovic