Malazan Empire: Housekeeping - Malazan Empire

Jump to content

Help

Page 1 of 1

You cannot start a new topic
You cannot reply to this topic

Housekeeping clearing out all the old dead wood

#1 Tsundoku

A what?

Group: Malaz Regular
Posts: 4,663
Joined: 06-January 03
Location:Maison de merde

Posted 20 July 2014 - 02:34 AM

Is someone able to clean out all the spambot members? What about those who logged on years ago, posted once or twice then none since?

Could we come up with some criteria for the cull? Maybe less than 5 posts and/or not logged on in X months or years (for starters)?

It's just that the member list is crazy-bloated and I'm sure the memory can be better employed doing anything else. Or do we have such massive amounts of space that it doesn't matter?

Just seems ... untidy ... to me.

Oh, would it be a manual thing for someone to waste hours on (in which case don't bother), or could someone set up some parameters and press "go"?

This post has been edited by Sombra: 20 July 2014 - 02:35 AM

"Fortune favors the bold, though statistics favor the cautious." - Indomitable Courteous (Icy) Fist, The Palace Job - Patrick Weekes

"Well well well ... if it ain't The Invisible C**t." - Billy Butcher, The Boys

"I have strong views about not tempting providence and, as a wise man once said, the difference between luck and a wheelbarrow is, luck doesn’t work if you push it." - Colonel Orhan, Sixteen Ways to Defend a Walled City - KJ Parker

#2 Solidsnape

Emperor

Group: Malaz Regular
Posts: 802
Joined: 21-March 11
Location:England.
Interests:Playing Guitar/Ukulele/Banjolele, reading, music, Wing Chun Kuen, my 2 boys and my wonderful GF.
From good 'ol Newcastle upon Tyne.

Posted 20 July 2014 - 02:40 AM

1. Don't delete me.

"If you seek the crumpled bones of the T'lan Imass,
gather into one hand the sands of Raraku"
The Holy Desert
- Anonymous.

#3 Solidsnape

Emperor

Group: Malaz Regular
Posts: 802
Joined: 21-March 11
Location:England.
Interests:Playing Guitar/Ukulele/Banjolele, reading, music, Wing Chun Kuen, my 2 boys and my wonderful GF.
From good 'ol Newcastle upon Tyne.

Posted 20 July 2014 - 02:40 AM

2. Don't delete me.

"If you seek the crumpled bones of the T'lan Imass,
gather into one hand the sands of Raraku"
The Holy Desert
- Anonymous.

#4 Solidsnape

Emperor

Group: Malaz Regular
Posts: 802
Joined: 21-March 11
Location:England.
Interests:Playing Guitar/Ukulele/Banjolele, reading, music, Wing Chun Kuen, my 2 boys and my wonderful GF.
From good 'ol Newcastle upon Tyne.

Posted 20 July 2014 - 02:41 AM

3. Don't delete me.

"If you seek the crumpled bones of the T'lan Imass,
gather into one hand the sands of Raraku"
The Holy Desert
- Anonymous.

#5 Solidsnape

Emperor

Group: Malaz Regular
Posts: 802
Joined: 21-March 11
Location:England.
Interests:Playing Guitar/Ukulele/Banjolele, reading, music, Wing Chun Kuen, my 2 boys and my wonderful GF.
From good 'ol Newcastle upon Tyne.

Posted 20 July 2014 - 02:41 AM

4. Don't delete me.

"If you seek the crumpled bones of the T'lan Imass,
gather into one hand the sands of Raraku"
The Holy Desert
- Anonymous.

#6 Solidsnape

Emperor

Group: Malaz Regular
Posts: 802
Joined: 21-March 11
Location:England.
Interests:Playing Guitar/Ukulele/Banjolele, reading, music, Wing Chun Kuen, my 2 boys and my wonderful GF.
From good 'ol Newcastle upon Tyne.

Posted 20 July 2014 - 02:42 AM

5. Don't delete me.

Does this ensure my survival?

"If you seek the crumpled bones of the T'lan Imass,
gather into one hand the sands of Raraku"
The Holy Desert
- Anonymous.

#7 Abyss

abyssus abyssum invocat

Group: Administrators
Posts: 21,803
Joined: 22-May 03
Location:The call is coming from inside the house!!!!
Interests:Interesting.

Posted 20 July 2014 - 03:15 AM

Solidsnape, on 20 July 2014 - 02:42 AM, said:

5. Don't delete me.

Does this ensure my survival?

Nope. I'm going to delete you.

THIS IS YOUR REMINDER THAT THERE IS A
'VIEW NEW CONTENT' BUTTON THAT
ALLOWS YOU TO VIEW NEW CONTENT

#8 Andorion

Group: Malaz Regular
Posts: 4,516
Joined: 30-July 11
Interests:All things Malazan, sundry sci-fi and fantasy, history, Iron Maiden

Posted 20 July 2014 - 04:22 AM

Unleash the Whirlwind! Death to the Mezla scum!!! Posted Image

#9 Xae

Server Administrator

Group: Administrators
Posts: 90
Joined: 12-March 13

Posted 20 July 2014 - 07:35 AM

Spam users are kept since removing them would effectively unban their email addresses. As for members who have been inactive for a very long time, I don't think it's conventional to delete user accounts on communities. Also, when you do so on IP.Board, their posts become orphaned.

That aside, yeah, it's not difficult. It would only take one mildly complicated SQL query, and it could be set up to run on a monthly basis.

In terms of server resources, it doesn't matter. There's no extra drain on the server because of the members table. MzE's database is comparatively tiny, if you can believe it. MySQL is made to handle several hundred million rows and it even functions well once you pass the billion mark.

#10 Solidsnape

Emperor

Group: Malaz Regular
Posts: 802
Joined: 21-March 11
Location:England.
Interests:Playing Guitar/Ukulele/Banjolele, reading, music, Wing Chun Kuen, my 2 boys and my wonderful GF.
From good 'ol Newcastle upon Tyne.

Posted 20 July 2014 - 03:49 PM

Couldn't we just switch the forum off, then on again?

"If you seek the crumpled bones of the T'lan Imass,
gather into one hand the sands of Raraku"
The Holy Desert
- Anonymous.

#11 Gust Hubb

Necromancer Extraordinaire

Group: High House Mafia
Posts: 1,487
Joined: 19-May 11
Location:Northern Hemisphere
Interests:Glass slides with entrapped bits of colored tissue
Around, just quiet....er

Posted 20 July 2014 - 04:01 PM

Plus, what would we do without EmmaWatsonInABra?

"You don't clean u other peoples messes.... You roll in them like a dog on leftover smoked whitefish torn out f the trash by raccoons after Sunday brunch on a hot day."
~Abyss

#12 Vengeance

High Priest of Shinrei Love and Worship

Group: Administrators
Posts: 3,895
Joined: 27-June 07
Location:Chicago
very good...;)

