NPLB Database - Page 2

IronBits · 2008-12-29, 15:30

nplb database was updated with the latest results last night.
It should become an automatic nightly update soon.

IronBits · 2008-12-30, 06:11

Actually, if you pulled yours off at midnight, when I'm ready to go, I can fetch your .csv file then import all the results.
midnight to midnight at your timezone is better log wise to.
We'll be watching for it.
Full automation is just around the corner now.

One manual test run tonight, then it gets tossed into cron and done.

mdettweiler · 2008-12-30, 07:06

Quote:

Originally Posted by IronBits

Actually, if you pulled yours off at midnight, when I'm ready to go, I can fetch your .csv file then import all the results.
midnight to midnight at your timezone is better log wise to.
We'll be watching for it.
Full automation is just around the corner now.

One manual test run tonight, then it gets tossed into cron and done.

Okay, I've set it so that it will copy off every day at 12:00 A.M. (Actually, it's 12:01, but that shouldn't make any difference over on your end.)

Edit: to clarify any discrepancies as to when exactly "12:00 A.M." is, specifically I mean midnight, i.e. 0:00.

IronBits · 2008-12-30, 07:14

Correct, 00:00 your server time/timezone, not my AZ time ;)

We already processed (automatically) results_20081229_0701_GB_nplb_4000.csv 2008-Dec-29 07:01:01
So I expect to see a results_20081230_0000_GB_nplb_4000.csv 2008-Dec-31 00:00:00 tomorrow night

Or whatever you want to do actually.
If you have something new there, at 00:05:00 AZ time, we'll get it

mdettweiler · 2008-12-30, 07:16

Quote:

Originally Posted by IronBits

Correct, 00:00 your server time/timezone, not my AZ time ;)

Correct.

(Just for clarification: since the server is at Gary's house, it is in CST time zone, i.e. GMT-6 at this time of year. I mention this so that people don't get confused, what with my forum profile specifying *me* to be in EST/GMT-5.

)

IronBits · 2008-12-30, 07:20

No problem, that means it will be ready 1 hour before I need it to be, so that gives you plenty of time to recover any stats run glitches .

IronBits · 2008-12-30, 15:39

Ok, don't see one there for 00:00 so I guess you will start that tonight.
http://stats.ironbits.net/statsnew/s...er.php?a=reset
As you can see from the above link, the date of the last result from each server is listed so we can keep an eye on how up-to-date the information you are looking at is.
Or something like that

mdettweiler · 2008-12-30, 17:05

Quote:

Originally Posted by IronBits

Ok, don't see one there for 00:00 so I guess you will start that tonight.
http://stats.ironbits.net/statsnew/s...er.php?a=reset
As you can see from the above link, the date of the last result from each server is listed so we can keep an eye on how up-to-date the information you are looking at is.
Or something like that

Correct--I changed the crontab setting after 0:00 yesterday, so it will copy off next at 0:00 tonight.

As for the stats by server page: looks good! Oh, and I just remembered something: you can feel free to dump the entry for "BP" into "IB" whenever it's convenient. "BP" was actually IB8500; we just called it "BP" because it was Bruce's personal server at first and we hadn't quite standardized on our current naming scheme quite as much as we hav enow. Thus, it's actually an IB server.

IronBits · 2009-01-02, 06:18

Ok, a lot more improvements were made to the database reports by AMDave.
Go take a look and let us know what you think, and if there is anything else you would like to see.
Thanks Dave!

The reports are extremely fast, and a lot more information is shown.

mdettweiler · 2009-01-02, 06:26

Quote:

Originally Posted by IronBits

Ok, a lot more improvements were made to the database reports by AMDave.
Go take a look and let us know what you think, and if there is anything else you would like to see.
Thanks Dave!

The reports are extremely fast, and a lot more information is shown.

Looks good!

One thing, though: speaking of AMDave, I noticed in the admin control panel that his email was listed as am_ave at yahoo dot com dot au, thus I presumed that was a typo and was going to fix it to "am_dave" instead...however, when I hit Post on the edit record page, suddenly it shows him as not having any email addresses listed at all! Do you know what happened there?

