Changes between Version 2 and Version 3 of BatchStats
- Timestamp:
- Sep 8, 2010 6:07:56 PM (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
BatchStats
v2 v3 1 Recent activity for non-class projects: 1 All these stats ignore class projects which are currently banned from creating batch experiments. 2 3 Recent activity: 2 4 {{{ 3 5 mysql> … … 24 26 All batch, by project: 25 27 {{{ 26 mysql> select pid, count(*) from experiment_stats where batch 27 group by pid order by count(*) desc; 28 mysql> 29 select p.pid, count(*) 30 from experiment_stats e, projects p 31 where e.pid_idx = p.pid_idx and 32 !p.class and e.batch 33 group by pid order by count(*) desc; 28 34 +--------------+----------+ 29 35 | pid | count(*) | … … 38 44 | DeterTest | 10 | 39 45 | psuworm | 8 | 40 | UCLAClass | 8 |41 46 | SOS | 6 | 42 | USCCSci530 | 5 |43 47 | rsgc | 4 | 44 48 | DIAMOND | 3 | 45 49 | Deter | 2 | 50 | liveobjects2 | 2 | 46 51 | SWOON | 2 | 47 | liveobjects2 | 2 |48 | Sec-Class | 2 |49 52 | vinci | 1 | 53 | T1T2 | 1 | 54 | SecureIED | 1 | 55 | DDoSImpact | 1 | 50 56 | Panorama | 1 | 51 | T1T2 | 1 |52 | DDoSImpact | 1 |53 | SecureIED | 1 |54 | USC558L | 1 |55 57 | eWorm | 1 | 56 58 +--------------+----------+ 57 59 }}} 58 60 59 All activity (including class) since 2009:61 All activity, ever: 60 62 {{{ 61 mysql> select year(last_activity) as yr, month(last_activity) as mo, count(*) 62 from experiment_stats 63 where batch and year(last_activity) >= 2009 64 group by yr, mo order by yr, mo; 65 +------+------+----------+ 66 | yr | mo | count(*) | 67 +------+------+----------+ 68 | 2009 | 4 | 9 | 69 | 2009 | 5 | 1 | 70 | 2009 | 10 | 2 | 71 | 2010 | 1 | 2 | 72 | 2010 | 2 | 2 | 73 | 2010 | 3 | 4 | 74 | 2010 | 4 | 1 | 75 | 2010 | 8 | 1 | 76 +------+------+----------+ 63 mysql> 64 select year(last_activity) as yr, month(last_activity) as mo, 65 count(*) 66 from experiment_stats s, projects p 67 where s.pid_idx = p.pid_idx and 68 !p.class and batch 69 group by yr, mo 70 order by yr, mo; 77 71 }}}
