PDA

View Full Version : Pruning of BABBling this weekend



The Bad Astronomer
2005-Apr-25, 06:45 PM
Folks-

Every message on this board is stored in a database. Currently, that database is one gigabyte (yes, 1Gb) in size, and growing rapidly. I am almost out of room on my webhosting service, and it's squeezing out the main site.

The majority of this diskspace appears to be occupied by the BABBling forum. As a first step in remedying this, I will be pruning the forum this weekend. What that means is that every thread that has not been active for the past six months will be deleted off the server.

I don't like to do things like this, but I have no choice (other than to double my hosting fees by upgrading to a dedicated server, which I am unwilling to do right now).

This is important: PLEASE DO NOT BUMP OLD THREADS YOU DON'T WANT DELETED. The purpose of this is to save room on the disk. I will go through threads I have seen bumped and delete them anyway.

Thanks,

Phil

Crazieman
2005-Apr-25, 06:48 PM
Sounds good to me. I didn't think you needed threads from 2003 :)

Well, except maybe the PX forum, some of those death and destruction threads are good.

Moose
2005-Apr-25, 06:58 PM
It might be a good idea to nail some of the longer game threads, even if they're still active. They can always be restarted if they're wanted badly enough, but it seems to me that no sane individual will go through (say) 900+ pages of word association. You may as well reclaim some space there.

Normandy6644
2005-Apr-25, 07:13 PM
It might be a good idea to nail some of the longer game threads, even if they're still active. They can always be restarted if they're wanted badly enough, but it seems to me that no sane individual will go through (say) 900+ pages of word association. You may as well reclaim some space there.

But what about our postcounts?!?!?

:lol: :wink:

Glom
2005-Apr-25, 07:17 PM
I've been ToSeeked... by BA... about his post. 8-[

In that case, you can delete that thread I just started in BBA.

I was asking if you'd accept mercy pleas. Of course, I don't propose direct submission for each individual thread, but rather we discuss the threads we want saved, to make sure there is agreement that there is value in them and then submit them to you in one go to spare your inbox.

Vega115
2005-Apr-25, 08:12 PM
Well BA, what needs to be done needs to be done. Anything that will make Bad Astronomy and the BABB run fast is good by me!


*takes a look at post count*


...It's just a number. :o (just kidding!)

Anyways, I'd had a feeling that this was going to happen sooner or later.

Jorge
2005-Apr-25, 08:35 PM
Well BA, what needs to be done needs to be done. Anything that will make Bad Astronomy and the BABB run fast is good by me!


*takes a look at post count*


...It's just a number. :o (just kidding!)

Anyways, I'd had a feeling that this was going to happen sooner or later.

if i remember the phpbb script correctly...
your post count will be fine, unless he hits the rebuild postcount btn
it would be way to resource intensive to check all the post of a persen and count them to displau the post count! so the number is kept in a seperate table that is updatre when you post.

(sure hope it is still correct, haven't use phpbb for... 2 years)

mickal555
2005-Apr-25, 08:51 PM
I think he can just re enter our post counts if they drop...


I've only been here for 7 mounths , I"m going to miss my first post (http://www.badastronomy.com/phpBB/viewtopic.php?p=268700&highlight=&#268700)though.. ...

I hope he keeps a backup record somewere.

skwirlinator
2005-Apr-25, 08:52 PM
The only issue I can think of is when memory references a toseeked issue that can't be toseeked.

For newbies such as me there will be alot of issues that will come up where oldbies like you will no doubtedly need to reiterate instead of just toseeking them. Could tend to get on your nerves.

It will tend to kill some non-discussable issues as well which should be a good thing.

As for toseekability I don't know how that would work but I've read some very enlightening posts that will undoubtedly be lost. Too bad there isn't a way for a toseek master to zip and store the forums for future toseeking issues. If not in forum form then in a sorta toseek archive database that could be cut and paste to finalize toseek issues.

Warning: the current medications in my body may have misconstrued my intentions resulting in incomprehensibe babbling. #-o

Nicolas
2005-Apr-25, 08:56 PM
I think he can just re enter our post counts if they drop...


I've only been here for 7 mounths , I"m going to miss my first post (http://www.badastronomy.com/phpBB/viewtopic.php?p=268700&highlight=&#268700)though.. ...

I hope he keeps a backup record somewere.

You do have personality Mickal555: already triggering a spelling comment on your very first post!! :wink: :D (just teasing you :))

