Quoting Post Topic Damaged Topics & Replies Membername   Not a member? Sign Up Free (takes 20 seconds) Password   Forgotten your password? Post Font: Verdana Arial Black Georgia Comic Sans Impact   Size: Tiny Normal Big Huge   Color: Default Dark Red Red Orange Brown Green Olive Cyan Blue Dark Blue Indigo Black [ Check Spelling ] [ Post Preview ] [ LiveTags ] Quote: from [m]i who have nothing[/m] at 10:20 am on June 20, 2008[quote]Get some better database software yo.  Where do all those advertising dollars go?[/quote] FAQ Keyword Search: Post Options Favorites Manager Notify me of new replies to this topic by email Notify me of new replies to this topic by private message Original Post davjs Posted at 10:18 am on June 20, 2008 Replies are stored in 16 database tables, the 16th and most recent of which recently became corrupted and I had to delete a large number of those replies.   The issue is that we now have millions upon millions of replies. The database software (MySQL) is not adept at handling so many entries and occasionally begins writing them incorrectly. When this happens, and it has happened before, I have no choice but to delete those duplicate entries. To "recover" the replies I would have to read each reply and guess which topic they belonged to. I only deleted replies that appeared more than once in the database, so in most cases one reply will still remain. However, it does seem that many topics remain damaged. My heart goes out to those of you applying to become support leaders who may have lost some of your application material. We store the replies in merge tables, so mysql reads 16 separate tables as if they were one table. It makes it possible for mysql to read them more efficiently (read faster and without crashing the server). However, merge tables are prone to corruption. This is not a coding issue. I have repaired the damaged database tables over the course of 2 days because the operations were so tedious and time consuming when dealing with 13 million replies.

Replies purplescoober222 Posted at 7:18 am on July 24, 2008 ok thanks for explaining what went wrong insteasd of "too bad kid" and thanks for fixing it sweetsimba Posted at 4:56 pm on June 27, 2008 this is really frustrating. the topics that were fine a few weeks have been corrupted and moderators are complaining me about spaming when its contentes are not mine. At a life threatening situation i had made that topics, i was visiting them regularly for releving strees. It is unexplainable to put in words that the topics were corrupted, its contents are not mine when i was eagerly waiting for its recovery, suddenly mods complaining it is spaming. they can at least check out for bug report be4 complaining, can't they?? It really cause intense unpredicable emotions, can't put in words. Also u should now better manage to avoid future fall. It may lead somebody to suicide because of fucking software. Are u getting what i say?? im rockin the etnies Posted at 5:51 pm on June 21, 2008 great job on fixing it and thanks. this happened while i was gone so i had no knowledge of it till now Define Your Line Posted at 5:51 pm on June 21, 2008 Lol, Pretty much all of my topics are EXTREMELY messed. Are they going to stay like that or will they be removed? lunchbox Posted at 3:13 pm on June 21, 2008 Quote: from i who have nothing at 3:45 pm on June 20, 2008 Quote: from lunchbox at 6:06 pm on June 20, 2008 Quote: from i who have nothing at 10:20 am on June 20, 2008 Get some better database software yo.  Where do all those advertising dollars go? umm i dont think theres a better software the SQL... especialy with this type of aplacation that needs a database. There's database software that costs money and is much better equipped to handle large amounts of data.  Think of Youtube or Google and all the info they put in there compared to LW and their shiz doesn't crash. cant arguee with that, but those are multi-million dolar componies.... also, they higher their programers. I am sure the databases they have are self programed....... i doubt davjs has 500k to shell out on a fucking db Innuendo Girl Posted at 1:37 pm on June 21, 2008 hey can i just have all my topics that were corrupted deleted? Praise the Lard Posted at 12:25 pm on June 21, 2008 Quote: from Briley 07 at 12:18 pm on June 20, 2008 I lost 2 SL replies completly, and one is in a topic of it's own, so I dunno if it can be accepted, free SL status David? same Jasonzlpa Posted at 9:27 pm on June 20, 2008 k, thx for fixing it. 4est Posted at 9:18 pm on June 20, 2008 Quote: from Briley 07 at 12:18 pm on June 20, 2008 I lost 2 SL replies completly, and one is in a topic of it's own, so I dunno if it can be accepted, free SL status David? Yeah, uhh, me too. ElfQrin Posted at 6:34 pm on June 20, 2008 That sucks, but thanks for spending the time to get things back up and running smoothly, David! Brookie Chookie23 Posted at 6:29 pm on June 20, 2008 Quote: from The Bastard at 3:00 am on June 21, 2008 David Jones, I no longer have any expectations of you anymore. A redundant sentence. marshmellowman Posted at 5:47 pm on June 20, 2008 TY Emma, you're too kind, srsly. Corrupted Innocence Posted at 5:46 pm on June 20, 2008 Quote: from marshmellowman at 1:45 am on June 21, 2008 Quote: from Briley 07 at 8:18 pm on June 20, 2008 I lost 2 SL replies completly, and one is in a topic of it's own, so I dunno if it can be accepted, free SL status David? TWO? I lost like TEN FREAKING replies. It's basically delayed my whole application a by a week or two. Grrrrrr. I feel bad for you, as you give awesome advice to be honest. Well lets hope you get it soon. marshmellowman Posted at 5:45 pm on June 20, 2008 Quote: from Briley 07 at 8:18 pm on June 20, 2008 I lost 2 SL replies completly, and one is in a topic of it's own, so I dunno if it can be accepted, free SL status David? TWO? I lost like TEN FREAKING replies. It's basically delayed my whole application a by a week or two. Grrrrrr. hithere Posted at 5:42 pm on June 20, 2008 are you sure you had to delete so much? all my topics created more than about a month ago were fine...you ruined all of them going back like an entire year, wtfffffff Most recent 15 of 39 previous replies displayed.