LiveWire Network Peer Answers Peer Support Teen Forums Tech Forums College Forums 644 users online 223038 members 1290 active today Advertise Here Sign In
TeenCollegeTechPhotos | Quizzes | LiveSecret | Memberlist | Dictionary | News | FAQ
Member Spotlight
Christ 1980
Music: guns and roses and old school rock
Mood: Paranoid
You have 1 new message.
Emergency Help
Until you sign up you can't do much. Yes, it's free.

Sign Up Now
Membername:
Password:
Already have an account?
► Invite Friends
► Active Members
► Groups
► Contests
Moderators
5 online / 31 MPM
Fresh Topics
  LiveWire / Teen Forums / Announcements / Viewing Topic

Damaged Topics & Replies
Replies: 39 — Last Post July 24, 2008 7:18am by purplescoober222
Welcome to LiveWire!
We're Stronger Together. 		Join the Community
Pages: 1 2 3  Next » Email Print Favorite
( davjs )


Yeah LiveWire!
Patron
Support Leader 		Reply
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.

-------
Currently traveling in France

10:18 am on June 20, 2008 | Joined: Dec. 2000 | Days Active: 2,161
Join to learn more about davjs France | Male | Posts: 5,258 | Points: 66,849
LiveWire Humor
bluskypeChris


Dairy Product Addict 		Reply
Koolio

-------
Holding on to hope!
10:19 am on June 20, 2008 | Joined: April 2008 | Days Active: 132
Join to learn more about bluskypeChris California, United States | Posts: 2,282 | Points: 3,541
i who have nothing


Executive
Patron 		Reply
Get some better database software yo.  Where do all those advertising dollars go?
10:20 am on June 20, 2008 | Joined: Mar. 2008 | Days Active: 119
Join to learn more about i who have nothing Ontario, Canada | Straight Male | Posts: 2,559 | Points: 3,473
OverTheAir


jebi se
Patron 		Reply
Urgg can all my messed up topics just be deleted?

-------
"A wise girl kisses but doesn't love,
listens but doesn't believe,
and leaves before she is left"
-Marilyn Monroe
10:20 am on June 20, 2008 | Joined: Jan. 2004 | Days Active: 1,026
Join to learn more about OverTheAir Massachusetts, United States | Label Free Female | Posts: 32,434 | Points: 50,506
Aphrodite54


March 14th
Patron
Support Leader 		Reply
Ok, well thanks for fixing it.
And thanks for explaining what went wrong :)

54

-------
Join My LW Family! :D

10:21 am on June 20, 2008 | Joined: Aug. 2007 | Days Active: 643
Join to learn more about Aphrodite54 Cyprus | Female | Posts: 10,495 | Points: 30,497
Rowanie

Professional
Patron 		Reply
Thanks.
Does that mean it might happen again?
Can't you get a better program?

-------
I sing - But you can't speak
I laugh - But you can't smile
I love - But you lie low
10:25 am on June 20, 2008 | Joined: June 2008 | Days Active: 78
Join to learn more about Rowanie Wales | Straight Female | Posts: 1,529 | Points: 2,131
coloring the void

Connoisseur
Patron 		Reply
Quote: from OverTheAir at 10:20 am on June 20, 2008
Urgg can all my messed up topics just be deleted?

Psh, NO! They sound so funny. :P

10:25 am on June 20, 2008 | Joined: April 2008 | Days Active: 309
Join to learn more about coloring the void Togo | Posts: 4,831 | Points: 7,745
acausedelle

Swami
Patron 		Reply
Cool. Maybe find a better application for that?

-------
We can live beside the ocean
Leave the fire behind
Swim out past the breaker
Watch the world die
10:27 am on June 20, 2008 | Joined: June 2006 | Days Active: 594
Join to learn more about acausedelle Wisconsin, United States | Bisexual Male | Posts: 23,053 | Points: 29,684
BubbleCake


l♥l
Sustainer
Support Leader 		Reply
So, will all the messed up topics and replies be fixed? Or just stay the way they are?

Post edited at 10:29 am on June 20, 2008 by BubbleCake

10:29 am on June 20, 2008 | Joined: June 2007 | Days Active: 831
Join to learn more about BubbleCake Christmas Island | Female | Posts: 15,671 | Points: 32,857
The Bastard

Novice 		Reply
David Jones, I no longer have any expectations of you anymore.
10:30 am on June 20, 2008 | Joined: June 2008 | Days Active: 4
Join to learn more about The Bastard United States | Posts: 324 | Points: -636
Daleacus


Maybe if we snuck up on it...
Patron 		Reply
It may be annoying, but, thanks for putting the effort in to fix it, as always.

-------
If you still care, don't ever let me know
10:33 am on June 20, 2008 | Joined: Oct. 2004 | Days Active: 1,432
Join to learn more about Daleacus United KingdOm | Straight Male | Posts: 10,498 | Points: 39,892
Autumndaze



Patron 		Reply
Quote: from davjs at 1:18 pm on June 20, 2008
My heart goes out to those of you applying to become support leaders who may have lost some of your application material.

At least the bug is being fixed so we won't have to worry about our newer replies being trashed.



-------
Happy Halloween!
http://www.youtube.com/watch?v=N9_6IODy0mU

10:37 am on June 20, 2008 | Joined: Nov. 2007 | Days Active: 664
Join to learn more about Autumndaze Germany | Posts: 6,077 | Points: 30,022
hateitandloveit


Soothsayer 		Reply
Try HS for MySQL scalability tips:
http://highscalability.com/tags/mysql

Or use PostgreSQL if your database is abstracted (by means of any Perl MVC system or something.)

-------
to die by your side
is such a heavenly way to die.

10:41 am on June 20, 2008 | Joined: Jan. 2008 | Days Active: 335
Join to learn more about hateitandloveit Massachusetts, United States | Straight Male | Posts: 6,796 | Points: 12,075
4est


Oh, Mr. Darcy!
Patron
Tech Support Leader 		Reply
Quote: from hateitandloveit at 10:41 am on June 20, 2008
Try HS for MySQL scalability tips:
http://highscalability.com/tags/mysql

Or use PostgreSQL if your database is abstracted (by means of any Perl MVC system or something.)

He's Asian, so he must know his shit.

-------
In vain I have struggled. It will not do. My feelings will not be repressed.

You must allow me to tell you how ardently I admire and love you.
11:43 am on June 20, 2008 | Joined: July 2005 | Days Active: 979
Join to learn more about 4est South Africa | Label Free | Posts: 23,094 | Points: 36,146
audrey820


what's this empty box??
Patron
Support Leader 		Reply
Suckssssss, but you had to do what you had to do. Don't sound so guilty about it!

-------
kid, I wrote back,
all lovers betray.
11:58 am on June 20, 2008 | Joined: Aug. 2004 | Days Active: 1,408
Join to learn more about audrey820 Massachusetts, United States | Female | Posts: 23,541 | Points: 44,800
Pages: 1 2 3  Next » Email Print Favorite

Quick Reply

You are signed in as our guest.

Looking for something else?
 

  LiveWire / Teen Forums / Announcements / Viewing Topic

© 2000-2009 LiveWire Peer Support Network
Custom Web Hosting | Teen Advice | Peer Support