Search Members Help

» Welcome Guest
[ Log In :: Register ]

Page 1 of 212>>

[ Track This Topic :: Email This Topic :: Print this topic ]

 reply to topic new topic new poll
Topic: State of the forum< Next Oldest | Next Newest >
 Post Number: 1
GORDON Search for posts by this member.
90%
Avatar



Group: Super Administrators
Posts: 36125
Joined: Jun. 2004
PostIcon Posted on: May 15 2014,07:27  Skip to the next post in this topic. Ignore posts   QUOTE
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?

--------------
I don't give a fuck!
Offline
Top of Page Profile Contact Info 
 Post Number: 2
TPRJones Search for posts by this member.
I saw The Fault in our Stars opening night.
Avatar



Group: Privateers
Posts: 12384
Joined: May 2004
PostIcon Posted on: May 15 2014,07:40 Skip to the previous post in this topic. Skip to the next post in this topic. Ignore posts   QUOTE
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?

--------------
Vidi Perfutui Veni
Offline
Top of Page Profile Contact Info 
 Post Number: 3
GORDON Search for posts by this member.
90%
Avatar



Group: Super Administrators
Posts: 36125
Joined: Jun. 2004
PostIcon Posted on: May 15 2014,07:41 Skip to the previous post in this topic. Skip to the next post in this topic. Ignore posts   QUOTE
I am pretty sure I can prune threads in batch jobs, (simplified) sql-style.

That really is theonly solution I can think of.

--------------
I don't give a fuck!
Offline
Top of Page Profile Contact Info 
 Post Number: 4
GORDON Search for posts by this member.
90%
Avatar



Group: Super Administrators
Posts: 36125
Joined: Jun. 2004
PostIcon Posted on: May 15 2014,07:43 Skip to the previous post in this topic. Skip to the next post in this topic. Ignore posts   QUOTE
Going to run a backup, then prune everything older than... say... 8 years without a reply.   See what that does.

--------------
I don't give a fuck!
Offline
Top of Page Profile Contact Info 
 Post Number: 5
Leisher Search for posts by this member.
Top 3%, yo.
Avatar



Group: Super Administrators
Posts: 26651
Joined: May 2004
PostIcon Posted on: May 15 2014,07:49 Skip to the previous post in this topic. Skip to the next post in this topic. Ignore posts   QUOTE
Probably safe to do 5 years.
Offline
Top of Page Profile Contact Info WEB 
 Post Number: 6
TPRJones Search for posts by this member.
I saw The Fault in our Stars opening night.
Avatar



Group: Privateers
Posts: 12384
Joined: May 2004
PostIcon Posted on: May 15 2014,07:50 Skip to the previous post in this topic. Skip to the next post in this topic. Ignore posts   QUOTE
QUOTE
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?

--------------
Vidi Perfutui Veni
Offline
Top of Page Profile Contact Info 
 Post Number: 7
GORDON Search for posts by this member.
90%
Avatar



Group: Super Administrators
Posts: 36125
Joined: Jun. 2004
PostIcon Posted on: May 15 2014,07:51 Skip to the previous post in this topic. Skip to the next post in this topic. Ignore posts   QUOTE

(Leisher @ May 15 2014,10:49)
QUOTE
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 May 15 2014,07:51

--------------
I don't give a fuck!
Offline
Top of Page Profile Contact Info 
 Post Number: 8
GORDON Search for posts by this member.
90%
Avatar



Group: Super Administrators
Posts: 36125
Joined: Jun. 2004
PostIcon Posted on: May 15 2014,08:06 Skip to the previous post in this topic. Skip to the next post in this topic. Ignore posts   QUOTE
Forum: General Stuff
Cutoff: 1825 days or older
Threads found: 1748

Deleting.....

--------------
I don't give a fuck!
Offline
Top of Page Profile Contact Info 
 Post Number: 9
Leisher Search for posts by this member.
Top 3%, yo.
Avatar



Group: Super Administrators
Posts: 26651
Joined: May 2004
PostIcon Posted on: May 15 2014,08:07 Skip to the previous post in this topic. Skip to the next post in this topic. Ignore posts   QUOTE
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?
Offline
Top of Page Profile Contact Info WEB 
 Post Number: 10
TPRJones Search for posts by this member.
I saw The Fault in our Stars opening night.
Avatar



Group: Privateers
Posts: 12384
Joined: May 2004
PostIcon Posted on: May 15 2014,08:09 Skip to the previous post in this topic. Skip to the next post in this topic. Ignore posts   QUOTE
*gasp*

Not the LJ thread!!!

--------------
Vidi Perfutui Veni
Offline
Top of Page Profile Contact Info 
 Post Number: 11
GORDON Search for posts by this member.
90%
Avatar



