I hope you all had enough snacks - TranceAddict Forums

TranceAddict Forums (www.tranceaddict.com/forums)
- Chill Out Room
-- I hope you all had enough snacks

Posted by Swamper on Nov-09-2004 03:04:

I hope you all had enough snacks

Fuck, sorry that took so long, it started doing the repair at 1000 posts a second, but, that slowed down to about 300 a second once it got past the 2+ million mark

Posted by Orbital32 on Nov-09-2004 03:05:

man i was getting full. Damn vending machine is empty now!

Posted by {b.s.e.} on Nov-09-2004 03:05:

how many posts are there, in total?

Posted by Mr.Mystery on Nov-09-2004 03:09:

Damn, luckily I was at work and missed all that.
What did you do, exactly?

Posted by itsTrueSonic on Nov-09-2004 03:10:

i had fried rice for dinner.
i ate it all.
sorry swamper.

i still do have the bowl with me, if anyone wants to lick the taste off the fried rice..

Posted by Mr.Mystery on Nov-09-2004 03:15:

quote:
Originally posted by {b.s.e.}
how many posts are there, in total?

Registered Members: 40,414
200,650 threads in total | 3,356,972 posts in total

Posted by Halcyon+On+On on Nov-09-2004 03:16:

I'm full.

Thanks, Swamper!

Posted by Swamper on Nov-09-2004 03:18:

quote:
Originally posted by Mr.Mystery
Damn, luckily I was at work and missed all that.
What did you do, exactly?

I had to repair the post table in the database - the quick way to do this is to remove the index on posts and titles, then repair (much less data to sift through) - but - it was so fucked that I couldn't even get to that point -- so I was forced to do the repair with the indicies in place - which took 4.5 hours. The quick method would have been done in 20 minutes.

I just upgraded to MySQL 4.1 and it has some nifty features which I haven't put into place yet, mainly that there is new caching available (beyond the standard query cache) to speed up the retrieval of data. Now, besides having nifty new features, it was also reported to have some bugs with the implementation of fulltext indicies (what I use to have search work so much faster now) - so, that shit ended up corrupting my tables.

I upgraded to a development version of the forums released last night, not recommended for production use - but - the changelog says that some issues I had were resolved so it's best to use that than to resort to a version that has already caused me enough friggin grief for a Monday.

Posted by Mr.Mystery on Nov-09-2004 03:20:

It's posts like that that make me glad I'm not an admin anywhere... eep

Posted by Vlad on Nov-09-2004 03:22:

Del, Im fat now because of all the snacks you made me eat... I even ate the ones reserved for you.

Posted by Trance Nutter on Nov-09-2004 03:23:

as per your request, I saved you some Swamper:

Posted by mdamon7278 on Nov-09-2004 03:46:

YEah man time to run to the store, chocolate chip cookies are out!!!

Posted by fastmp3 on Nov-09-2004 03:47:

Swamper : lifetime supply of poutine for you !

Posted by trancebrat on Nov-09-2004 04:47:

I had Oreo ice cream as my snack! Brain freeze! Thanks Swamper!

Posted by DannyO on Nov-09-2004 04:56:

Dam I ate alot of biscuits and other crap.....now I'm gonna sue TA for making me fat, I'll tell the court it wasn't my fault, the text on my screen kept telling me to eat.

Anyway, Thanks Swamper, always grateful for this site, without it, I'd get rid of highspeed, and would be lost without the DJ Booth.

So BIG UP TO MA MAIN MAN, SWAMPY......F F FRESH

Posted by Omegasox on Nov-09-2004 05:32:

Del, you're the man! You need to put up a donate button for all the time you put in.

Posted by trancebrat on Nov-09-2004 05:43:

quote:
Originally posted by Omegasox
Del, you're the man! You need to put up a donate button for all the time you put in.

I agree. I see nothing wrong with doing that.

Posted by limin_li on Nov-09-2004 05:54:

ah swamper, always give give give give. Your return is being buddies with Johan Gielen, Max Gram, Filo and Peri, Ralphie B, Gaberial and Dresden just name a few. I guess that 56k mp3 leech site of yours finally paid off. Oh yeah, you remember those days on efnet #dancemp3. I am sure as hell I did.

Good Times

Posted by D-res on Nov-09-2004 06:07:

yaaay swamper!!!11111 seven million and six eighths seven million and six eighths seven million and six eighths seven million and six eighths

i didnt eat much but it was fun hitting refresh and seeing the different messages.

Posted by Swamper on Nov-09-2004 06:28:

quote:
Originally posted by limin_li
ah swamper, always give give give give. Your return is being buddies with Johan Gielen, Max Gram, Filo and Peri, Ralphie B, Gaberial and Dresden just name a few. I guess that 56k mp3 leech site of yours finally paid off. Oh yeah, you remember those days on efnet #dancemp3. I am sure as hell I did.
Good Times

Ahhhh..memories of 1997-1998 Sup man? Those were fun times, and, I still have all those poorly encoded tunes from way back.. It was long before napster, and I still remember in 96 when someone sent me on there or #eurodance sent me Dune - Million Miles Away from Home in .mp2 format and I played it on Winplay nonstop for weeks, lol.

Retro

Posted by D-res on Nov-09-2004 06:33:

quote:
Originally posted by Swamper

Retro

Posted by JM on Nov-09-2004 06:43:

quote:
Originally posted by Swamper
I had to repair the post table in the database - the quick way to do this is to remove the index on posts and titles, then repair (much less data to sift through) - but - .....

the wording tailored so even an 11 year old would understand this computer terminology, but i'm lost

haha...oh well.... as long as everything is working alright.

>JM<