ne1 knows what kinda database they use for seti@home? im just curious... it seems to b quiet unstable 2 me... of course there is alot of IO but anyway... ne1 known?

/W

---

> OOPS!! According to Rom in a post made today the database is in an old Sun
> D220R.
>
>
> Roms post:
>
>
> >The machine the DB currently runs on is pretty old. It's one of the Sun
> D220R (2 x 440MHz Sparc, 2 GB RAM). The machine it is being migrated too is a
> new dual proc opteron ( 2.4GHz, I think ) with 6GB-8GB of ram. It is
> expandable to four processors and 16GB of ram if we need it.
>
> >I just think that we finally topped out on what the old machine was
> capable of handling, heck I just bought a PocketPC with a 600+MHz RISC
> processor that is probably able to keep up with it. I'm surprised it lasted
> this long.
>

That would be E-220R. I own three of them myself..

---

I'd rather speak my mind because it hurts too much to bite my tongue.

American Spirit BBQ Proudly Serving those that courageously defend freedom.

> >
> > That would be E-220R. I own three of them myself..
> >
> >
> Well, That was a quote from Rom not me.
> So what happened to the Sun E3500 that Sun donated to Berkeley?
> Last I remember they had some problems with it, did they
> just give up on it?

I think it is running the SETI@Home classic database.

Basically there are three database systems at work here.

SETI@Home classic database, which is the frontline database that handles work distribution.

SETI@Home BOINC database, which is on the D220R.

The master science database holds the validated results for both systems plus the other SETI projects at Berkeley.

---

----- Rom
BOINC Development Team, U.C. Berkeley
My Blog

> SETI@Home BOINC database, which is on the D220R.
>
> The master science database holds the validated results for both systems plus
> the other SETI projects at Berkeley.

E220R I don't beleive Sun ever made a D220R The E220R is the rack mounted version of the E-250.

---

I'd rather speak my mind because it hurts too much to bite my tongue.

American Spirit BBQ Proudly Serving those that courageously defend freedom.

> > >
> > > That would be E-220R. I own three of them myself..
> > >
> > >
> > Well, That was a quote from Rom not me.
> > So what happened to the Sun E3500 that Sun donated to Berkeley?
> > Last I remember they had some problems with it, did they
> > just give up on it?
>
> I think it is running the SETI@Home classic database.
>
> Basically there are three database systems at work here.
>
> SETI@Home classic database, which is the frontline database that handles work
> distribution.
>
> SETI@Home BOINC database, which is on the D220R.
>
> The master science database holds the validated results for both systems plus
> the other SETI projects at Berkeley.
>

Regardless what database manager are you using? I have seen 220R run some pretty heavy databases without even breaking a sweat.

---

I'd rather speak my mind because it hurts too much to bite my tongue.

American Spirit BBQ Proudly Serving those that courageously defend freedom.

> Regardless what database manager are you using? I have seen 220R run some
> pretty heavy databases without even breaking a sweat.

The model number I got from the server status page.

The whole database is roughly 40GBs is size, and the machine only has 2GBs of memory.

Last I heard, the user table is 4GBs, the host table is pretty small, and the team table is pretty small. Up until the db purging component was written, the result table was 80+GBs. Last I heard it was floating around 30GBs.

For each connection to be assigned workunits, you pretty much have to hit the disk to get the data. Then we have to hit the disk again for each result returned plus each result assigned.

So basically for each scheduler connect, we do a whole lot of DB traffic.

---

----- Rom
BOINC Development Team, U.C. Berkeley
My Blog

> @ Rom
> Would you know approximately when SETI Classic is going to be
> shut down, even a guess would be nice?

I have no idea.

---

----- Rom
BOINC Development Team, U.C. Berkeley
My Blog