| View previous topic :: View next topic   | 
	
	
	
		| Author | 
		Message | 
	
	
		The Admins KWSN Castellan
  
  
  Joined: 13 Aug 2003 Posts: 21
 
  | 
		
			
				 Posted: Sun Jan 18, 2004 4:55 am    Post subject: pruning and database size | 
				     | 
			 
			
				
  | 
			 
			
				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 | 
		 | 
	
	
		  | 
	
	
		The Admins KWSN Castellan
  
  
  Joined: 13 Aug 2003 Posts: 21
 
  | 
		
			
				 Posted: Tue Dec 14, 2004 4:00 am    Post subject:  | 
				     | 
			 
			
				
  | 
			 
			
				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 | 
		 | 
	
	
		  | 
	
	
		 |