|
I hope you all had enough snacks
|
View this Thread in Original format
| Swamper |
:haha:
, 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 |
|
|
| Orbital32 |
| man i was getting full. Damn vending machine is empty now! |
|
|
| {b.s.e.} |
| how many posts are there, in total? |
|
|
| Mr.Mystery |
Damn, luckily I was at work and missed all that.
What did you do, exactly? |
|
|
| itsTrueSonic |
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..
:) |
|
|
| Mr.Mystery |
| 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 |
|
|
| Halcyon+On+On |
I'm full. :(
:haha:
Thanks, Swamper! ;) |
|
|
| Swamper |
| 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 ed 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 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. |
|
|
| Mr.Mystery |
| It's posts like that that make me glad I'm not an admin anywhere... eep :nervous: |
|
|
| Vlad |
| Del, Im fat now because of all the snacks you made me eat... I even ate the ones reserved for you. :thepirate :disbelief |
|
|
| Trance Nutter |
as per your request, I saved you some Swamper:
:D :p |
|
|
| mdamon7278 |
| YEah man time to run to the store, chocolate chip cookies are out!!! |
|
|
|
|
