State of the forum

Post by **GORDON** » Thu May 15, 2014 10:27 am

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?

Post by **TPRJones** » Thu May 15, 2014 10:40 am

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?

Post by **GORDON** » Thu May 15, 2014 10:41 am

I am pretty sure I can prune threads in batch jobs, (simplified) sql-style.

That really is theonly solution I can think of.

Post by **GORDON** » Thu May 15, 2014 10:43 am

Going to run a backup, then prune everything older than... say... 8 years without a reply. See what that does.

Post by **Leisher** » Thu May 15, 2014 10:49 am

Probably safe to do 5 years.

Post by **TPRJones** » Thu May 15, 2014 10:50 am

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?

Post by **GORDON** » Thu May 15, 2014 10:51 am

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

Post by **GORDON** » Thu May 15, 2014 11:06 am

Forum: General Stuff
Cutoff: 1825 days or older
Threads found: 1748

Deleting.....

Post by **Leisher** » Thu May 15, 2014 11:07 am

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?

Post by **TPRJones** » Thu May 15, 2014 11:09 am

*gasp*

Not the LJ thread!!!

Post by **GORDON** » Thu May 15, 2014 11:09 am

I should have bumped the oldest thread first, so we'd still have it.

Post by **GORDON** » Thu May 15, 2014 11:12 am

Forum: Internet Links
Cutoff: 1825 days or older
Threads found: 4023

Deleting.....

Post by **GORDON** » Thu May 15, 2014 11:29 am

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.

Post by **TheCatt** » Thu May 15, 2014 11:33 am

NNNNNNOOOOOOOOOOOOOOOO

Sorry, I'm a hoarder.

Oh well.

Post by **GORDON** » Thu May 15, 2014 11:48 am

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.

Malcolm · Post by **Malcolm** » Thu May 15, 2014 11:52 am

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?

Post by **TheCatt** » Thu May 15, 2014 12:03 pm

Yeah, if you just exported, I'd figure something out... eventually

Post by **GORDON** » Thu May 15, 2014 12:07 pm

It's an actual mysql dbase, not just text files. Compressing data would be a lot of recoding.

Post by **TheCatt** » Thu May 15, 2014 12:10 pm

Right, just export the mysql DB, and I'll do something with it.

Post by **GORDON** » Thu May 15, 2014 12:12 pm

Well, that's already done.