 Return of the Brewboard - Part II |
  |
 Mar 31 2006, 11:50 AM
Post
#16
|
|
|
Brewer  Group: Members Posts: 432 Joined: 26-August 04 Member No.: 2,594  |
QUOTE(DrDale @ Mar 31 2006, 11:38 AM)  Seriously, there are a few "classic" PH threads that ought to be kept, but of course a lot of the older threads could safely be deleted. I suspect that that is true in the beer forum, too. How many "What are theese things floating in my beer?!?" threads are we saving for posterity? Although I agree, it isn't logistically possible. You are talking about a massive effort of pruning that is based on multiple variables that a human would then have to execute each thread. The other method is a simple SQL string saying to delete any threads older then X. |
 |
 
|
|
Mar 31 2006, 12:04 PM
Post
#17
|
|
|
Brewmaster Group: Members Posts: 632 Joined: 27-January 03 From: Home Sweet Home Member No.: 92 |
QUOTE(psolio @ Mar 31 2006, 11:51 AM) Although I agree, it isn't logistically possible. You are talking about a massive effort of pruning that is based on multiple variables that a human would then have to execute each thread. The other method is a simple SQL string saying to delete any threads older then X. Maybe. Or maybe a thread that hasn't been posted in after sone period of time---not one month, of course, but something longer---can be safely assumed to have been duplicated or superceded. I guess that the most important part of what I'm saying is that there are a few older PH threads that people might want to hold on to, because they are part of the lore of the place, and so it wouldn't be purely automatic to clean it out either. If it absolutely came to that to keep the BB going then of course, but these recent problems are something new, and it is more likely that they are caused by some glitch involved in moving to the new server than that suddenly the DB got to be too large (even if that is a contributing factor). Deleting any threads should be a last resort. |
|
|
|
|
Mar 31 2006, 12:07 PM
Post
#18
|
|
|
Brewmaster Group: Members Posts: 951 Joined: 6-January 05 From: Great Pond, ME Member No.: 3,288 |
|
|
|
|
|
Apr 1 2006, 07:30 AM
Post
#19
|
|
|
Assistant Brewer Group: Members Posts: 142 Joined: 5-June 03 From: Leesburg, VA Member No.: 769 |
In all honesty, there should not be an issue with a sql database of the size of the forum. If I have heard properly, it's about 500meg. That's not that huge in the over all scope of why MySQL can handle. However, it may be a limitation on the forum software. It's been a while since I played with IPB, however most forum sotware packages allow you to remove threads within certian forums by date or size.
So other forums that work fantastic are vbulletin and simplemachines. vbulletin cost money (but so did this IPB) whereas simplemachines is free. The headache would be to convert the theme, however it looks mostly like it's a header with a different CSS (not a huge deal). Anyway, maybe it's a growing pain of IPB more than anything. Just a guess... |
|
|
|
|
Apr 1 2006, 08:11 AM
Post
#20
|
|
|
Brewmaster Group: banned Posts: 666 Joined: 16-March 02 From: Mooresville, NC Member No.: 201 |
Some of the problems occured when the board was offline and I was working directly with the database via a mysql shell, so I don't think it's the software. It seems more likely that it's a mysql configuration issue, or a hardware (RAM) limitation on our dedicated server. The server seemed to choke when trying to run a 'repair table ibf_posts' (the largest table by far). It would run overnight, and I'd wake up to a non-responsive mysql daemon and/or a corrupted table.
|
|
|
|
|
Apr 1 2006, 08:47 AM
Post
#21
|
|
|
Assistant Brewer Group: Members Posts: 142 Joined: 5-June 03 From: Leesburg, VA Member No.: 769 |
What are the specs on the server? Why not do the repair function local and then upload the mysql server? Also - is it microsoft or linux based?
|
|
|
|
|
Apr 1 2006, 10:23 AM
Post
#22
|
|
|
Brewmaster Group: banned Posts: 666 Joined: 16-March 02 From: Mooresville, NC Member No.: 201 |
QUOTE(scubaj @ Apr 1 2006, 08:47 AM) What are the specs on the server? Why not do the repair function local and then upload the mysql server? Also - is it microsoft or linux based?
|
|
|
|
|
Apr 1 2006, 10:35 AM
Post
#23
|
|
|
Brewmaster Group: Members Posts: 739 Joined: 29-December 04 From: Austin, TX Member No.: 3,236 |
QUOTE(scubaj @ Apr 1 2006, 06:30 AM) In all honesty, there should not be an issue with a sql database of the size of the forum. If I have heard properly, it's about 500meg. That's not that huge in the over all scope of why MySQL can handle. However, it may be a limitation on the forum software. It's been a while since I played with IPB, however most forum sotware packages allow you to remove threads within certian forums by date or size. So other forums that work fantastic are vbulletin and simplemachines. vbulletin cost money (but so did this IPB) whereas simplemachines is free. The headache would be to convert the theme, however it looks mostly like it's a header with a different CSS (not a huge deal). Anyway, maybe it's a growing pain of IPB more than anything. Just a guess... SM IMHO is absolutely terrible. But, that's just IMHO. vBulletin is only about a 150/yr for the license last I checked. I use phpBB for my forum.. but whatever floats the boat. |
|
|
|
|
Apr 1 2006, 11:46 AM
Post
#24
|
|
|
Assistant Brewer Group: Members Posts: 142 Joined: 5-June 03 From: Leesburg, VA Member No.: 769 |
A celeron may be slight under powered to support everything and with 512mb of memory, that too may be a little lite.
Good that IPB is looking into it. |
|
|
|
|
Apr 1 2006, 12:18 PM
Post
#25
|
|
|
Brewmaster Group: banned Posts: 666 Joined: 16-March 02 From: Mooresville, NC Member No.: 201 |
QUOTE(scubaj @ Apr 1 2006, 11:46 AM) A celeron may be slight under powered to support everything and with 512mb of memory, that too may be a little lite. Agreed that's not a top of the line server. But we just moved from a shared hosting environment about a month ago. I figured if a shared hosting environment could handle us (although we limped along for a while), then even a low end dedicated server would be an improvement. |
|
|
|
|
Apr 2 2006, 06:35 PM
Post
#26
|
|
|
Brewmaster Group: Members Posts: 788 Joined: 20-January 04 From: Fort Salonga, The Island Member No.: 1,604 |
Preserving old threads? What ever would become of the baby diaper thread??? <eg>
|
|
|
|
|
Apr 3 2006, 07:20 AM
Post
#27
|
|
|
Homebrewer Group: Members Posts: 27 Joined: 31-March 05 From: Tampa, FL Member No.: 3,678 |
oh happy day!! the forum returns!!
|
|
|
|
|
Apr 3 2006, 04:04 PM
Post
#28
|
|
|
Brewmaster Group: Members Posts: 788 Joined: 20-January 04 From: Fort Salonga, The Island Member No.: 1,604 |
just curious,
I presume live chat is part of the 'under construction' part? |
|
|
|
|
Apr 3 2006, 04:22 PM
Post
#29
|
|
|
on hiatus... Group: Members Posts: 3,650 Joined: 25-March 02 Member No.: 69 |
QUOTE(twocents @ Apr 4 2006, 06:04 AM) just curious, I presume live chat is part of the 'under construction' part? Live Chat explanation (IMG:style_emoticons/brewboard/wink.gif) |
|
|
|
|
Apr 6 2006, 10:17 AM
Post
#30
|
|
|
Brewmaster Group: Members Posts: 3,035 Joined: 15-November 04 From: Nederland, TX Member No.: 3,024 |
QUOTE(kroyster @ Apr 1 2006, 10:23 AM)
Oh, and I don't know why the argument is keep vs. trash on these threads. Why not just create an archive and push the obsolete/old threads (however they are defined) there? Surely the search function can span multiple tables, no? Even if it couldn't, a separate search function could be defined for each archive, couldn't it? I guess I'm not seeing why anything has to be deleted. |
|
|
|
|
2 User(s) are reading this topic (2 Guests and 0 Anonymous Users)
0 Members:
|
Lo-Fi Version | Time is now: 18th April 2021 - 02:58 PM |