Hello, Joel. This is Marc working with Mebius.
We have acknowladged all alarms and then deleted all from EVENTS table using the SQL statement.
Unluckily it didn't work much. Maybe our trouble comes elsewhere.
We did find something. As you and your colleague Phil know, we are using combinations of scripting data source, serial test data source and meta data source to send and receive messages through serial ports.
There are more than 20 combinations of these data sources in our mango system now.
- When these 20+ combinations are disabled, other 100+ data sources and publishers can work at a normal speed.
- When these 20+ combinations are enabled, with periods of 20 seconds on scripting data sources, the whole mango system slow down. All 120+ data sources updates slowly. And all publishers become slower and slower until they stop to publish any data.
- After we change the periods to 5 mins on scripting data sources, the publishers can work normally, but data sources are still slow. We got stuck when opening the "datasources.shtm" page, several minutes after enabling them.
We need a way that provides both shorter periods and normal speed updates.
Also we see a very high memory usage of mango, up to 1.4G. Is that because the total number of data sources, or something else?
I see you have a lot of unacknowledged events. I would recommend purging your events table and see if that speeds things up. I seem to be sharing this thread a lot lately:
If you can use the SQL statement to delete everything in the events table. Go through your settings and turn things to Do Not Log that you don't need to minimize the number of events that are being created.
Let me know if that helps,