Results 1 to 2 of 2

Thread: Recent Milestones across BOINC projects Not Updating Properly

  1. #1

    Recent Milestones across BOINC projects Not Updating Properly

    I have two entries in this area for Einstein@Home. The first for Tuesday, 3 August 2010 which shows 100,000 units and a second for Einstein@Home for Tuesday, 31 March 2009 which shows 1,000 units which is hung in the display despite the fact I currently have completed 126,023 units. How can I fix the 31 March 2009 so it updates correctly.

  2. #2
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    21,802
    Blog Entries
    13
    Took me a while to find you in the stats based only on the information you have provided. I'm guessing that this is you ?

    Is the issue due to not having all of the other milestones inbetween?

    The reason for this 'odd' behaviour is actually a little complex. There are two tables for the milestones, one is current and one is 'archived'. The archiving is not automatic at all so right now contains all milestones older than March 1st 2010.
    On that paqe I retrieve the latest milestone from each project from the current milestones and seperately do the same with the archive ones. This is a little clumsy though. In fact the sql I use to get these is the worst performing sql in the whole stats system!

    It's an area I need to look into so it's high on my radar right now. The 1000 milestone is certainly correct though. As an FYI full milestone list below for you in EAH (I also need to provide a means to display these somewhere...)

    Code:
    mysql> select stat_date,milestone from boinc_milestone_archive where cpid = 'f2755ef54743ebf022adf384be065f88' and proj = 'eah';
    +------------+-----------+
    | stat_date  | milestone |
    +------------+-----------+
    | 2008-08-12 |       100 |
    | 2008-08-12 |       200 |
    | 2009-02-05 |       500 |
    | 2009-03-31 |      1000 |
    +------------+-----------+
    4 rows in set (0.00 sec)
    
    mysql> select stat_date,milestone from boinc_milestone where cpid = 'f2755ef54743ebf022adf384be065f88' and proj = 'eah';
    +------------+-----------+
    | stat_date  | milestone |
    +------------+-----------+
    | 2010-03-17 |      2000 |
    | 2010-03-19 |      3000 |
    | 2010-03-22 |      5000 |
    | 2010-03-24 |      6000 |
    | 2010-03-26 |      7000 |
    | 2010-03-28 |      8000 |
    | 2010-03-30 |      9000 |
    | 2010-04-01 |     10000 |
    | 2010-04-20 |     20000 |
    | 2010-04-27 |     25000 |
    | 2010-05-05 |     30000 |
    | 2010-05-20 |     40000 |
    | 2010-06-08 |     50000 |
    | 2010-06-19 |     60000 |
    | 2010-06-30 |     70000 |
    | 2010-07-13 |     80000 |
    | 2010-07-25 |     90000 |
    | 2010-08-03 |    100000 |
    +------------+-----------+
    18 rows in set (0.00 sec)
    Hope that helps. I'm going to try and do some updates to this area tomorrow...

    Bok

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •