Got plunty of work last night but not today. Still have some on the system that runs mostely Rosetta, but LHC has work now so I set that to 50% until Rosetta is working correct again. LHC and CPDN will keep that system busy. Only 4 waiting to be done for Rosetta there.

Still have plunty of Rosetta on the other system that usually runs CPDN most of the time but going down, should last another 4 to 5 days on that system.

---

Pizza@Home Rays Place Rays place Forums

Here is an update. The database is still being purged. It has gone through over 500,000 WU's and results but there is close to another 500,000 to go. The purging and archiving is also burdening the database server of course. I ask for peoples' patience as it is taking a while to write out the data into archive files. I do not want to just delete the WU records without archiving them so I can still link the structure predictions (output data) with who and what computer did them to give everyone feedback and credit.

We'll be sure to add new hardware in the future if necessary. I'd like to acknowledge our hard working servers with an image :)

David,

thanks for that. I for one will be patient :)

Seems to be a long time to do the purging though? What is the bottleneck do you know ? I work with large volume DB's, mostly Oracle & DB2 mind, and I know this can't be a fair comparison, but I've run applications which unload millions of transactions in a matter of minutes.

I presume this is mysql or PostGres ? I don't want to serve up the obvious but are the tables optimized, is it IO writing to disk etc etc.

Be interesting (at least to me) to know :)

Thanks again!

Bok

---

Free-DC

Stats for all projects

Custom Stats

Hi Bok,

We use mysql and I haven't optimized the set up yet but I'm glad you mentioned it because that is one of the first things on my list to do. It is also writing a bunch of data to disk to generate archive files. I'm also printing out debug statements since this is the first time using the purge utility and I want to monitor it's progress.

It can be quite amazing how much mysql improves with just running

optimize table xxxxxx

frequently. Though it's only if there is regular fragmentation of the data.

I ran into fairly recently on my stats system, adding that prior to every run fixed a lot of issues with speed.

Bok

---

Free-DC

Stats for all projects

Custom Stats

Great!, thanks Bok, I'll look into it.

I have been on Seti for years but cannot get BOINC to work. Please help.

---

I have been on Seti for years but cannot get BOINC to work. Please help.

The Rosetta server is temporarily down for data purging. Please see this thread

https://boinc.bakerlab.org/rosetta/forum_thread.php?id=272

---

Regards,
Bob P.

Please let me know if anyone is still experiencing problems getting work. The database load is down but I am going to continue purging tonight.

Please let me know if anyone is still experiencing problems getting work. The database load is down but I am going to continue purging tonight.

I'm not able to get any work right now, nor am I able to report a handful of my last results.
EDIT: I see that the database is down, so you must be working on that purge at the moment. Thanks for keeping the server status page updated!

---

Please let me know if anyone is still experiencing problems getting work. The database load is down but I am going to continue purging tonight.

Most of my computers now have some Rosetta work units but I still get intermittent problems, like (times are GMT+8):

4/11/2005 10:12:25 AM No schedulers responded
and
4/11/2005 10:13:53 AM No work from project
and
4/11/2005 10:18:34 AM Project is down

---

*** Join BOINC@Australia today ***

Sorry, I'm still working on the database server. But hope to finish within the next hour.

I am purging the database more overnight. The load on the database has reduced though so let me know if you are still experiencing problems getting work.

I am purging the database more overnight. The load on the database has reduced though so let me know if you are still experiencing problems getting work.

Time is Central Time Zone (USA)

11/3/2005 10:55:17 PM|rosetta@home|Fetching master file
11/3/2005 10:55:22 PM|rosetta@home|Master file download succeeded
11/3/2005 10:55:27 PM|rosetta@home|Sending scheduler request to https://boinc.bakerlab.org/rosetta_cgi/cgi
11/3/2005 10:55:27 PM|rosetta@home|Reason: To fetch work
11/3/2005 10:55:27 PM|rosetta@home|Requesting 43200 seconds of new work
11/3/2005 10:55:32 PM|rosetta@home|Scheduler request to https://boinc.bakerlab.org/rosetta_cgi/cgi succeeded
11/3/2005 10:55:32 PM|rosetta@home|No work from project
11/3/2005 10:55:37 PM|rosetta@home|Deferring communication with project for 54 seconds
11/3/2005 10:56:33 PM|rosetta@home|Sending scheduler request to https://boinc.bakerlab.org/rosetta_cgi/cgi
11/3/2005 10:56:33 PM|rosetta@home|Reason: To fetch work
11/3/2005 10:56:33 PM|rosetta@home|Requesting 43200 seconds of new work
11/3/2005 10:56:38 PM|rosetta@home|Scheduler request to https://boinc.bakerlab.org/rosetta_cgi/cgi succeeded
11/3/2005 10:56:38 PM|rosetta@home|No work from project
11/3/2005 10:56:43 PM|rosetta@home|Deferring communication with project for 54 seconds
11/3/2005 10:57:39 PM|rosetta@home|Sending scheduler request to https://boinc.bakerlab.org/rosetta_cgi/cgi
11/3/2005 10:57:39 PM|rosetta@home|Reason: To fetch work
11/3/2005 10:57:39 PM|rosetta@home|Requesting 43200 seconds of new work
11/3/2005 10:57:44 PM|rosetta@home|Scheduler request to https://boinc.bakerlab.org/rosetta_cgi/cgi succeeded
11/3/2005 10:57:44 PM|rosetta@home|No work from project
11/3/2005 10:57:49 PM|rosetta@home|Deferring communication with project for 54 seconds

---

As everyone probably noticed, it seems to be working again now (7am UTC).

---

Team CFVault.com
http://www.cfvault.com

Yup, WUs coming down!

---

I am purging the database more overnight. The load on the database has reduced though so let me know if you are still experiencing problems getting work.

Plenty of work now, thanks David.

I think the purge is now so far ahead that it purges results the minute they have come in and validated (and credit has been granted). All I see now on all my hosts is work units not yet completed (even minutes after they have been reported).

Hopefully these results aren't lost to the science?

---

*** Join BOINC@Australia today ***

I am purging the database more overnight. The load on the database has reduced though so let me know if you are still experiencing problems getting work.

Plenty of work now, thanks David.

I think the purge is now so far ahead that it purges results the minute they have come in and validated (and credit has been granted). All I see now on all my hosts is work units not yet completed (even minutes after they have been reported).

Hopefully these results aren't lost to the science?

Same here,
Finish w/u gets uploaded given credit "Dissapears" Magic,into cyber space,I hope not?
Thanks
Doug

---

I am purging the database more overnight. The load on the database has REDUCED though so let me know if you are still experiencing problems getting work.

But the homepage says:
Our database is being purged and old workunits and results are being archived. As a result, the load on the server is HIGH and work flow has been reduced.

I think the homepage should state "load on the server is HIGH" other way round -> "As a result, the load on the server is LOWER/REDUCED/etc."

My English is not very good but this put me in confusion on first reading :-)

---

The database purge has finished. Completed WU's and results should now be kept in the database for 1 week before they get purged and archived so users can view their results. WU's and results (and the credits granted) that have been purged and archived have not been lost. The credits for each user is totaled and kept in the database. The result output (structures and rmsd vs energy) can and will still be linked to users and computers for the results that have been archived. Thanks for everyone's patience!!