Forum going down for maintenance in 2 hours

Manuel the White · Post by **Manuel the White** » Thu Mar 03, 2005 2:28 am

The forum will be temporarily down for maintenance as I perform a full reindexing of the searching tables. Once complete, all posts prior to migration will be searchable again. In fact, some that were lost during our last website migration will also magically reappear in our search results.

The process may take a long time to complete. Given the size of the database, it may drag on for several hours. The size of the database will also increase dramatically during this time. This should not affect the speed of the server too much. However, searches that take a long time will cause additional overhead.

Use your brain and REFINE YOUR SEARCHES.

Tharliss · Post by **Tharliss** » Fri Mar 04, 2005 3:53 pm

wOOt! First Post!

Thanks Manuel!

*Starts searching*

Post by **Nighthawk4** » Fri Mar 04, 2005 3:55 pm

Wow, Manuel - I hope you didn't have to sit and watch the re-indexing for all that time.

Thanks - good to be back.

*Hugs Website*

Final Shinryuu · Post by **Final Shinryuu** » Fri Mar 04, 2005 3:57 pm

*kisses the monitor*
I've missed you, sweetie.

Heronimous Fox · Post by **Heronimous Fox** » Fri Mar 04, 2005 3:57 pm

*PANTS*

Krator · Post by **Krator** » Fri Mar 04, 2005 3:58 pm

Aerill · Post by **Aerill** » Fri Mar 04, 2005 3:59 pm

Yesss!! Wooohooo!

VETT SCALES L7 · Post by **VETT SCALES L7** » Fri Mar 04, 2005 4:00 pm

Thanks Manuel!!!!!

Marijn · Post by **Marijn** » Fri Mar 04, 2005 4:01 pm

Yay! Thanx!

Significant Owl · Post by **Significant Owl** » Fri Mar 04, 2005 4:01 pm

YEEEEEESSSSSS!!!

PsiOmega · Post by **PsiOmega** » Fri Mar 04, 2005 4:01 pm

Cheers!

Talwin Hawkins · Post by **Talwin Hawkins** » Fri Mar 04, 2005 4:03 pm

Yarr!

Manuel the White · Post by **Manuel the White** » Fri Mar 04, 2005 4:06 pm

I'm glad it's back up too. I was afraid a lynch mob may have been forming. Darn sure you weren't going to find me in IRC!

Yes, it took longer than anticipated. With the overnight failure, I lost about 6 or 7 hours right there. But the real issue was that, initially the script was running at a goodly rate. As the search index tables got larger, the script began to take longer and longer to do the rebuild functions (which it had to do around 12,000 times). There's a big diference between 2 seconds and 17 seconds when we're talking about that many increments.

I also found out what caused the tables to fail to import during webiste migration (duplicate keys likely due to server lag) and blew them away. In the future, I will be optimizing the search tables using various forms of logic. This will trim down the size and speed up search results with minimal impact on results returned.

Have a great weekend,

- Manuel

Snow · Post by **Snow** » Fri Mar 04, 2005 4:10 pm

Thanks Manuel!

ReallyStupidGuy · Post by **ReallyStupidGuy** » Fri Mar 04, 2005 4:19 pm

Yay! The board is back! My life is so ruined without the boards and without Avlis or without just one of the two

tygermoon · Post by **tygermoon** » Fri Mar 04, 2005 4:25 pm

*cheers* Thank you, thank you, Manuel!

And BTW, in case someone didn't say it before... the post you put up, last night was pretty funny.

Final Shinryuu · Post by **Final Shinryuu** » Fri Mar 04, 2005 4:29 pm

Manuel the White wrote:I'm glad it's back up too. I was afraid a lynch mob may have been forming. Darn sure you weren't going to find me in IRC!

Yes, it took longer than anticipated. With the overnight failure, I lost about 6 or 7 hours right there. But the real issue was that, initially the script was running at a goodly rate. As the search index tables got larger, the script began to take longer and longer to do the rebuild functions (which it had to do around 12,000 times). There's a big diference between 2 seconds and 17 seconds when we're talking about that many increments.

I also found out what caused the tables to fail to import during webiste migration (duplicate keys likely due to server lag) and blew them away. In the future, I will be optimizing the search tables using various forms of logic. This will trim down the size and speed up search results with minimal impact on results returned.

Have a great weekend,

- Manuel

I don't understand what all this means...but...
Thank you?
(does that make sense in the context of his post?)

Err... barring that,
WE LOVE YOU!

Manuel the White · Post by **Manuel the White** » Fri Mar 04, 2005 9:04 pm

I guess the reindex worked. I can search all the way back to..

Posted: Sat Sep 22, 2001 9:27 am

Orleron

I moved all the Avlis stuff from the old board to here. Lots and lots of cut and paste. But at least now this board is useable from a context perspective.

And that's a long time ago indeed.

Post by **Nighthawk4** » Fri Mar 04, 2005 9:20 pm

*Dismisses Lynch Mob*

OK guys, another time perhaps.

Seriously, thanks a lot Manuel. It was Hell, but we got through it - a little IRC, a little RL, we managed to survive.