I know there are a lot of threads discussing the different persistence engines with its respective (dis)advantages and especially the combination of influxdb with Grafana. This is also my setup up to now.
But I’m wondering if somebody made a performance comparison between influxdb and mysql?
So, to be more precise, imagine the following scenario:
- SOC hardware running openhab2 and persistence engine (quite common rPi with openHABian)
- both database engines are persisting with the exact some strategy = identical *.persist files
- Grafana not included
And know the question:
- Which of both DB engines uses more resources (CPU, RAM)?
- Which of both DB engines uses more space to store the data?
And in addition: Is there a performance difference between native mysql and JDBC persistence service?
Any experience regarding performance of the 2 DB’s is appreciated