KWSN Orbiting Fortress Forum Index KWSN Orbiting Fortress
KWSN Distributed Computing Teams forum
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

pruning and database size

 
Post new topic   Reply to topic    KWSN Orbiting Fortress Forum Index -> News & Info
View previous topic :: View next topic  
Author Message
The Admins
KWSN Castellan
KWSN Castellan


Joined: 13 Aug 2003
Posts: 21

PostPosted: Sun Jan 18, 2004 4:55 am    Post subject: pruning and database size Reply with quote

While trying to restore a backup recently we ran into several problems, being caused by the size of the backup, or better: the size of the database. Therefore we will reduce that size by deleting all threads that have not been posted to in 45 days(*). We used to have (and we have now) pruning after 80 days for most forums. In recent months we had no pruning at all.

Exceptions are Ďannouncementsí and the forum Brother Maynard's Pizzeria and Library of Ancient Wisdom. If there is anything worth keeping, members can pm Sir Hamster of Elderberry and ask him to move a thread there.

Of course members can keep threads alive by posting to threads that are about to be deleted. If that keeping alive has any use, itís ok. If it looks like it is just to keep the thread alive we will not be pleased and might [edit] act accordingly .

The Admins


(*) If 45 doesn't give the desired reduction, we might go back to 30 days.

The List:

No pruning:
News & Info
Team Stat Page Links
Brother Maynard's Pizzeria and Library of Ancient Wisdom


Pruning after 45 days:
New and Departing Members
KWSN Round Table
KWSN S@H Team
KWSN BOINC'ers
KWSN Humanitarian DC Teams
The Court Jester Speaks
The Bragging Yard
Ye Olde Help Scrolls
Science News and Discussion


Ni!
_________________
baldyhead
jonnyv
macg
Back to top
View user's profile Send private message
The Admins
KWSN Castellan
KWSN Castellan


Joined: 13 Aug 2003
Posts: 21

PostPosted: Tue Dec 14, 2004 4:00 am    Post subject: Reply with quote

Since on the new server we have all maintenance possibillities we could wish for, we have no more db-size problems. To be on the cautious side we left pruning in place but we adjusted the limits:

No pruning:
News & Info
Team Stat Page Links
Brother Maynard's Pizzeria and Library of Ancient Wisdom
Ye Olde Help Scrolls

Pruning after 120 days:
New and Departing Members
KWSN Round Table
The Court Jester Speaks
The Gorge of eternal Peril
The Bragging Yard


Pruning after 240 days:
KWSN S@H Team
KWSN BOINC'ers
KWSN Humanitarian DC Teams
Science News and Discussion

If anyone is unhappy with the limits now set, please let us know......
_________________
baldyhead
jonnyv
macg
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    KWSN Orbiting Fortress Forum Index -> News & Info All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group
Optimized Seti@Home App | BOINC Stats