WU shortage

Author	Message
Paratima Send message Joined: 15 Nov 07 Posts: 31 Credit: 56,404,447 RAC: 0	Message 2838 - Posted: 25 Mar 2008, 19:10:17 UTC Why are there 0 WU's ready to go? ID: 2838 · Rating: 0 · rate: / Reply Quote

Dave Przybylo Send message Joined: 5 Feb 08 Posts: 236 Credit: 49,648 RAC: 0	Message 2839 - Posted: 25 Mar 2008, 19:11:37 UTC - in response to Message 2838. Why are there 0 WU's ready to go? Travis is going to do a db_purge to clean out the database. Should only take an hour or so i think. After that he'll create more. If he doesn't post back here and i'll talk to him. Dave Przybylo MilkyWay@home Developer Department of Computer Science Rensselaer Polytechnic Institute ID: 2839 · Rating: 0 · rate: / Reply Quote

Emanuel Send message Joined: 18 Nov 07 Posts: 280 Credit: 2,442,757 RAC: 0	Message 2842 - Posted: 25 Mar 2008, 21:21:27 UTC - in response to Message 2839. Travis is going to do a db_purge to clean out the database. Should only take an hour or so i think. After that he'll create more. If he doesn't post back here and i'll talk to him. Out of curiosity, why is this necessary? Is it just a routine thing you do after all WUs have been reported and you've got the data to start processing it, before you do a new search? Or does clutter build up over time? ID: 2842 · Rating: 0 · rate: / Reply Quote

Dave Przybylo Send message Joined: 5 Feb 08 Posts: 236 Credit: 49,648 RAC: 0	Message 2843 - Posted: 25 Mar 2008, 21:56:01 UTC - in response to Message 2842. Travis is going to do a db_purge to clean out the database. Should only take an hour or so i think. After that he'll create more. If he doesn't post back here and i'll talk to him. Out of curiosity, why is this necessary? Is it just a routine thing you do after all WUs have been reported and you've got the data to start processing it, before you do a new search? Or does clutter build up over time? Well we should get this to be done automatically, however we haven't been able to get it to do that yet. But as more WUs get reported in, the database grows quite a bit, and when we take them out (download them), they stay in the mysql database. It gathers about 1 gb each day from what i've seen. So it can get very cluttered. Dave Przybylo MilkyWay@home Developer Department of Computer Science Rensselaer Polytechnic Institute ID: 2843 · Rating: 0 · rate: / Reply Quote

Philadelphia Send message Joined: 9 Nov 07 Posts: 131 Credit: 180,454 RAC: 0	Message 2844 - Posted: 25 Mar 2008, 22:45:20 UTC It doesn't seem like the purge process takes very long to do. CLICK TO HELP BUILD ID: 2844 · Rating: 0 · rate: / Reply Quote

Travis Volunteer moderator Project administrator Project developer Project tester Project scientist Send message Joined: 30 Aug 07 Posts: 2046 Credit: 26,480 RAC: 0	Message 2847 - Posted: 26 Mar 2008, 0:29:27 UTC - in response to Message 2844. It doesn't seem like the purge process takes very long to do. it takes a couple hours depending on how many WUs are in the database. we're going to look into automating this process so the buildup doesn't slow the server to a crawl. ID: 2847 · Rating: 0 · rate: / Reply Quote