We have emoncms (10.8.8) installed on our server (Debian Buster) and we love this software, thank you for your work! We use 20 IoTaWatts (“IW”), connected to emoncms. Unfortunately, the server load is super high when IW are connected, making the server unusable for the other services installed.
As you can see on the screenshot above, the database (MariaDB) is the problem. When I stop the emoncms server (just by renaming the emoncms folder into emoncms2, so that Apache cannot find it anymore), the load goes back to normal (around 0.5) while other services are still running (notably Nextcloud). This is why I’m sure that the load issue is related to emoncms.
It is not confirmed yet, but we have the feeling that the load is higher when several IWs are uploading data which was not uploaded yet (for example after an interruption of the internet connection of the IW).
Would you have an advice to solve this?
Thanks in advance!