Page 1 of 2

Just had a thought...

PostPosted: Wed Nov 21, 2012 6:14 pm
by Bazza
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...

PostPosted: Wed Nov 21, 2012 6:59 pm
by bobthebob1234
Why would deleting things cause cause memory leaks and/or memory fragmentation?? :shock:

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...

PostPosted: Wed Nov 21, 2012 7:21 pm
by nelz
Also, this is a very small number of transactions, each one has to be done manually.

PostPosted: Fri Nov 23, 2012 6:47 pm
by Bazza
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.

PostPosted: Fri Nov 23, 2012 8:14 pm
by guy
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.

PostPosted: Fri Nov 23, 2012 9:50 pm
by Bazza
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...

PostPosted: Fri Nov 23, 2012 11:11 pm
by nelz
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.

PostPosted: Sat Nov 24, 2012 5:30 pm
by 1slipperyfish
Bazza wrote: but a HW oriented man instead.

hard work??
paul

PostPosted: Sat Nov 24, 2012 9:23 pm
by nelz
1slipperyfish wrote:hard work??


Yes, you are :P

PostPosted: Sun Nov 25, 2012 12:51 pm
by 1slipperyfish
nelz wrote:
1slipperyfish (troll) wrote:hard work??


Yes, you are :P

sudo apt-get i'm-lost

PostPosted: Sun Nov 25, 2012 2:17 pm
by heiowge
1slipperyfish (troll) wrote:
nelz wrote:
1slipperyfish (troll) (troll) wrote:hard work??


Yes, you are :P

sudo apt-get i'm-lost


sudo apt-get lost.


Sorry. Couldn't resist! :twisted:

PostPosted: Mon Nov 26, 2012 5:12 pm
by 1slipperyfish
heiowge wrote:
1slipperyfish (troll) (troll) wrote:
nelz wrote:
1slipperyfish (troll) (troll) (troll) wrote:hard work??


Yes, you are :P

sudo apt-get i'm-lost


sudo apt-get lost.


Sorry. Couldn't resist! :twisted:

that's what i said but these pesky moderators keep changing my posts :x
paul

PostPosted: Mon Nov 26, 2012 5:53 pm
by Dutch_Master
Gee, I wonder why.... :roll:

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:

PostPosted: Mon Nov 26, 2012 7:34 pm
by Rhakios
Dutch_Master wrote:Gee, I wonder why.... :roll:

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:


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


:wink:

PostPosted: Mon Nov 26, 2012 7:46 pm
by 1slipperyfish
yo dm always a pleasure :P i haven't been anywhere else but here :? where i belong :D