Linux Format forums Forum Index Linux Format forums
Help, discussion, magazine feedback and more
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Just had a thought...
Goto page 1, 2  Next
 
Post new topic   Reply to topic    Linux Format forums Forum Index -> Off Topic
View previous topic :: View next topic  
Author Message
Bazza
LXF regular


Joined: Sat Mar 21, 2009 11:16 am
Posts: 1462
Location: Loughborough

PostPosted: Wed Nov 21, 2012 6:14 pm    Post subject: Just had a thought... Reply with quote

Does deleting all the spammers from the database cause memory leaks and/or memory fragmentation and would this be a method of attempting to cause a system crash?

Just a thought...
_________________
73...

Bazza, G0LCU...

Team AMIGA...
Back to top
View user's profile Send private message
bobthebob1234
LXF regular


Joined: Thu Jan 03, 2008 9:38 pm
Posts: 1368
Location: A hole in a field

PostPosted: Wed Nov 21, 2012 6:59 pm    Post subject: Reply with quote

Why would deleting things cause cause memory leaks and/or memory fragmentation?? Shocked

PHPBB usually runs on PHP&MySQL, last time I checked deleting things from MySQL doesn't cause memory leaks...

Updating and deleting lots can cause a little overhead on the MySQL tables, but that is very quick and easy to get rid of...
_________________
For certain you have to be lost to find the places that can't be found. Elseways, everyone would know where it was
Back to top
View user's profile Send private message
nelz
Site admin


Joined: Mon Apr 04, 2005 12:52 pm
Posts: 8365
Location: Warrington, UK

PostPosted: Wed Nov 21, 2012 7:21 pm    Post subject: Reply with quote

Also, this is a very small number of transactions, each one has to be done manually.
_________________
"Insanity: doing the same thing over and over again and expecting different results." (Albert Einstein)
Back to top
View user's profile Send private message
Bazza
LXF regular


Joined: Sat Mar 21, 2009 11:16 am
Posts: 1462
Location: Loughborough

PostPosted: Fri Nov 23, 2012 6:47 pm    Post subject: Reply with quote

Is the database not stored in RAM then for sheer speed?

It was only a passing thought, I am not a database man
but a HW oriented man instead.
_________________
73...

Bazza, G0LCU...

Team AMIGA...
Back to top
View user's profile Send private message
guy
LXF regular


Joined: Thu Apr 07, 2005 1:07 pm
Posts: 1041
Location: Worcestershire

PostPosted: Fri Nov 23, 2012 8:14 pm    Post subject: Reply with quote

It may all be loaded into RAM if it is small enough and there is enough RAM. But even so, every change (commit) must be saved to a non-volatile medium such as a hard disc, so that the system can recover it following an outage.

But you are right that deleting direct from the database can cause a crash. When say a user account is deleted directly, any post by that user will still link back to the account. and if someone views the post & clicks through, the software will probably assume that the account is still there to be linked to. If it isn't, expect the unexpected, such as a crash. Safer to delete posts & other fingerprints first, then the account. GUI tool designers tend to think of these sorts of things, so mandraulic GUIs tend to be more robust than direct database queries (e.g. allowing admins to lock the account but leaving out a "delete" button). And usually mandraulics is the only way to drive the GUI.
_________________
Cheers,
Guy
The eternal help vampire
Back to top
View user's profile Send private message
Bazza
LXF regular


Joined: Sat Mar 21, 2009 11:16 am
Posts: 1462
Location: Loughborough

PostPosted: Fri Nov 23, 2012 9:50 pm    Post subject: Reply with quote

Thanks Guy...

I am purely a hobbyist computer user and......

The only reason why I asked the question in the first place was
because of the recent attack of spammers. As I wrote earlier I
am no expert on database related stuff but I can see events
that might occur on large sized database files loaded into
memory.

By adding new spammers, then, them being deleted just
increases memory load which eventually overruns into a disk
based swapfile and/or causes system lock up or crash due to
out of memory error. Much akin to a buffer overrun, but on
a much larger scale...

Thanks a lot, you answered my question admirably.

CYA...
_________________
73...

Bazza, G0LCU...

Team AMIGA...
Back to top
View user's profile Send private message
nelz
Site admin


Joined: Mon Apr 04, 2005 12:52 pm
Posts: 8365
Location: Warrington, UK

PostPosted: Fri Nov 23, 2012 11:11 pm    Post subject: Reply with quote

guy wrote:
But you are right that deleting direct from the database can cause a crash. When say a user account is deleted directly, any post by that user will still link back to the account. and if someone views the post & clicks through, the software will probably assume that the account is still there to be linked to.


