Whats happened to the device_perf table?

I am not an expert in everything how it works in librenms but I notice that the device_perf table in the librenms database has disappeared.

Where can I get the Ping results that are charted? I was using that data extensively to monitor multiple systems.

It was removed in the latest update. Latency is now being monitored via RRD.

Thanks for that.

I used to read the device_perf tables using a MariaDB GUI and used database joins with the other Libre device tables to create information rich reports and deep analysis of various performance issues on our network terminals. It was very powerful and useful.

Are you able to advise the best way I can achieve the same functionality using RRD?

Hey @PeterM, sorry to hear that. The device_perf table was removed because it was consistently breaking user’s installs with data that should have been in time series (RRD) storage in the first place.

We don’t know what kind of analysis you are doing, so my advice will be very generic.

You can fetch data from rrd files directly with rrdtool. RRDtool - RRDtool Documentation

You can also have LibreNMS push data to something like InfluxDB, which is much better suited to add nice analysis on top of. InfluxDBv2 - LibreNMS Docs

Thanks for the response I will take a look at the RRDTool.

Can you please check how your new latency charts are working. I notice that the scale on the right hand side Y axis that presents % Loss follows the scale on the left hand y-axis and it is giving the wrong presentation of % Loss results. You should set it up so that % loss is a fixed Y-Axis from 0 to 100%. Take a look at this example, you can not have 1800% Loss rate.

image

I don’t know how to stop the loss axis at 100%. As you can see, you have 0% loss for this whole graph.

Any fixes are welcome.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.