And one other thing I noticed: there are two entries for "CC" under Stats by Server, both with different #'s of results by them. The bigger one was last updated on 12/28, and the smaller one was last updated on 10/24. Do you know if this is a duplication, a split, or something else entirely?

Thanks,
Max

IronBits · 2009-01-02, 06:49

I have added jobMaxTime and prunePeriod to the main page, so it will like this now, for example...

Port 400 has 20922 remaining knpairs!
knpairs.txt - Size: 230166
Last Updated: 1/1/2009 11:08:14 PM
first k/n pair 549 609057
last k/n pair 555 615000
jobMaxTime = 3 * 24 * 3600 -- 3 days
prunePeriod = 3 * 24 * 3600 -- 3 days

2008-12-30, 06:11	#13
IronBits I ♥ BOINC! Oct 2002 Glendale, AZ. (USA) 3×7×53 Posts	Actually, if you pulled yours off at midnight, when I'm ready to go, I can fetch your .csv file then import all the results. midnight to midnight at your timezone is better log wise to. We'll be watching for it. Full automation is just around the corner now. One manual test run tonight, then it gets tossed into cron and done. Last fiddled with by IronBits on 2008-12-30 at 06:11

2008-12-30, 07:14	#15
IronBits I ♥ BOINC! Oct 2002 Glendale, AZ. (USA) 3·7·53 Posts	Correct, 00:00 your server time/timezone, not my AZ time ;) We already processed (automatically) results_20081229_0701_GB_nplb_4000.csv 2008-Dec-29 07:01:01 So I expect to see a results_20081230_0000_GB_nplb_4000.csv 2008-Dec-31 00:00:00 tomorrow night Or whatever you want to do actually. If you have something new there, at 00:05:00 AZ time, we'll get it Last fiddled with by IronBits on 2008-12-30 at 07:18

2008-12-30, 15:39	#18
IronBits I ♥ BOINC! Oct 2002 Glendale, AZ. (USA) 459₁₆ Posts	Ok, don't see one there for 00:00 so I guess you will start that tonight. http://stats.ironbits.net/statsnew/s...er.php?a=reset As you can see from the above link, the date of the last result from each server is listed so we can keep an eye on how up-to-date the information you are looking at is. Or something like that Last fiddled with by IronBits on 2008-12-30 at 15:39

2009-01-02, 06:18	#20
IronBits I ♥ BOINC! Oct 2002 Glendale, AZ. (USA) 10001011001₂ Posts	Ok, a lot more improvements were made to the database reports by AMDave. Go take a look and let us know what you think, and if there is anything else you would like to see. Thanks Dave! The reports are extremely fast, and a lot more information is shown. Last fiddled with by IronBits on 2009-01-02 at 06:18

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
NPLB.net down	Mini-Geek	No Prime Left Behind	17	2009-09-25 18:51
Servers for NPLB	gd_barnes	No Prime Left Behind	0	2009-08-10 19:21
NPLB on BOINC?	jasong	No Prime Left Behind	17	2008-12-01 10:25
two ideas for NPLB	Mini-Geek	No Prime Left Behind	16	2008-03-01 23:32
One month of NPLB	em99010pepe	No Prime Left Behind	5	2008-02-24 14:37

2008-12-29, 15:30	#12
IronBits I ♥ BOINC! Oct 2002 Glendale, AZ. (USA) 3·7·53 Posts	nplb database was updated with the latest results last night. It should become an automatic nightly update soon.

2008-12-30, 07:20	#17
IronBits I ♥ BOINC! Oct 2002 Glendale, AZ. (USA) 3×7×53 Posts	No problem, that means it will be ready 1 hour before I need it to be, so that gives you plenty of time to recover any stats run glitches .

2009-01-02, 06:49	#22
IronBits I ♥ BOINC! Oct 2002 Glendale, AZ. (USA) 3×7×53 Posts	I have added jobMaxTime and prunePeriod to the main page, so it will like this now, for example... Port 400 has 20922 remaining knpairs! knpairs.txt - Size: 230166 Last Updated: 1/1/2009 11:08:14 PM first k/n pair 549 609057 last k/n pair 555 615000 jobMaxTime = 3 * 24 * 3600 -- 3 days prunePeriod = 3 * 24 * 3600 -- 3 days