Group: Super Administrators
Posts: 36125
Joined: Jun. 2004
PostIcon Posted on: May 15 2014,08:09 Skip to the previous post in this topic. Skip to the next post in this topic. Ignore posts   QUOTE
I should have bumped the oldest thread first, so we'd still have it.

--------------
I don't give a fuck!
Offline
Top of Page Profile Contact Info 
 Post Number: 12
GORDON Search for posts by this member.
90%
Avatar



Group: Super Administrators
Posts: 36125
Joined: Jun. 2004
PostIcon Posted on: May 15 2014,08:12 Skip to the previous post in this topic. Skip to the next post in this topic. Ignore posts   QUOTE
Forum: Internet Links
Cutoff: 1825 days or older
Threads found: 4023

Deleting.....

--------------
I don't give a fuck!
Offline
Top of Page Profile Contact Info 
 Post Number: 13
GORDON Search for posts by this member.
90%
Avatar



Group: Super Administrators
Posts: 36125
Joined: Jun. 2004
PostIcon Posted on: May 15 2014,08:29 Skip to the previous post in this topic. Skip to the next post in this topic. Ignore posts   QUOTE
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.

--------------
I don't give a fuck!
Offline
Top of Page Profile Contact Info 
 Post Number: 14
TheCatt Search for posts by this member.
Top 2%
Avatar



Group: Super Administrators
Posts: 22951
Joined: May 2004
PostIcon Posted on: May 15 2014,08:33 Skip to the previous post in this topic. Skip to the next post in this topic. Ignore posts   QUOTE
NNNNNNOOOOOOOOOOOOOOOO

Sorry, I'm a hoarder.

Oh well.

--------------
It's not me, it's someone else.
Offline
Top of Page Profile Contact Info 
 Post Number: 15
GORDON Search for posts by this member.
90%
Avatar



Group: Super Administrators
Posts: 36125
Joined: Jun. 2004
PostIcon Posted on: May 15 2014,08:48 Skip to the previous post in this topic. Skip to the next post in this topic. Ignore posts   QUOTE
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.

--------------
I don't give a fuck!
Offline
Top of Page Profile Contact Info 
 Post Number: 16
Malcolm Search for posts by this member.
I disagree.
Avatar



Group: Privateers
Posts: 27168
Joined: May 2004
PostIcon Posted on: May 15 2014,08:52 Skip to the previous post in this topic. Skip to the next post in this topic. Ignore posts   QUOTE

(GORDON @ May 15 2014,10:48)
QUOTE
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?

--------------
Diogenes of Sinope:

"It is not that I am mad, it is only that my head is different from yours."

"Other dogs bite only their enemies, whereas I bite also my friends in order to save them."

Arnold Judas Rimmer, BSC, SSC:

"Better dead than smeg."
Offline
Top of Page Profile Contact Info 
 Post Number: 17
TheCatt Search for posts by this member.
Top 2%
Avatar



Group: Super Administrators
Posts: 22951
Joined: May 2004
PostIcon Posted on: May 15 2014,09:03 Skip to the previous post in this topic. Skip to the next post in this topic. Ignore posts   QUOTE
Yeah, if you just exported, I'd figure something out... eventually

--------------
It's not me, it's someone else.
Offline
Top of Page Profile Contact Info 
 Post Number: 18
GORDON Search for posts by this member.
90%
Avatar



Group: Super Administrators
Posts: 36125
Joined: Jun. 2004
PostIcon Posted on: May 15 2014,09:07 Skip to the previous post in this topic. Skip to the next post in this topic. Ignore posts   QUOTE
It's an actual mysql dbase, not just text files.  Compressing data would be a lot of recoding.

--------------
I don't give a fuck!
Offline
Top of Page Profile Contact Info 
 Post Number: 19
TheCatt Search for posts by this member.
Top 2%
Avatar



Group: Super Administrators
Posts: 22951
Joined: May 2004
PostIcon Posted on: May 15 2014,09:10 Skip to the previous post in this topic. Skip to the next post in this topic. Ignore posts   QUOTE
Right, just export the mysql DB, and I'll do something with it.

--------------
It's not me, it's someone else.
Offline
Top of Page Profile Contact Info 
 Post Number: 20
GORDON Search for posts by this member.
90%
Avatar



Group: Super Administrators
Posts: 36125
Joined: Jun. 2004
PostIcon Posted on: May 15 2014,09:12 Skip to the previous post in this topic.  Ignore posts   QUOTE
Well, that's already done.

--------------
I don't give a fuck!
Offline
Top of Page Profile Contact Info 
38 replies since May 15 2014,07:27 < Next Oldest | Next Newest >

[ Track This Topic :: Email This Topic :: Print this topic ]


Page 1 of 212>> 		reply to topic new topic new poll

» Quick Reply State of the forum
iB Code Buttons
You are posting as:

Do you wish to enable your signature for this post?
Do you wish to enable emoticons for this post?
Track this topic
View All Emoticons
View iB Code