Nice, could you try this for BSD and Intel Macs too please?
m. > 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. > _______________________________________________ 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.
