What is the best offload interval for data offload of the alarms to a MySQL DB? the default is 5 minutes, however, we can do much faster or much slower.
For the case of 5 minutes interval, would the system take the difference at every 5 minutes boundary, or it offloads retrospectively every transaction recorded at any time for the past 5 minutes?
The goal is to ensure that no alarm is missed, even if the duration is only 1 second before it clears.
Hi Elvio,
i assume we are talking about a MySQL Central Database? As described here?
Offload database | DataMiner Docs
We will indeed push all data into the database unrelated to the time you push the data
You can find more details here:
How DataMiner offloads data | DataMiner Docs
As a summary, we push all alarms into a csv file and then make an insert query on the central database, this happens every 5 min
If we are not talking about large volumes (<3k alarms / hour) i would recommend to keep the standard settings enabled
I’ve checked with the data core team for this, and they said it depends on whether performance is sufficient as it is. If you notice that offload files are becoming too large or cumbersome, it’s a good idea to reduce the offload rate, but otherwise this is not necessary.
In some cases we have thousands of alarms in 5 minutes, on that case, would it be better reducing the rate to 1 minute?