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

___________________

"In a world of illusion you only see what you feel"

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

how many posts are there, in total?

___________________
Wave is to particle as zero is to one as bagpipes are to modem noises.

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

___________________
Latest releases:
Endless Cycles [Capital Heaven]
The Charlatan [Morphosis]

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

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

___________________
Latest releases:
Endless Cycles [Capital Heaven]
The Charlatan [Morphosis]

I'm full.



Thanks, Swamper!

___________________
There are more things in heaven and earth, Horatio,
Than are dreamt of in your philosophy.

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.

___________________

"In a world of illusion you only see what you feel"

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

___________________
Latest releases:
Endless Cycles [Capital Heaven]
The Charlatan [Morphosis]

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

___________________
/SARCASM.

quote:

Originally posted by Coup Vlad wins. Flawless victory.

as per your request, I saved you some Swamper:

___________________
**Man I'm Pretty**

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

___________________
"Do not dwell in the past, do not dream of the future, concentrate
the mind on the present moment"