Performance is depend on the computer spec also. Can you describe the vps data.
There is a variable named CLEAN_PERIOD, its one day, it used to clean the history, you can reduce it and give a try.
Ok, 16G mem and 4 core, 20Gb drive for server on Ubuntu 18.04 and 50Gb drive for mariaDB
What memory settings for java heap and innodb is optimal?
We have increased the connection limit and the scaling described by the documentation / optimization
Hi
How old and how much data is kept in server memory? Have big problems with server after 6-8h run, it starting to lag and stops to respond. Restart fix for 5-10miutes then same problem. Is like a buffer gets full. 100 units at 1Hz and 10-20 viewers