Difference between revisions of "Project:LHS Graphs and Visualizations"
m (→Metrics: Babbage deprecation) |
|||
(47 intermediate revisions by 8 users not shown) | |||
Line 1: | Line 1: | ||
{{Project|members=[[User:Teabot|Elliot]]}} | {{Project|members=[[User:Teabot|Elliot]]}} | ||
− | + | ==Overview== | |
− | I | + | I have supplemented [http://hack.rs/cacti/graph_view.php?action=tree&tree_id=1 the Cacti graphs] that we have for LHS bandwidth and power with [http://hack.rs/cacti/graph_view.php?action=tree&tree_id=5 metrics] that provide insight to the growth of our community and organisation over time. |
− | + | To chart the metrics various bits of data are exposed in a Cacti friendly way. | |
− | |||
− | |||
− | + | ==Metrics== | |
− | + | ===Number of members=== | |
− | |||
− | |||
− | + | We may have to wait 12 months before it becomes interesting. | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
This data is stored in an Sqlite database on [[Turing]]. See the [https://github.com/londonhackspace/hackspace-foundation-sites/blob/master/etc/schema.sql Schema]. It can be queried like so: | This data is stored in an Sqlite database on [[Turing]]. See the [https://github.com/londonhackspace/hackspace-foundation-sites/blob/master/etc/schema.sql Schema]. It can be queried like so: | ||
Line 41: | Line 16: | ||
WHERE subscribed = true; | WHERE subscribed = true; | ||
− | Cacti runs on | + | Cacti runs on chomsky but the members database is on Turing. There is a PHP script on Turing to expose the member numbers and then a script on chomsky to pull this in with a HTTP request. |
− | |||
− | |||
− | + | ''Code:'' https://github.com/londonhackspace/monitoring | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | + | ''URL:'' http://london.hackspace.org.uk/member_stats.php | |
− | + | ===IRC statistics=== | |
− | + | ''See project: [[Project:Ircensus|ircensus]]'' | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | == | ||
− | '' | ||
+ | ===Wiki statistics=== | ||
* We get this using the MediaWiki API: | * We get this using the MediaWiki API: | ||
Line 94: | Line 49: | ||
</api> | </api> | ||
− | |||
− | + | A Perl script generates the following output for cacti: '''<tt>pages:759 articles:215 views:229656 edits:7368 images:186 users:166 activeusers:22 admins:61 jobs:13</tt>''' | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | + | ''Code:'' https://github.com/londonhackspace/monitoring | |
− | + | ===Mailing list activity=== | |
* My thanks to JamesG for his assistance and '78.86.160.161' for the original idea. We poll and scrape the groups page for members and and message count. | * My thanks to JamesG for his assistance and '78.86.160.161' for the original idea. We poll and scrape the groups page for members and and message count. | ||
Line 129: | Line 60: | ||
http://groups.google.com/group/london-hack-space | http://groups.google.com/group/london-hack-space | ||
− | + | We have a script that outputs: '''<tt>members:693 messages:3123</tt>''' | |
− | + | ||
− | + | ''Code:'' https://github.com/londonhackspace/monitoring | |
− | + | ||
− | + | ===Space occupancy=== | |
− | + | ''See project: [[Project:Spacensus|spacensus]]'' | |
− | + | ||
− | + | [[Category:Projects]] | |
− | + | [[Category:Infrastructure]] | |
− | + | [[Category:Space_Infrastructure_Projects]] | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− |
Latest revision as of 11:52, 5 January 2016
LHS Graphs and Visualizations
| |
---|---|
Members | Elliot |
QR code |
Overview
I have supplemented the Cacti graphs that we have for LHS bandwidth and power with metrics that provide insight to the growth of our community and organisation over time.
To chart the metrics various bits of data are exposed in a Cacti friendly way.
Metrics
Number of members
We may have to wait 12 months before it becomes interesting.
This data is stored in an Sqlite database on Turing. See the Schema. It can be queried like so:
SELECT COUNT(id) FROM users WHERE subscribed = true;
Cacti runs on chomsky but the members database is on Turing. There is a PHP script on Turing to expose the member numbers and then a script on chomsky to pull this in with a HTTP request.
Code: https://github.com/londonhackspace/monitoring
URL: http://london.hackspace.org.uk/member_stats.php
IRC statistics
See project: ircensus
Wiki statistics
- We get this using the MediaWiki API:
http://wiki.hackspace.org.uk/w/api.php?action=query&meta=siteinfo&siprop=statistics&format=xml
It returns:
<?xml version="1.0"?> <api> <query> <statistics pages="759" articles="215" views="229656" edits="7368" images="186" users="166" activeusers="22" admins="61" jobs="13" /> </query> </api>
A Perl script generates the following output for cacti: pages:759 articles:215 views:229656 edits:7368 images:186 users:166 activeusers:22 admins:61 jobs:13
Code: https://github.com/londonhackspace/monitoring
Mailing list activity
- My thanks to JamesG for his assistance and '78.86.160.161' for the original idea. We poll and scrape the groups page for members and and message count.
http://groups.google.com/group/london-hack-space
We have a script that outputs: members:693 messages:3123
Code: https://github.com/londonhackspace/monitoring
Space occupancy
See project: spacensus