log in

Are there really that many hosts here ?

Message boards : Questions/Problems/Bugs : Are there really that many hosts here ?
Message board moderation

To post messages, you must log in.

AuthorMessage
Bok

Send message
Joined: 5 Sep 09
Posts: 12
Credit: 1,892,151
RAC: 0
Message 2092 - Posted: 14 Aug 2020, 20:37:41 UTC

There are 16719 users in the xml, but almost 7M hosts.

Now i know there are bunch associated with the gridcoin pools but still.. I show the vast majority are anonymous

MariaDB [dcfree]> select a.userid,b.nick, count(*) as hosts_count from boinc_host a left join boinc_user b on a.proj = b.proj and b.id = a.userid where a.proj = 'nfs' group by a.userid order by hosts_count desc limit 0,20;
+--------+---------------------+-------------+
| userid | nick                | hosts_count |
+--------+---------------------+-------------+
|      0 | NULL                |     6861725 |
| 236313 | grcpool.com-2       |        1823 |
| 155971 | grcpool.com         |        1725 |
| 263803 | grcpool.com-3       |        1550 |
| 464004 | Science United      |        1096 |
|  54605 | pool.gridcoin.co    |         981 |
|   6962 | USTL-FIL (Lille Fr) |         810 |
|    660 | zombie67 [MM]       |         548 |
| 381244 | deniska26           |         290 |
|  14440 | CentreITS           |         275 |
|   1084 | whizbang            |         177 |
|  98454 | cyberkev            |         154 |
|     78 | vaughan             |         141 |
| 383403 | Dancer76            |         139 |
| 472311 | KySU                |         132 |
|   4247 | TheKillerChicken    |         126 |
|    797 | Coleslaw            |         124 |
| 317517 | grcpool-anon        |         123 |
|   1961 | Sineater            |         122 |
|   5179 | Sageev George       |         121 |
+--------+---------------------+-------------+
ID: 2092 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote
Profile Gigacruncher [TSBTs Pirate]
Volunteer moderator

Send message
Joined: 26 Sep 09
Posts: 218
Credit: 22,841,893
RAC: 3
Message 2093 - Posted: 16 Aug 2020, 7:12:14 UTC

They were when Syracuse university were running the project. What do you need from us so I can get in touch with Greg?
ID: 2093 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote

Message boards : Questions/Problems/Bugs : Are there really that many hosts here ?


Home | My Account | Message Boards