It looks like you may be running emoncms with redis disabled. Redis improves the performance of emoncms quite a bit and is really worth getting running if you can. It caches a lot of the emoncms input and feed meta data and reduces the disk reads and writes considerably.
That query is used in input_model.php getlist() and triggered from host/input/list.json API that is polling each 5secs when the inputs screen is open.
I would not worry as Trystan said the Redis cache mitigates that.
It that hardware a raspberypi?
Thanks @TrystanLea and @nchaveiro
FYI: the hardware is Virtual Server with 6 CPU, 16MB memory and 320GB HDD
We have in excess of 9500 feeds and are storing the data in MYSQL
We do not have Redis enabled as yet
as you can see from the graph, the issue we are experiencing is high CPU,
I can’t tell if the disk I/O is particularly high
Is it possible to implement redis while the controllers are sending data?
That’s the kind of thing I used to see on emoncms.org. Redis does really help a lot.
Are you using virtual feeds? how much data access do you have on your server? is it just accessed by an administrator or are you providing a lot of dashboards etc to users?