I am looking for a system stat collection tool that will let me write queries against the data collected. I am planning to answer questions like:
- what is the average load, over the last 30 days, on this machine between 9AM and 5PM, as opposed to at night
- what was the average disk io on these 10 machines yesterday
- what was the average daytime memory usage on these 10 machines last week, as opposed to 2 weeks ago
Has anyone done this with, say, collectd or graphite?