Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » General » Database discussions » Holes in MYSQL Databases?
Show: Today's Messages :: Unread Messages :: Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
icon6.gif  Holes in MYSQL Databases? [message #162221] Fri, 09 April 2010 00:17 Go to next message
The Witcher is currently offline  The Witcher   United States
Messages: 673
Registered: May 2009
Location: USA
Karma: 3
Senior Member
add to buddy list
ignore all messages by this user
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!"
Message by Ernesto is ignored  [reveal message]  [reveal all messages by Ernesto]  [stop ignoring this user] Go to previous messageGo to next message
Re: Holes in MYSQL Databases? [message #169345 is a reply to message #162780] Sat, 28 September 2013 04:38 Go to previous message
charleshbrenner is currently offline  charleshbrenner
Messages: 1
Registered: September 2013
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Thanks for the details. I like the post. Smile
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: mssql 2012
Next Topic: slave database mysql
Goto Forum:

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 20 00:49:55 EDT 2021

Total time taken to generate the page: 0.00594 seconds