To have some statistical data, we could try out munin on o3.
It gathers data every 5 minutes and writes them in rrd format, and generates a daily, werkly, monthly and yearly graph for things like load, memory, disk usage, apache accesses, network traffic.
- Install munin and configure
- Create restricted access over http for the team, since we don't want that data to be public
Installed on o3:
# install % zypper in munin munin-node # config % cd /etc/munin % vim munin.conf # configure hostname (e.g. openqa.opensuse.org) # enable plugins % cd /etc/munin/plugins % for i in /usr/lib/munin/plugins/apache_*; do ln -s $i; done % systemctl restart munin-node.service
HTML files are under
/srv/www/htdocs/munin/ and not accessible from the webserver yet.
Apache would need the status module enabled for the apache_ plugins to work.
We also could enable some postgres plugins.
Downloaded https://gallery.munin-monitoring.org/plugins/munin-contrib/postgres_queries3_/ plugin and put in
We can now see the number of selects, inserts, updates and deletes (under the "db" category).
- Status changed from In Progress to Resolved
- Enable apache status module to be able to collect statistics about apache requests/processes
- Make the generated HTML files available over the webserver, but only for "us", not for the public. Need to figure out how that can be set up in apache
These things are considered out of scope, so resolving this ticket
ok. If you like you can add the instruction to the wiki on https://progress.opensuse.org/projects/openqav3/wiki/#Infrastructure-setup-for-o3-openqaopensuseorg-and-osd-openqasusede