SO... as many of you know, I've got to pull the plug on the stats server. It's been quietly running in my ex-employer's server room for the last 4 months, however I just got a request to have it out by the 21st. Now, I'm going to see if I can set it up in my basement for a while as an interim solution, however I'm on cable through Adelphia, who blocks port 80 and it's possible that I'll end up with a varying IP address should there be a power failure, etc. Not a big deal, just an inconvenience more than anything else.
However, I think the time has come to move the stats to a hosted site. As many of you know, they have caps on disc space and overage charges, etc. The FaD database is currently running at about 2gig of data (12M records total) and the oldest database, D2OL is also around 2g (about 13M records total). Both database have data from the day I turned them one (Jan-01-2001 for D2OL and Nov-09-2004 for FaD).
The question I have is how much data is actually required? Just totals and today and yesterday? The last week? Month? 2? 6? I dunno... I'm a data guy and like seeing lots of data, but how much of it is really relevent I guess is the question. Not many (if any) of the stats sites I look at (and to be honest, I generally don't look any any unless I've got data issues and am trying to see if my data is right) carry as much, if any, historical data, and maybe that's something that sets my stats apart from others.
The answer to the question on how I proceed with setting up my stats going forward depends heavily on how much data you guys want to see. Without a doubt, at this point, I'm going to need to either host these somewhere, or pay for a pipe and static IP address to my home. Expense is going to become an issue and I'll probably have to resort to a PayPal button on the pages somewhere, and/or GoogleAds... whatever... the free ride from my ex-work was nice while it lasted.
Stats that will be removed very shortly are the LifeMapper (dead project), DPAD (needs a rewrite... my numbers are all wrong), seriously considering canning D2OL and TSC unless there are objections, and SoB has virtually no traffic so I'm not sure there is a need to continue providing those stats (I'm not even sure if they are right it's been so long since I've looked at them and I've had no emails telling me they are wrong). That leaves FaD which is ending in a month.
So, the second part of this is suggestions for new projects... I've been asked to do Rosetta, and I think I owe the DPAD folks stats. I understand that once you do one BOINC stats page, the rest are easy to roll out as the stats format is the same for all of them. If this is true, then we seriously need to look at how much data to retain as I can't afford to have 10 projects each with a gig of disc space hosted! lol...
So, pls give me your input and participate in the poll!
Thanks!
Geoff
[EDIT] Server stats: This MySQL server has been running for 57 days, 6 hours, 47 minutes and 20 seconds. It started up on Sep 15, 2005 at 07:37 AM. Since its startup, 159,388,020 queries have been sent to the server.
Of course, it's done lots more than that... this is just the longest it's run without me rebooting it because of software updates, etc 🙂
However, I think the time has come to move the stats to a hosted site. As many of you know, they have caps on disc space and overage charges, etc. The FaD database is currently running at about 2gig of data (12M records total) and the oldest database, D2OL is also around 2g (about 13M records total). Both database have data from the day I turned them one (Jan-01-2001 for D2OL and Nov-09-2004 for FaD).
The question I have is how much data is actually required? Just totals and today and yesterday? The last week? Month? 2? 6? I dunno... I'm a data guy and like seeing lots of data, but how much of it is really relevent I guess is the question. Not many (if any) of the stats sites I look at (and to be honest, I generally don't look any any unless I've got data issues and am trying to see if my data is right) carry as much, if any, historical data, and maybe that's something that sets my stats apart from others.
The answer to the question on how I proceed with setting up my stats going forward depends heavily on how much data you guys want to see. Without a doubt, at this point, I'm going to need to either host these somewhere, or pay for a pipe and static IP address to my home. Expense is going to become an issue and I'll probably have to resort to a PayPal button on the pages somewhere, and/or GoogleAds... whatever... the free ride from my ex-work was nice while it lasted.
Stats that will be removed very shortly are the LifeMapper (dead project), DPAD (needs a rewrite... my numbers are all wrong), seriously considering canning D2OL and TSC unless there are objections, and SoB has virtually no traffic so I'm not sure there is a need to continue providing those stats (I'm not even sure if they are right it's been so long since I've looked at them and I've had no emails telling me they are wrong). That leaves FaD which is ending in a month.
So, the second part of this is suggestions for new projects... I've been asked to do Rosetta, and I think I owe the DPAD folks stats. I understand that once you do one BOINC stats page, the rest are easy to roll out as the stats format is the same for all of them. If this is true, then we seriously need to look at how much data to retain as I can't afford to have 10 projects each with a gig of disc space hosted! lol...
So, pls give me your input and participate in the poll!
Thanks!
Geoff
[EDIT] Server stats: This MySQL server has been running for 57 days, 6 hours, 47 minutes and 20 seconds. It started up on Sep 15, 2005 at 07:37 AM. Since its startup, 159,388,020 queries have been sent to the server.
Of course, it's done lots more than that... this is just the longest it's run without me rebooting it because of software updates, etc 🙂