View total number of metrics/minute the Controller is collecting

[Jon.Faldmo]

The controller system requirements, specifically the "Controller Performance Profile Definitions"that should be used are based off of the "Maximum Metric Count/Minute." How do you view or calculate that in an existing installation?

[Atyuha.Pal · Accepted solution]

Hi Jonathan,

Please refer to the below link to get the detail

https://vimeo.com/109489219

Also you can run the below query to determine how many metrics inserted per minute in controller DB.

mysql> select from_unixtime(ts_min*60), NOW(), count(distinct(node_id)), count(*) from metricdata_min where ts_min > (select max(ts_min) - 10 from metricdata_min) group by 1 order by 1;

[Tim.Ellsworth]

Is it possable to get the total number of metrics/minute the Controller is collecting per application ?

[Jon.Faldmo]

This query will give the you start time used in the query, the end time, application name, number of nodes per application, and number of metrics per application.

SELECT from_unixtime(ts_min*60), NOW(), a.name AS application_name, count(distinct(mm.node_id)), count(*) FROM metricdata_min AS mm, application AS a 

WHERE ts_min > (SELECT max(ts_min) - 2 FROM  metricdata_min) AND ts_min < (SELECT max(ts_min) FROM metricdata_min) AND a.id = mm.application_id GROUP BY application_name, 1 ORDER BY 1;

[Tim.Ellsworth]

Great thanks looks good. Will have to run when we have load.

[Imran.Ali]

Is it possible to get metrics per minute by tenant on the Controller?

[ICG.AppD Leads]

Hello,

Where do I run these SQL queries? Do I have to actually log on COntroller's DB or can I run it from somewhere on UI? And do I need a certain permission?

Thanks!