FUDforum: Database discussions » Holes in MYSQL Databases?

Home » General » Database discussions » Holes in MYSQL Databases?

Show: Today's Messages :: Polls :: Message Navigator

Holes in MYSQL Databases? [message #162221]

Fri, 09 April 2010 04:17

The Witcher

Messages: 675
Registered: May 2009
Location: USA

Karma:

Senior Member

Had a long discussion with a young man today who explained quite emphatically that by deleting posts and or users (even move/split and merge operations) in a forum (any forum), left "holes" in the database which would eventually make the system unstable and crash.

Off hand I am quite dubious about his claim, primarily since he did not seem able to even match my own meager knowledge about MYSQL; though I have heard such claims before I have never placed much faith in them.

As I understand it MYSQL is not all that much different than any other database in that it has tables, fields, cells, columns and rows in which data is stored, retrieved and or manipulated.

And as I understand it, running Forum Consistency, Rebuild Search Index, and Compact Messages prevents the Database from being adversely affected by the above actins!

Could someone please clarify this for me?

"I'm a Witcher, I solve human problems; not always using a sword!"

Report message to a moderator

[Message index]

		Holes in MYSQL Databases? By: The Witcher on Fri, 09 April 2010 04:17
		Re: Holes in MYSQL Databases? By: Ernesto on Thu, 15 July 2010 11:16
		Re: Holes in MYSQL Databases? By: charleshbrenner on Sat, 28 September 2013 08:38

Previous Topic:	mssql 2012
Next Topic:	slave database mysql

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 18:35:30 GMT 2024

Total time taken to generate the page: 0.04953 seconds