LiveWire Network Peer Answers Peer Support Teen Forums Tech Forums College Forums 402 users online 210982 members 1710 active today Advertise Here Sign In
TeenCollegeTechPhotos | Quizzes | LiveSecret | Memberlist | Dictionary | News | FAQ
Member Spotlight
Feel The High
My facebook. My myspace. My YouTube.
Mood: Euphoric
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
3 online / 38 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 )


1 New Alert
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 studying Italian in Italy

10:18 am on June 20, 2008 | Joined: Dec. 2000 | Days Active: 2,073
Join to learn more about davjs Italy | Male | Posts: 5,179 | Points: 62,398
bluskypeChris


Dairy Product Addict 		Reply
Koolio

-------
Holding on to hope!
10:19 am on June 20, 2008 | Joined: April 2008 | Days Active: 107
Join to learn more about bluskypeChris California, United States | Posts: 2,019 | Points: 3,028
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
Support Leader 		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: 923
Join to learn more about OverTheAir Massachusetts, United States | Label Free Female | Posts: 31,434 | Points: 46,102
Kanenas54


March 14th
Sustainer
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: 545
Join to learn more about Kanenas54 Cyprus | Female | Posts: 9,677 | Points: 30,784
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,530 | Points: 2,132
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,832 | Points: 7,746
im with stupid


Swami
Sustainer
Support Leader 		Reply
Cool. Maybe find a better application for that?

-------
Previously known as Enrapture who was previously known as im with stupid.
Number of words in my blog: 69,402
10:27 am on June 20, 2008 | Joined: June 2006 | Days Active: 475
Join to learn more about im with stupid Wisconsin, United States | Asexual Male | Posts: 21,444 | Points: 26,950
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

-------
"Our greatest weakness lies in giving up. The most certain
way to succeed is always to try just one more time."
- Thomas Edison

10:29 am on June 20, 2008 | Joined: June 2007 | Days Active: 692
Join to learn more about BubbleCake Michigan, United States | Straight Female | Posts: 15,164 | Points: 31,203
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,288
Join to learn more about Daleacus United KingdOm | Straight Male | Posts: 10,355 | Points: 36,780
Autumndaze


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



-------
"Boys won't listen."
"All they want to do is talk!"

10:37 am on June 20, 2008 | Joined: Nov. 2007 | Days Active: 525
Join to learn more about Autumndaze Ireland | Female | Posts: 5,735 | Points: 30,045
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.)

-------
lol signature

10:41 am on June 20, 2008 | Joined: Jan. 2008 | Days Active: 307
Join to learn more about hateitandloveit Massachusetts, United States | Straight Male | Posts: 6,653 | Points: 11,644
4est


Rockin' the Suburbs
Patron 		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.

-------
I'd rather be on /b/.
11:43 am on June 20, 2008 | Joined: July 2005 | Days Active: 905
Join to learn more about 4est British Columbia, Canada | Metrosexual Male | Posts: 18,318 | Points: 30,812
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,267
Join to learn more about audrey820 Massachusetts, United States | Female | Posts: 22,627 | Points: 40,545
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