mersenneforum.org  

Go Back   mersenneforum.org > Prime Search Projects > No Prime Left Behind

Reply
 
Thread Tools
Old 2008-12-26, 15:15   #1
IronBits
I ♥ BOINC!
 
IronBits's Avatar
 
Oct 2002
Glendale, AZ. (USA)

3·7·53 Posts
Default NPLB Database

I am far from being happy, however, I'm far enough along to start sharing

It's not all working the way it was yet, but, the data is up-to-date (since two days ago)

http://stats.ironbits.net/statsnew/main.php?a=reset
Edit: Link is now (9/21/09) http://www.noprimeleftbehind.net/

I don't need bug reports yet, but if the numbers don't appear to be right, then be sure to speak up.

Enjoy what you can see as I stumble through getting the pages to show everything it used to.

Last fiddled with by mdettweiler on 2009-09-21 at 13:22 Reason: added new link
IronBits is offline   Reply With Quote
Old 2008-12-28, 05:46   #2
IronBits
I ♥ BOINC!
 
IronBits's Avatar
 
Oct 2002
Glendale, AZ. (USA)

3×7×53 Posts
Default

http://stats.ironbits.net/statsnew
Edit (9/21/09): Link is now http://www.noprimeleftbehind.net/
We have graphs again thanks to AMDave.
primes by team is being a snot to code but it will get there. (tech talk)
admin page is not working yet either, but everything else should be working fine now.

I have enhanced the teams table so it now contains
team
username
email
email2 (some of you requested automatic email to two different addresses)
just have to get that admin page to work.

Next up is the automating of the updates to the database around midnight for my servers and 8am for Gary's server.

Then you can start asking for features and changes.

Last fiddled with by mdettweiler on 2009-09-21 at 13:23 Reason: added new link
IronBits is offline   Reply With Quote
Old 2008-12-28, 14:18   #3
mdettweiler
A Sunny Moo
 
mdettweiler's Avatar
 
Aug 2007
USA (GMT-5)

792 Posts
Default

Quote:
Originally Posted by IronBits View Post
http://stats.ironbits.net/statsnew
We have graphs again thanks to AMDave.
primes by team is being a snot to code but it will get there. (tech talk)
admin page is not working yet either, but everything else should be working fine now.

I have enhanced the teams table so it now contains
team
username
email
email2 (some of you requested automatic email to two different addresses)
just have to get that admin page to work.

Next up is the automating of the updates to the database around midnight for my servers and 8am for Gary's server.

Then you can start asking for features and changes.
Nice work! And the database queries seem a lot faster than before, too.

I know that it's not really time to ask for changes yet...but I guess this isn't quite so much of a feature/change request as a bug report. Looking at the Stats by User page, I notice that the last person in the main table is the user "Death", with 452 results. However, if memory serves, we had a number of distinct users in the table before with less than that # of results. It seems as if they just got shaved off the end.

Or does the Stats by User page only show the top x# of users (at least for the time being)?

Last fiddled with by mdettweiler on 2008-12-28 at 14:22
mdettweiler is offline   Reply With Quote
Old 2008-12-28, 14:57   #4
IronBits
I ♥ BOINC!
 
IronBits's Avatar
 
Oct 2002
Glendale, AZ. (USA)

3×7×53 Posts
Default

Everything is fixed now.
Ready for bug reports and feature requests.

Looking into the stats by user page, I see it shows 1-25, the chart uses 31 but I can find 45 distinct users.
Looks like teams.username and results.username are not the same.

Good catch!

edit:
After going into the admin panel, I added all the usernames into teams.username for you.
I'll see if we can come up with a way that gets the names from results.username so we don't have to manually update the teams.username page.

I see I fubared the stats page, give me some time to work thru it.

Last fiddled with by IronBits on 2008-12-28 at 15:25
IronBits is offline   Reply With Quote
Old 2008-12-28, 16:02   #5
IronBits
I ♥ BOINC!
 
IronBits's Avatar
 
Oct 2002
Glendale, AZ. (USA)

3·7·53 Posts
Default

stats by user fixed.
IronBits is offline   Reply With Quote
Old 2008-12-28, 22:10   #6
IronBits
I ♥ BOINC!
 
IronBits's Avatar
 
Oct 2002
Glendale, AZ. (USA)

3×7×53 Posts
Default

Is everyone assigned to the correct Team ?

http://stats.ironbits.net/statsnew/stats.php
IronBits is offline   Reply With Quote
Old 2008-12-28, 22:17   #7
mdettweiler
A Sunny Moo
 
mdettweiler's Avatar
 
Aug 2007
USA (GMT-5)

792 Posts
Default

Quote:
Originally Posted by IronBits View Post
stats by user fixed.
Thanks!
Quote:
Originally Posted by IronBits View Post
Is everyone assigned to the correct Team ?

http://stats.ironbits.net/statsnew/stats.php
As far as I can tell, everybody seems to be on the right team.
mdettweiler is offline   Reply With Quote
Old 2008-12-28, 23:11   #8
IronBits
I ♥ BOINC!
 
IronBits's Avatar
 
Oct 2002
Glendale, AZ. (USA)

3×7×53 Posts
Default

Great!
I'll close all trouble tickets with the database.
The daily progress reports are a nice addition to what you used to have, so,
now go out and find some recruits for Free-DC.

I'll continue to work on the automation of importing the daily results from here and Gary's server.

Last fiddled with by IronBits on 2008-12-28 at 23:13
IronBits is offline   Reply With Quote
Old 2008-12-28, 23:56   #9
mdettweiler
A Sunny Moo
 
mdettweiler's Avatar
 
Aug 2007
USA (GMT-5)

11000011000012 Posts
Default

Quote:
Originally Posted by IronBits View Post
I'll continue to work on the automation of importing the daily results from here and Gary's server.
Just curious: would it be at all easier if I set Gary's server to run the daily results copy-off script at 1 A.M. CST (i.e. 12 A.M. Arizona time) so that you can pull everything down at the same time? It shouldn't be too hard for me to switch it over--just one little number to change in the crontab.
mdettweiler is offline   Reply With Quote
Old 2008-12-29, 00:23   #10
IronBits
I ♥ BOINC!
 
IronBits's Avatar
 
Oct 2002
Glendale, AZ. (USA)

100010110012 Posts
Default

If you like, then when the .csv files are imported around 1am az time, yours will go in at the same time as mine.
Your choice.
IronBits is offline   Reply With Quote
Old 2008-12-29, 04:48   #11
mdettweiler
A Sunny Moo
 
mdettweiler's Avatar
 
Aug 2007
USA (GMT-5)

792 Posts
Default

Quote:
Originally Posted by IronBits View Post
If you like, then when the .csv files are imported around 1am az time, yours will go in at the same time as mine.
Your choice.
Okay, I'll see about getting it changed over sometime tomorrow. It won't be in time for the next results copy-off, but it will be for the one after that.
mdettweiler is offline   Reply With Quote
Reply

Thread Tools


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

All times are UTC. The time now is 16:48.

Sat Nov 28 16:48:02 UTC 2020 up 79 days, 13:59, 4 users, load averages: 1.46, 1.52, 1.48

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.

This forum has received and complied with 0 (zero) government requests for information.

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation.
A copy of the license is included in the FAQ.