Add time series DB support for lvestats
The lvestats could have support for modern time based db storage backend. Such DB is great foundation for analytic tools. Examples:
InfluxDB + Grafana http://influxdb.com/
Elasticsearch + Kibana https://www.elastic.co/products/kibana
Properly structured time series data would work faster than MySQL or PgSQL backends. Especially when you have hundreds of users per server and millions of rows in resource usage tables. With time based db there is also less headache for maintaining continuously growing 'history' and 'history_gov' tables.
-
Igor Seletskiy commented
We tried InfluxDB -> it would just crumble under the amount of data single server generates. You would basically need a dedicated influxdb server per shared hosting server. We tried several others as well.
They don't work faster then MySQL/PgSQL for what we need. We spend about 3 months trying to adopt them before we gave up.
Also, same db that takes 2GB in sqlite took about 30GB in influxdb. We tried multiple engines, optimizations, performance recommendations, etc...
We might try again in another 9-12 months - but so far, none of them have low enough footprint for us to be able to use it.