[Nicolas looks up his first post]

mickal555
2005-Apr-25, 08:56 PM
I'd do it if I knew how....

I've got 2gb and there's no way I"ll use all of it

mickal555
2005-Apr-25, 08:58 PM
I think the BA would have autopruning software(the board comes with one-but in that case bumping threads would help them)

Nicolas
2005-Apr-25, 09:07 PM
My first post was in MoonHoax, between ToSeek and JayUtah :roll: .
I'm looking up my first BABBling post...
Found it! 19th October 2004, about famous Belgians :D.

Hm October;I guess I won't get hurt too much by this first pruning. Just one week of posts gone :) 100 posts at most. Counted: only 4 posts if I understood everything well!!
phew. I feel like Alexandria's library never burnt down :D :D :roll:

skwirlinator
2005-Apr-26, 12:32 AM
Dec 21, 2004
Not many in there anyway and none really very enlightening either

No pain...

Russ
2005-Apr-26, 01:01 AM
AWE Ya Weakly Interactive Massive Particles. Post counts be hanged. Phil, slash & burn! :roll: ;) :D :lol:

mickal555
2005-Apr-26, 06:31 AM
1253 as of now

IT's like waiting for a comet to crash into earth.....

captain swoop
2005-Apr-26, 08:46 AM
I think you could dump the Word Association Game without any problems as well. As far as I can see it's just a way to bump peoples post counts.

mickal555
2005-Apr-26, 08:52 AM
It's more than that- It's a way of letting off steam and relaxing

Lycus
2005-Apr-26, 08:56 AM
It's more than that- It's a way of letting off steam and relaxing
Still, it might be a good idea to delete and restart it every so often.

mickal555
2005-Apr-26, 09:05 AM
It's more than that- It's a way of letting off steam and relaxing
Still, it might be a good idea to delete and restart it every so often.

Yes but not my posts! :wink:

Captain Kidd
2005-Apr-26, 10:57 AM
It's more than that- It's a way of letting off steam and relaxing
Still, it might be a good idea to delete and restart it every so often.

Yes but not my posts! :wink:
That'd make for some really strange associations.

mickal555
2005-Apr-26, 11:32 AM
Some of mine are allready really strage

Ie. hmmm first thing I think of.... *looks around* pen! *writes pen*.... 8-[

Nicolas
2005-Apr-26, 04:14 PM
I think you could dump the Word Association Game without any problems as well. As far as I can see it's just a way to bump peoples post counts.

As far as I can see, if it were used for just that purpose, it wouldn't have been going on for so long. It's because of the funny associations (which allow you to learn other aspects of posters), the side talk, and just the "now for something completely different" value that it has been going on for so long already.

2005-Apr-26, 04:25 PM
YEAH?
its a sad day?:
I had the same trouble afew days ago
I deleted a whole folder ? lemme seek its data
----------------------------------------------
http://web.pdx.edu/~pdx00782/Forum/phpBB/viewtopic.php?p=437#437
that bought me a little time
while i also attempt to solve :THE: problem
just A seceond C

pumpkinpie
2005-Apr-26, 05:14 PM
The only issue I can think of is when memory references a toseeked issue that can't be toseeked.

For newbies such as me there will be alot of issues that will come up where oldbies like you will no doubtedly need to reiterate instead of just toseeking them. Could tend to get on your nerves.

It will tend to kill some non-discussable issues as well which should be a good thing.

As for toseekability I don't know how that would work but I've read some very enlightening posts that will undoubtedly be lost. Too bad there isn't a way for a toseek master to zip and store the forums for future toseeking issues. If not in forum form then in a sorta toseek archive database that could be cut and paste to finalize toseek issues.

Warning: the current medications in my body may have misconstrued my intentions resulting in incomprehensibe babbling. #-o

Record number of using forms of "ToSeek" in a post? :lol: (That's using it in a comprehensible way--not just writing it over and over!)

skwirlinator
2005-Apr-26, 05:17 PM
Thank you (bow) Thank You (bow)

Wasn't even going for a record... =D>

Maksutov
2005-Apr-26, 05:19 PM
For those who are interested in reading old posts after the database is trimmed, there appear to be pretty extensive records over at the Internet Archive WayBackMachine. (http://web.archive.org/web/*/http://www.badastronomy.com/phpBB/)

Maksutov
2005-Apr-26, 05:55 PM
A Thousand Pardons wrote:
Maksutov wrote:

It worked OK for me. For example try this link which was accessed using the steps you used for 10/2004/BABBling/Word Association Game, then clicking on the last page listed (517).

The page that appeared had "Goto page Previous 1, 2, 3 ... 516, 517, 518 ... 929, 930, 931 Next" at the top, with the page 931 linked to copies of today's posts.

It appears that some parts are archived, others aren't.

Where the URL begins with

"http://web.archive.org/web/20021027173915/www.badastronomy.com/phpBB"

the entire content appears to be archived.

But where the URL begins with

"http://web.archive.org/web/20050426105220/http://www.badastronomy.com/phpBB/"

it links to the current board.


[edit/wrong button]

A Thousand Pardons
2005-Apr-26, 06:12 PM
It changed on me!

I copied this link (http://web.archive.org/web/20041009212303/http://www.badastronomy.com/phpBB/viewtopic.php?t=9711&start=14975), which has 20041009 (2004 Oct 9) in it, but when I pasted it in my browser, and hit return, it sent me to a link with 20050426 (2005 Apr 26) in it. It must be figuring out if there are new versions... or something.

Maksutov
2005-Apr-26, 06:21 PM
Interesting.

BTW, for clarification, where I wrote


Where the URL begins with

"http://web.archive.org/web/20021027173915/www.badastronomy.com/phpBB"

the entire content appears to be archived.

But where the URL begins with

"http://web.archive.org/web/20050426105220/http://www.badastronomy.com/phpBB/"

it links to the current board.
The key factor appears to be the change from

"http://web.archive.org/web/.../www.badastronomy.com/phpBB"

to

"http://web.archive.org/web/.../http://www.badastronomy.com/phpBB/"

Andromeda321
2005-Apr-26, 06:22 PM
Hmmm ok thanks for the heads up BA. Guess I'll have to copy off some of those poems of mine that were floating around, it'd be a shame to lose them even if they were completely random... :wink:

Glom
2005-Apr-28, 03:37 PM
There should be a note about all the broken links that will arise after the Pruning. Sounds like a movie with Jack Nicholson.

Jpax2003
2005-Apr-28, 08:18 PM
There should be a note about all the broken links that will arise after the Pruning. Sounds like a movie with Jack Nicholson.A mad landscaper chops through the bathroom door with his pruning shears and says "Here's Juan!"

The Bad Astronomer
2005-May-01, 06:02 AM
I posted this in About the Board:



OK, the pruning is done. Kinda.

I went in and removed any thread in BABBling that had not had a reply in 185 days-- 6 months, back to November 1, 2005 (plus an extra day for padding).

Checking my files, this appears to have cleaned out well over 200 Mb of space. That's substantial. I haven't verified it yet. I get a nightly disk usage listing, and I'll compare yesterday's with the new one when it comes in.

An odd thing though-- the polls didn't get pruned! So they are still there going all the way back (several pages worth, actually), until I can figure out a way of deleting them as well.

Thanks for everyone's patience and understanding,

The BA

cyswxman
2005-May-01, 06:42 AM
It appears the post counts are unaffected (at least in my case).

frogesque
2005-May-01, 12:25 PM
The Bad Astronomer wrote:


...
I went in and removed any thread in BABBling that had not had a reply in 185 days-- 6 months, back to November 1, 2005 (plus an extra day for padding).
...


Back to the future? 8)

Maksutov
2005-May-01, 12:37 PM
The Bad Astronomer wrote:


...
I went in and removed any thread in BABBling that had not had a reply in 185 days-- 6 months, back to November 1, 2005 (plus an extra day for padding).
...


Back to the future? 8)
You're a wise guy, McFly! :D


(Maybe that's the date the Word Association Game will be trimmed to its roots...)