When a user is deleted their posts still appear with their username, but there is no profile link, so you can't try to view a non-existent user that way. If you load the page while they are still a user but follow the link after they have been deleted, you just get a no such user page.
_________________
"Insanity: doing the same thing over and over again and expecting different results." (Albert Einstein)
Back to top
View user's profile Send private message
1slipperyfish
Forum Jester


Joined: Mon May 09, 2005 3:52 pm
Posts: 2425
Location: wigan

PostPosted: Sat Nov 24, 2012 5:30 pm    Post subject: Reply with quote

Bazza wrote:
but a HW oriented man instead.

hard work??
paul
Back to top
View user's profile Send private message
nelz
Site admin


Joined: Mon Apr 04, 2005 12:52 pm
Posts: 8365
Location: Warrington, UK

PostPosted: Sat Nov 24, 2012 9:23 pm    Post subject: Reply with quote

1slipperyfish (troll) wrote:
hard work??


Yes, you are Razz
_________________
"Insanity: doing the same thing over and over again and expecting different results." (Albert Einstein)
Back to top
View user's profile Send private message
1slipperyfish
Forum Jester


Joined: Mon May 09, 2005 3:52 pm
Posts: 2425
Location: wigan

PostPosted: Sun Nov 25, 2012 12:51 pm    Post subject: Reply with quote

nelz wrote:
1slipperyfish (troll) (troll) wrote:
hard work??


Yes, you are Razz

sudo apt-get i'm-lost
Back to top
View user's profile Send private message
heiowge
LXF regular


Joined: Wed Feb 27, 2008 8:21 pm
Posts: 1892
Location: Cheshire, UK

PostPosted: Sun Nov 25, 2012 2:17 pm    Post subject: Reply with quote

1slipperyfish (troll) (troll) wrote:
nelz wrote:
1slipperyfish (troll) (troll) (troll) wrote:
hard work??


Yes, you are Razz

sudo apt-get i'm-lost


sudo apt-get lost.


Sorry. Couldn't resist! Twisted Evil
_________________
Dead old Dell Dimension 3000 pentium 4 processor 2GB DDR1 RAM 80GB HD. See what I'm reduced to!

eeepc 1015PX, 1.66 Ghz Intel atom processor, 2 GB DDR3, 320 GB hd, Mint 14 MATE. Fan needs fixing.
Back to top
View user's profile Send private message
1slipperyfish
Forum Jester


Joined: Mon May 09, 2005 3:52 pm
Posts: 2425
Location: wigan

PostPosted: Mon Nov 26, 2012 5:12 pm    Post subject: Reply with quote

heiowge wrote:
1slipperyfish (troll) (troll) (troll) wrote:
nelz wrote:
1slipperyfish (troll) (troll) (troll) (troll) wrote:
hard work??


Yes, you are Razz

sudo apt-get i'm-lost


sudo apt-get lost.


Sorry. Couldn't resist! Twisted Evil

that's what i said but these pesky moderators keep changing my posts Mad
paul
Back to top
View user's profile Send private message
Dutch_Master
LXF regular


Joined: Tue Mar 27, 2007 2:49 am
Posts: 2422

PostPosted: Mon Nov 26, 2012 5:53 pm    Post subject: Reply with quote

Gee, I wonder why.... Rolling Eyes

It was so nice and quiet here with you absent fishy one, what have we done wrong to get you back? Or rather: what went wrong elsewhere that made you come back, gotten your ar*e kicked around in that place? Twisted Evil
Back to top
View user's profile Send private message
Rhakios
Moderator


Joined: Thu Apr 07, 2005 12:18 am
Posts: 7602
Location: Midlands, UK

PostPosted: Mon Nov 26, 2012 7:34 pm    Post subject: Reply with quote

Dutch_Master wrote:
Gee, I wonder why.... Rolling Eyes

It was so nice and quiet here with you absent fishy one, what have we done wrong to get you back? Or rather: what went wrong elsewhere that made you come back, gotten your ar*e kicked around in that place? Twisted Evil


Surely you noticed that 1sf (troll) reappeared just around the time of the spam flood? Coincidence? I think not!


Wink
_________________
Bye, Rhakios
Back to top
View user's profile Send private message
1slipperyfish
Forum Jester


Joined: Mon May 09, 2005 3:52 pm
Posts: 2425
Location: wigan

PostPosted: Mon Nov 26, 2012 7:46 pm    Post subject: Reply with quote

yo dm always a pleasure Razz i haven't been anywhere else but here Confused where i belong Very Happy
Back to top
View user's profile Send private message
View previous topic :: View next topic  
Display posts from previous:   
Post new topic   Reply to topic    Linux Format forums Forum Index -> Off Topic All times are GMT
Goto page 1, 2  Next
Page 1 of 2

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Linux Format forums topic RSS feed 


Powered by phpBB © 2001, 2005 phpBB Group


Copyright 2011 Future Publishing, all rights reserved.


Web hosting by UKFast