Page 1 of 2
Posted: Thu May 15, 2014 10:27 am
by GORDON
I have noticed this forum going slow lately.... has anyone else noticed?
Well, I just hit my domain control panel, and we are currently using 110 of 100 available mb. We are 10% over allowed capacity. Not sure why they let me go over... hope they aren't planning on billing me for it.
Anyway, we need to prune over 10% of the forum. I don't LIKE purging all the older stuff.... but it is prolly the only way...
Suggestions?
Posted: Thu May 15, 2014 10:40 am
by TPRJones
Is there a process in it that can do that sort of thing automagically with given criteria, or will someone need to delete a bunch of threads by hand?
Posted: Thu May 15, 2014 10:41 am
by GORDON
I am pretty sure I can prune threads in batch jobs, (simplified) sql-style.
That really is theonly solution I can think of.
Posted: Thu May 15, 2014 10:43 am
by GORDON
Going to run a backup, then prune everything older than... say... 8 years without a reply. See what that does.
Posted: Thu May 15, 2014 10:49 am
by Leisher
Probably safe to do 5 years.
Posted: Thu May 15, 2014 10:50 am
by TPRJones
Then prune everything older than... say... 8 years without a reply.
That sort of thing was going to be my suggestion, yeah.
If we haven't talked about it in eight years what are the odds it will come up again?
Posted: Thu May 15, 2014 10:51 am
by GORDON
Leisher wrote:Probably safe to do 5 years.
I can do it forum by forum... I don't want to touch anything in Movies, but general and links, yeah, can prolly do 5.
Edited By GORDON on 1400165485
Posted: Thu May 15, 2014 11:06 am
by GORDON
Forum: General Stuff
Cutoff: 1825 days or older
Threads found: 1748
Deleting.....
Posted: Thu May 15, 2014 11:07 am
by Leisher
I would suggest eliminating America II, Ultima Online, and League of the EVE of UO Galaxies.
Most of our political talk occurs in General and Internet anymore.
UO has rarely been posted in over the past few years, and honestly doesn't need to be separate from Games.
And there's no need for a private games section at this point. If we need it in the future, we can just create a new one.
Do you have the ability to see what forums eat the most space? Should we clean up the LJ thread?
Posted: Thu May 15, 2014 11:09 am
by TPRJones
*gasp*
Not the LJ thread!!!
Posted: Thu May 15, 2014 11:09 am
by GORDON
I should have bumped the oldest thread first, so we'd still have it.
Posted: Thu May 15, 2014 11:12 am
by GORDON
Forum: Internet Links
Cutoff: 1825 days or older
Threads found: 4023
Deleting.....
Posted: Thu May 15, 2014 11:29 am
by GORDON
According to the domain control panel, the database size has not been reduced at all. It either isn't refreshed yet, or the data is still there.
Hmmmm.
Posted: Thu May 15, 2014 11:33 am
by TheCatt
NNNNNNOOOOOOOOOOOOOOOO
Sorry, I'm a hoarder.
Oh well.
Posted: Thu May 15, 2014 11:48 am
by GORDON
Outta room. No choice unless I wanted to host the thing somewhere else, and that sounds exhausting. Also I don't have enough upstream bandwidth for that.
Posted: Thu May 15, 2014 11:52 am
by Malcolm
GORDON wrote:Outta room. No choice unless I wanted to host the thing somewhere else, and that sounds exhausting. Also I don't have enough upstream bandwidth for that.
You can't spit the files into a simple .csv (or something) format and turn the compression all the way up on 7-Zip?
Posted: Thu May 15, 2014 12:03 pm
by TheCatt
Yeah, if you just exported, I'd figure something out... eventually
Posted: Thu May 15, 2014 12:07 pm
by GORDON
It's an actual mysql dbase, not just text files. Compressing data would be a lot of recoding.
Posted: Thu May 15, 2014 12:10 pm
by TheCatt
Right, just export the mysql DB, and I'll do something with it.
Posted: Thu May 15, 2014 12:12 pm
by GORDON
Well, that's already done.