Page 1 of 2 12 LastLast
Results 1 to 30 of 37

Thread: Pruning of BABBling this weekend

  1. #1
    Join Date
    Oct 2001
    Posts
    11,227

    Pruning of BABBling this weekend

    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

  2. #2
    Join Date
    Mar 2004
    Posts
    285
    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.

  3. #3
    Join Date
    Nov 2002
    Posts
    14,595
    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.
    "Words that make questions may not be questions at all."
    - Neil deGrasse Tyson, answering loaded question in ten words or less
    at a 2010 talk MCed by Stephen Colbert.

  4. #4
    Join Date
    Aug 2003
    Posts
    2,988
    Quote Originally Posted by Moose
    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?!?!?

    :wink:

  5. #5
    Glom's Avatar
    Glom is offline Insert awesome title here
    Join Date
    Sep 2002
    Posts
    11,319
    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.

  6. #6
    Join Date
    Jun 2003
    Posts
    347
    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. (just kidding!)

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

  7. #7
    Join Date
    Aug 2004
    Posts
    725
    Quote Originally Posted by Vega115
    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. (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)

  8. #8
    Join Date
    May 2004
    Posts
    6,823
    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 though.....

    I hope he keeps a backup record somewere.

  9. #9
    Join Date
    Jun 2004
    Posts
    404
    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

  10. #10
    Join Date
    Sep 2004
    Posts
    15,598
    Quote Originally Posted by mickal555
    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 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: (just teasing you )

    [Nicolas looks up his first post]
    With sufficient thrust, water towers fly just fine.

  11. #11
    Join Date
    May 2004
    Posts
    6,823
    I'd do it if I knew how....

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

  12. #12
    Join Date
    May 2004
    Posts
    6,823
    I think the BA would have autopruning software(the board comes with one-but in that case bumping threads would help them)

  13. #13
    Join Date
    Sep 2004
    Posts
    15,598
    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 .

    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 :roll:
    With sufficient thrust, water towers fly just fine.

  14. #14
    Join Date
    Jun 2004
    Posts
    404
    Dec 21, 2004
    Not many in there anyway and none really very enlightening either

    No pain...

  15. #15
    Join Date
    Oct 2001
    Posts
    1,570
    AWE Ya Weakly Interactive Massive Particles. Post counts be hanged. Phil, slash & burn! :roll:

  16. #16
    Join Date
    May 2004
    Posts
    6,823
    1253 as of now

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

  17. #17
    Join Date
    Feb 2003
    Posts
    14,122
    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.
    Rules For Posting To This Board
    All Moderation in Purple

  18. #18
    Join Date
    May 2004
    Posts
    6,823
    It's more than that- It's a way of letting off steam and relaxing

  19. #19
    Join Date
    Nov 2003
    Posts
    966
    Quote Originally Posted by mickal555
    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.

  20. #20
    Join Date
    May 2004
    Posts
    6,823
    Quote Originally Posted by Lycus
    Quote Originally Posted by mickal555
    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:

  21. #21
    Join Date
    Feb 2003
    Posts
    2,052
    Quote Originally Posted by mickal555
    Quote Originally Posted by Lycus
    Quote Originally Posted by mickal555
    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.

  22. #22
    Join Date
    May 2004
    Posts
    6,823
    Some of mine are allready really strage

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

  23. #23
    Join Date
    Sep 2004
    Posts
    15,598
    Quote Originally Posted by captain swoop
    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.
    With sufficient thrust, water towers fly just fine.

  24. #24
    Guest

    20040526


    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/p....php?p=437#437
    that bought me a little time
    while i also attempt to solve :THE: problem
    just A seceond C

  25. #25
    Join Date
    Mar 2004
    Posts
    1,187
    Quote Originally Posted by skwirlinator
    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? (That's using it in a comprehensible way--not just writing it over and over!)

  26. #26
    Join Date
    Jun 2004
    Posts
    404
    Thank you (bow) Thank You (bow)

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

  27. #27
    Join Date
    Jan 2004
    Posts
    16,643

    Re: Pruning of BABBling this weekend

    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.

  28. #28
    Join Date
    Jan 2004
    Posts
    16,643

    Re: Pruning of BABBling this weekend

    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]

  29. #29
    Join Date
    Aug 2004
    Posts
    2,790
    It changed on me!

    I copied this link, 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.

  30. #30
    Join Date
    Jan 2004
    Posts
    16,643

    Re: Pruning of BABBling this weekend

    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/"

Similar Threads

  1. This is really babbling, but...
    By crosscountry in forum Off-Topic Babbling
    Replies: 5
    Last Post: 2007-Feb-14, 06:44 PM
  2. BABBling reopened
    By The Bad Astronomer in forum Off-Topic Babbling
    Replies: 35
    Last Post: 2005-Jul-16, 04:14 PM
  3. Has the BABB pruning taken place yet?
    By WaxRubiks in forum Off-Topic Babbling
    Replies: 4
    Last Post: 2005-May-03, 03:25 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •