munin plugin to monitor visit interval distribution
It will be nice to monitor the adaptive intervals of visits for all our origins.
The visits sorted by intervals are returned by the following query (on the softwareheritage-scheduler DB), see migrated/migration$57:
select current_interval, count(*)
from task
group by current_interval
order by current_interval;
softwareheritage-scheduler=> select current_interval, count(*) from task group by current_interval order by current_interval;
current_interval | count
------------------+---------
12:00:00 | 961
1 day | 51374
2 days | 61265
4 days | 527019
8 days | 8575817
16 days | 3228828
32 days | 1879803
and a sample munin plugin that can be used as template is at prado:/usr/local/bin/softwareheritage_objects_ (hat tip to @olasd).
Info on how to add the plugin when ready (from an IRC conversation):
(16:49:35) olasd: the trailing underscore means it's a "template" plugin
(16:49:42) olasd: so you can have several instances of it
(16:49:54) olasd: e.g. when you want to be able to monitor several databases
(16:50:26) olasd: to add the plugin to munin, you add a /etc/munin/plugins/foo_<dbname> link to /usr/local/bin/foo_
(16:50:35) olasd: and restart munin-node
(16:51:28) olasd: (stock munin plugins are in /usr/share/munin/plugins but I didn't really want to do /usr/local/share/munin/plugins, although that'd probably be clearer)
Migrated from T361 (view on Phabricator)