CPU Performance Data

Message boards : Number crunching : CPU Performance Data
Message board moderation

To post messages, you must log in.

AuthorMessage
ArizonaSquid

Send message
Joined: 17 Jun 18
Posts: 2
Credit: 10,233,048
RAC: 20,097
Message 857 - Posted: 27 Sep 2019, 1:39:52 UTC

It doesn't appear that all CPUs participating in the project are listed at https://boinc.multi-pool.info/latinsquares/cpu_list.php

Is this list not automatically generated? Or are some processors not recognized due to some obscure error (e.g. there are no AMD Threadripper processors on the list)
ID: 857 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote
ice00
Project administrator
Project developer

Send message
Joined: 28 Oct 17
Posts: 139
Credit: 49,903
RAC: 2
Message 859 - Posted: 2 Oct 2019, 19:56:51 UTC - in response to Message 857.  

That statistic is generate when you click into the page by Boinc software looking inside the host table (it has all statistics about a PC attached to the project).

If I manually search for it I get:

mysql> select count(*), p_model from host group by p_model having p_model like '%Threadripper%';
+----------+--------------------------------------------------------------------------------+
| count(*) | p_model                                                                        |
+----------+--------------------------------------------------------------------------------+
|        2 | AMD Ryzen Threadripper 1900X 8-Core Processor [Family 23 Model 1 Stepping 1]   |
|        9 | AMD Ryzen Threadripper 1920X 12-Core Processor [Family 23 Model 1 Stepping 1]  |
|        1 | AMD Ryzen Threadripper 1950X 16-Core Processor  [Family 23 Model 1 Stepping 1] |
|      110 | AMD Ryzen Threadripper 1950X 16-Core Processor [Family 23 Model 1 Stepping 1]  |
|        2 | AMD Ryzen Threadripper 2920X 12-Core Processor [Family 23 Model 8 Stepping 2]  |
|        5 | AMD Ryzen Threadripper 2950X 16-Core Processor [Family 23 Model 8 Stepping 2]  |
|        2 | AMD Ryzen Threadripper 2970WX 24-Core Processor [Family 23 Model 8 Stepping 2] |
|       83 | AMD Ryzen Threadripper 2990WX 32-Core Processor [Family 23 Model 8 Stepping 2] |
+----------+--------------------------------------------------------------------------------+
8 rows in set (0,46 sec)


The Boinc code inside the php file, use some filter onto the results to limit them (as it was too slow in Seti):

function get_data() {
    $db = BoincDb::get(true);
    // get CPU model status in a special query;
    // enumerating hosts was too slow on SETI@home.
    //
    // Ideally a model's fpops should be the median over hosts of that model.
    // But SQL has no median function.
    // Instead, take the mean of plausible values
    //
    $x = $db->enum_fields('host', 'StdClass', 
        'p_model, count(*) as nhosts, avg(p_ncpus) as ncores, avg(p_fpops) as fpops',
        'p_fpops>1e6 and p_fpops<1e11 and p_fpops <> 1e9 and expavg_credit>'.MIN_CREDIT.' group by p_model',
        null
    );
    $m2 = array();
    foreach ($x as $m) {
        if ($m->nhosts < MIN_COUNT) continue;
        $y = new StdClass;
        $y->model = $m->p_model;
        $y->p_fpops = $m->fpops;
        $y->mean_ncores = $m->ncores;
        $y->nhosts = $m->nhosts;
        $m2[] = $y;
    }
    return $m2;
}


1) Takes only CPUs that has an expect average credits of min 10
2) Takes only CPU that has floating point capacity inside a given range
3) Takes only CPU that has at least 10 PC with it

Executing the above query (with point 1 and 2, but not 3), gives:


mysql> select p_model, count(*) as nhosts, avg(p_ncpus) as ncores, avg(p_fpops) as fpops from host where p_fpops>1000000 and p_fpops<10000000000 and p_fpops <> 100000000 and expavg_credit>'10' group by p_model having p_model like '%Threadripper%';
+--------------------------------------------------------------------------------+--------+---------+-------------------+
| p_model                                                                        | nhosts | ncores  | fpops             |
+--------------------------------------------------------------------------------+--------+---------+-------------------+
| AMD Ryzen Threadripper 1950X 16-Core Processor [Family 23 Model 1 Stepping 1]  |      8 | 31.6250 | 4536869382.474418 |
| AMD Ryzen Threadripper 2920X 12-Core Processor [Family 23 Model 8 Stepping 2]  |      1 | 24.0000 | 5031380453.020853 |
| AMD Ryzen Threadripper 2950X 16-Core Processor [Family 23 Model 8 Stepping 2]  |      3 | 32.0000 | 5298576471.103373 |
| AMD Ryzen Threadripper 2990WX 32-Core Processor [Family 23 Model 8 Stepping 2] |      7 | 55.1429 | 4328623771.943422 |
+--------------------------------------------------------------------------------+--------+---------+-------------------+
4 rows in set (0,29 sec)


If we apply points 3, as nhost are less than 10, no results pops up.

Point 2 is not the case here, but what makes it not appears is even point 1 as there are probably inactive CPU that has the expected result equals to 0 that cut off those contribution.

So the result is correct in the way Boinc is given those statistics

Thanks
ID: 859 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote
ArizonaSquid

Send message
Joined: 17 Jun 18
Posts: 2
Credit: 10,233,048
RAC: 20,097
Message 865 - Posted: 3 Oct 2019, 19:08:46 UTC - in response to Message 859.  

Aha! That makes sense... thanks!
ID: 865 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote

Message boards : Number crunching : CPU Performance Data


©2021 Progger & Stefano Tognon (ice00)