Quick sql on ones with Darwin with change in scores in the last 10 days. Not a particularly quick query.
mysql> select proj,count(*) as ct from boinc_host where osname = 'Darwin' and metric1 - days10 > 0 group by proj order by ct; +--------+-------+ | proj | ct | +--------+-------+ | almt | 1 | | rad | 3 | | ras | 5 | | rna | 8 | | rio | 13 | | alb | 20 | | alm | 22 | | sub | 24 | | nrg | 29 | | opr | 31 | | pri | 38 | | moo | 40 | | wep | 40 | | num | 44 | | svt | 49 | | lhc | 56 | | pog | 57 | | lhct | 58 | | nfs | 79 | | lat | 85 | | sahb | 109 | | ibe | 136 | | min | 148 | | wup | 159 | | lei | 172 | | con | 199 | | eon2 | 205 | | sztaki | 219 | | yoy | 220 | | qcn | 256 | | col | 291 | | fmah | 360 | | abc | 404 | | pgrid | 456 | | eni | 502 | | poe | 512 | | sim | 568 | | mal | 1183 | | bcpdn | 2045 | | mil | 2702 | | rah | 3987 | | eah | 5863 | | bwcg | 6562 | | sah | 19451 | +--------+-------+ 44 rows in set (12 min 57.09 sec) On Fri, Apr 19, 2013 at 12:27 PM, McLeod, John <[email protected]> wrote: > They may be active and have a RAC below 100 (slow machine, or one on more > than one project), and they may be inactive and have a RAC > 100 (very > active in the past, but have quit). > > I believe rpc_time is the last contact to the scheduler for any reason. > Not 100% on this though. > > From: Jon Sonntag [mailto:[email protected]] > Sent: Friday, April 19, 2013 12:25 PM > To: McLeod, John > Cc: mark somers; [email protected]; > [email protected] > Subject: Re: [boinc_dev] question howmany BSD / Macs > > The following returns 309 OS X machines on Collatz. My assumption is that > a RAC > 100 means active which isn't 100% accurate. Then again, does > rpc_time get updated when they connect to get global preferences or update > even if "no new tasks" is set or if no WUs are sent or received? > > select count(*) from host where os_name like '%Darwin%' and > expavg_credit>100; > > > > On Fri, Apr 19, 2013 at 11:11 AM, McLeod, John <[email protected] > <mailto:[email protected]>> wrote: > It ought to be possible to glean information about your own client base > from the database. Each client record has information about what type of > machine it is. > > -----Original Message----- > From: boinc_dev [mailto:[email protected]<mailto: > [email protected]>] On Behalf Of mark somers > Sent: Friday, April 19, 2013 11:10 AM > To: [email protected]<mailto:[email protected]>; > [email protected]<mailto:[email protected]> > Subject: [boinc_dev] question howmany BSD / Macs > > Howmany projects / volunteers actually use BOINC with BSD and or Macs > (Intel > and or PowerPC)? > > I'm contemplating dropping the support for these architectures on our > project > because I lack Mac hardware to compile and test nowadays. I need to get rid > of graphics from our Classical apps (cruft code and old style graphics > stuff > and hard to migrate to new style graphics allas) and update things and > there > is a lot of work involved in having to support al those different archs. > > But before I decide I'd thought I'd ask... > > m. > -- > mark somers > tel: +31715274437<tel:%2B31715274437> > mail: [email protected]<mailto:[email protected]> > web: http://theorchem.leidenuniv.nl/people/somers > _______________________________________________ > boinc_dev mailing list > [email protected]<mailto:[email protected]> > http://lists.ssl.berkeley.edu/mailman/listinfo/boinc_dev > To unsubscribe, visit the above URL and > (near bottom of page) enter your email address. > _______________________________________________ > boinc_dev mailing list > [email protected]<mailto:[email protected]> > http://lists.ssl.berkeley.edu/mailman/listinfo/boinc_dev > To unsubscribe, visit the above URL and > (near bottom of page) enter your email address. > > _______________________________________________ > boinc_dev mailing list > [email protected] > http://lists.ssl.berkeley.edu/mailman/listinfo/boinc_dev > To unsubscribe, visit the above URL and > (near bottom of page) enter your email address. > -- Distributed Computing stats http://stats.free-dc.org _______________________________________________ boinc_dev mailing list [email protected] http://lists.ssl.berkeley.edu/mailman/listinfo/boinc_dev To unsubscribe, visit the above URL and (near bottom of page) enter your email address.
