Changes between Version 1 and Version 2 of BatchStats


Ignore:
Timestamp:
Sep 3, 2010 1:18:40 PM (14 years ago)
Author:
mikeryan
Comment:

non-class activity

Legend:

Unmodified
Added
Removed
Modified

  • BatchStats

    v1 v2  
    1 By project:
     1Recent activity for non-class projects:
     2{{{
     3mysql>
     4select year(last_activity) as yr, month(last_activity) as mo,
     5       p.pid, eid
     6  from experiment_stats s, projects p
     7 where s.pid_idx = p.pid_idx and
     8       !p.class and batch and year(last_activity) >= 2009
     9 order by yr, mo, p.pid, eid;
     10+------+------+--------------+---------------+
     11| yr   | mo   | pid          | eid           |
     12+------+------+--------------+---------------+
     13| 2009 |    4 | T1T2         | jdemo         |
     14| 2009 |    5 | SecureIED    | 32hostsmcast  |
     15| 2010 |    1 | liveobjects2 | myexp1        |
     16| 2010 |    3 | DeterTest    | jjh-batch     |
     17| 2010 |    3 | DeterTest    | jjh-batchtest |
     18| 2010 |    3 | liveobjects2 | myexp         |
     19| 2010 |    3 | Panorama     | bitfuzz10-1   |
     20| 2010 |    8 | SOS          | appcomm       |
     21+------+------+--------------+---------------+
     22}}}
     23
     24All batch, by project:
    225{{{
    326mysql> select pid, count(*) from experiment_stats where batch
    … …  
    3457}}}
    3558
    36 Activity since 2009:
     59All activity (including class) since 2009:
    3760{{{
    3861mysql> select year(last_activity) as yr, month(last_activity) as mo, count(*)