Changes between Version 2 and Version 3 of BatchStats


Ignore:
Timestamp:
Sep 8, 2010 6:07:56 PM (9 years ago)
Author:
mikeryan
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • BatchStats

    v2 v3  
    1 Recent activity for non-class projects:
     1All these stats ignore class projects which are currently banned from creating batch experiments.
     2
     3Recent activity:
    24{{{
    35mysql>
     
    2426All batch, by project:
    2527{{{
    26 mysql> select pid, count(*) from experiment_stats where batch
    27        group by pid order by count(*) desc;
     28mysql>
     29select 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;
    2834+--------------+----------+
    2935| pid          | count(*) |
     
    3844| DeterTest    |       10 |
    3945| psuworm      |        8 |
    40 | UCLAClass    |        8 |
    4146| SOS          |        6 |
    42 | USCCSci530   |        5 |
    4347| rsgc         |        4 |
    4448| DIAMOND      |        3 |
    4549| Deter        |        2 |
     50| liveobjects2 |        2 |
    4651| SWOON        |        2 |
    47 | liveobjects2 |        2 |
    48 | Sec-Class    |        2 |
    4952| vinci        |        1 |
     53| T1T2         |        1 |
     54| SecureIED    |        1 |
     55| DDoSImpact   |        1 |
    5056| Panorama     |        1 |
    51 | T1T2         |        1 |
    52 | DDoSImpact   |        1 |
    53 | SecureIED    |        1 |
    54 | USC558L      |        1 |
    5557| eWorm        |        1 |
    5658+--------------+----------+
    5759}}}
    5860
    59 All activity (including class) since 2009:
     61All activity, ever:
    6062{{{
    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 +------+------+----------+
     63mysql>
     64select 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;
    7771}}}