Q: how many statistics entries per day does your project validation report?

[Rob_in]

Hi all,

I have been discussing the ongoing SD Card usage warning message with Loxone suport. They are convinced there is nothing wrong with Loxone Config or the firmware and it's all my fault for actually trying to record too many statistics.

This is despite the fact our Miniserver was running for months without giving an SD card usage warning and that only appeared after a particular update of Loxone Config!

Anyhow, just to confirm who is correct I'd like to ask how many statistics entries is everyone else seeing in their project validation? Could you please check and post a reply here with the numbers.

Generally the 'Project Validation' function is run when you open your projects, but if not, it's on the menu bar when you have the 'My Project' top tab selected. You may have to scroll down a lot to find the statistics number depending on how clean your config is.

For example, my project reports 3312 statistics per day for Program Objects and 14760 statistics per day for Peripherals Objects.

Thanks in advance for your help.

Robin

[Rob Lynes]

1176 statistics program objects

312 statistics - peripheral objects

I used to have more, but decided to clear down quite a lot of the logging as after a while it didnt make any sense keeping that many.

Rob

[Rob_in]

Hi,

Thanks for sharing. And can I also ask: do you see the 'High Write Load Detected' message:

Just that Loxone support have told me if those statistics numbers add up to more than 350 writes per day then the above warning is triggered.

Thanks,

Robin

[Rob]

I switched on a whole raft of stats for my heating config yesterday and received the SD card warning this morning.

My numbers are:

3168 stats for program objects

55 stats for peripheral objects

Is there a prize for the person with the highest stats numbers before they fry their SD card.............!!!!!!!

[Rob_in]

On Thursday, 23 January 2020 18:15:21 UTC+1, Rob wrote:

Is there a prize for the person with the highest stats numbers before they fry their SD card.............!!!!!!!

Think you win a bricked Miniserver! ;)

TBH, this SD card warning is a joke, here's what I said to Loxone about it...

 

You are telling me that Loxone recommends 350 writes per day but so let's put that into context:
- There are Micro SD cards available that are marketed specifically for longevity. Mostly they propose use in home surveillance cameras.
- A very quick search finds products from Kingston, Sandisk, etc. with a lifetime write durability of 20,000 hours of FHD video.
- 1 hour of FHD video is around 1.5GB. 20,000 hours would be 30,000GB.
- So there are Micro SD cards available that are designed to have a write durability of 30,000GB.
- We have just under 2 years of statistics archived from our Miniserver. The total storage is 154MB. 1 year would be 77MB.
- Looking at just December 2019 our stats total 5.21MB, so at that rate 1 year would be 65MB.
- Taking the larger of the above 2 numbers (77MB/year), this would take almost 400,000 years to reach the 30,000GB write durability of the type of Micro SD card designed for high durability video surveillance.
Four hundred thousand years!
- OK, let's imagine the Miniserver has a very poor write efficiency and writes the entire statistics file every 5 minutes (which is a large over-estimation of what should be happening, but still...). That would mean 5.21MB written 8928 times per month. 12 (every 5 minutes is 12 times an hour) x 24 x 31 = 8928 times (not every month has 31 days of course - worst case).
- 5.21MB x 8928 = 46.5GB per month.
- This would be ridiculously inefficient but would still take over 50 years to reach the durability level discussed.
Now do you see my frustration? I can handle replacing the SD Card every 50 years or so - not a problem! 

Awaiting their response ;)

Cheers,

Robin

[Deac99]

I have 3092/day Program Objects and 

5400 /day periphery Objects

I know this is slightly overboard but I recently installed a solar array and I have 5 separate power meters that I'm monitoring energy usage along with what we are putting into the grid etc. etc. etc. trying to optimize the energy distribution so we don't put much into the grid.

I'm polling avg KW usage every minute on all power meters to try to understand how best to optimize.  I would expect that these will be drastically reduced once i get a handle on what is going on and how to optimize.

I have not got warning messages but i don't have that set up - the project validation shows the red triangles with the ! for warnings however.  So far so good but it does make me nervous now that you bring all this up.

[Otto-Mate]

I hope to monitor energy meters too, is there a way to send values to a Google Spreadsheet or something that doesn't involve writes to the card?

[Rob_in]

Hi,

Slightly OT, but we have a Legrand Ecocompteur:

https://www.legrand.com/ecatalogue/412000-measurement-concentrator-emdx-6-modules.html

They can be had for around 110EUR and the current transformers are under 10 each. Can monitor 5 circuits and has an IP interface which can be hit every second if you want (I notice it's web interface does just that - updating the display every second).

Anyhow, so with one of these units you can monitor numerous circuits split over the 5 inputs and could easily create a script to dump readings anywhere you like without going anywhere near your Miniserver if you wanted.

... and to answer your point about avoiding writes to the Miniserver's SD Card: Yes, you setup a logger to send the values someplace else on your LAN. I have a UDP logger that sends values to an InfluxDB server directly from Loxone for example. Well - it has to go though a tiny proxy script to strip the date/time off the front of the message that Loxone annoyingly adds but that is trivial (I have an outstanding ticket with Loxone to remove that timestamp or make it optional). The reason I want Loxone stats is to look at short term values in the app and as backup in case the InfluxDB goes offline or something so hopefully won't ever get gaps in the data, all our long term analysis is done in Grafana from this InfluxDB data.

HTH,

Robin

[Jan De Bock]

Hi Otto,

have a look to topic Loxone + InfluxDB + Grafana is nice :
In one of the updates I gave an example how you can use UDP to send stats to somewhere else, in this case influx database, which you can easily visualize with grafana.

Note: Currently I am moving to PostgreSQL as this gives me some more flexibility in queries, but principles are the same.

Best regards,

Jan