We have emoncms (10.8.8) installed on our server (Debian Buster). 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 that was not uploaded yet (for example after an interruption of the internet connection of the IW).
I don’t know if it’s related to IotaWatt or to emoncms itself. Would you have any advice to solve this?
Thanks in advance!
Here is a few more information about our config:
Debian 10 (buster) Server version: Apache/2.4.38 (Debian) PHP 8.0.11 (cli) (built: Sep 23 2021 22:03:11) ( NTS ) mariadb Ver 15.1 Distrib 10.3.29-MariaDB CPU: AMD E350D x86_64 (2 cores)