Posts

Showing posts with the label grafana

How to get top 10 growing objects in grafana being graphite as backend

How to get top 10 growing objects in grafana being graphite as backend I am using graphite and grafana. My data is as follows db schema tablename bytes db1 schema1 table1 1234434 db1 schema1 table2 3409853 db1 schema1 table3 4645654 . . .. db1 schema2 table1 2343454 db1 schema2 table2 3242323 db1 schema2 table3 3433455 . . . Per schema i want to get the top 10 growing objects (i mean tables). I mean in schema1 i want to get top 10 growing objects/tables. In schema2 i want to get top 10 growing objects/tables. I have several schemas in a database. How can i acheive this? Please help By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Time-series charts for large amounts of data

Image
Time-series charts for large amounts of data I have a couple of thousand time-series covering several years at second-granularity. I'd like to store the data in a suitable DB (i.e. one that scales well and can retain all data at original granularity, e.g. Druid, openTSDB or similar). The goal is to be able to view the data in a browser (e.g. by entering a time frame and ideally having zoom/pan functionality). To limit the number of datapoints that my webserver needs to handle I'd like to have functionality which seems to be working out of the box for Graphite/Grafana (which, if I understand correctly, is not a good choice for long-term retention of data): a time-series chart in Grafana will limit data by querying aggregations from graphite (e.g. return mean value over 30m buckets when zooming out while showing all data when zooming in). Now the questions: Feedback on the choice of DB is also welcome (open-source preferred). 2 Answers ...