Posted 20 July 2014 - 11:00 PM

Gust Hubb, on 20 July 2014 - 04:01 PM, said:

Plus, what would we do without EmmaWatsonInABra?

Create emmawatsonwithoutabra.

How many fucking people do I have to hammer in order to get that across.
Hinter - Vengy - DIE. I trusted you you bastard!!!!!!!
Steven Erikson made drowning in alien cum possible - Obdigore

#13 amphibian

Ribbit

Group: Malaz Regular
Posts: 7,960
Joined: 28-September 06
Location:Upstate NY
Interests:Hopping around

Posted 21 July 2014 - 01:09 AM

Emmawatsonsclothingchoicesarereallyimportant would totally agree.

I survived the Permian and all I got was this t-shirt.

#14 Gnaw

Recovering eating disordered addict of HHM

Group: High House Mafia
Posts: 5,966
Joined: 16-June 12

Posted 21 July 2014 - 01:45 AM

Vengeance, on 20 July 2014 - 11:00 PM, said:

Gust Hubb, on 20 July 2014 - 04:01 PM, said:

Plus, what would we do without EmmaWatsonInABra?

Create emmawatsonwithoutabra.

Aren't you supposed to be hunting in Michigan or something?

"Between stimulus and response there is a space. In that space is our power to choose our response. In our response lies our growth and our freedom." - Viktor Frankl

#15 Vengeance

High Priest of Shinrei Love and Worship

Group: Administrators
Posts: 3,895
Joined: 27-June 07
Location:Chicago
very good...;)

Posted 23 July 2014 - 09:39 PM

Gnaw, on 21 July 2014 - 01:45 AM, said:

Vengeance, on 20 July 2014 - 11:00 PM, said:

Gust Hubb, on 20 July 2014 - 04:01 PM, said:

Plus, what would we do without EmmaWatsonInABra?

Create emmawatsonwithoutabra.

Aren't you supposed to be hunting in Michigan or something?

Went up to Lake Lawn Lodge in WI on Lake Delevan. Shitty WI and zero reception... It was very nice. Except for the part where my son slept on me rather then in the middle of the bed.

How many fucking people do I have to hammer in order to get that across.
Hinter - Vengy - DIE. I trusted you you bastard!!!!!!!
Steven Erikson made drowning in alien cum possible - Obdigore