Subeta -

December 28, 2009 11:52 pm

<center>

Hello everyone! Our weekly maintenance window is tonight, and we'll be doing some optimization of our database. The whole process will take upwards of two hours, and we expect to begin sometime around 1 or 1:30 am Subeta time.

For the curious, we are replacing our live database with an optimized version that's only a third the size. This is necessary because our database is getting so big that it soon won't fit on the drives we have for it. We'll be backing up the old database, of course, to make sure nothing bad happens if something goes wrong.

I will try to post updates throughout the downtime to let you guys know how things are going.

Wish us luck!

-Alex

December 31, 1969, 7:00 pm by

Good Luck !!!!!!!!!!!!!!

December 31, 1969, 7:00 pm by

Thanks for the response Alex --- yes it does make sense!

December 31, 1969, 7:00 pm by

I made my HA look like alx

December 31, 1969, 7:00 pm by

DaBluMeanie: It would. Actually, across the whole database, forum posts only amount to 1-2% of space used, so it wouldn't be that big a help.

Also, one peculiar thing about databases: deleting stuff doesn't shrink them. It simply creates "empty space" in the database that is then filled with new data as it's added. In other words, databases only grow, never shrink.

Since we needed ours to shrink, what we've actually done is dumped all the data out, and reimported it, getting rid of the empty space regions. This is the "optimized" database we're switching to tonight.

Make sense?

December 31, 1969, 7:00 pm by

Toot!

December 31, 1969, 7:00 pm by

Good luck!!!!

December 31, 1969, 7:00 pm by

best of luck!

December 31, 1969, 7:00 pm by

there are forum posts that are over 2 years old --- won't deleting them free up space?

December 31, 1969, 7:00 pm by

Have at it Alex. You can do it!

December 31, 1969, 7:00 pm by

Knock on wood and good luck!

December 31, 1969, 7:00 pm by

: lol! lots of luck doesn't hurt though, does it?

December 31, 1969, 7:00 pm by

Thanks for the update. Good luck to all!

December 31, 1969, 7:00 pm by

best of luck

December 31, 1969, 7:00 pm by

Good luck and thanks for letting us know.

December 31, 1969, 7:00 pm by

Good luck =)

December 31, 1969, 7:00 pm by

good luck! Hopefully everything will go smoothly

December 31, 1969, 7:00 pm by

Thanks for the update, I wish you the best of luck! Not sure if I can survive TWO WHOLE HOURS without Subeta, but I'll try xD

December 31, 1969, 7:00 pm by

ah poo that's when I like to be active. T_T; Oh well, good luck! Hopefully it ends on time (or earlier) and there's no problems.

December 31, 1969, 7:00 pm by

Darn, with no subeta it looks like I will need to go to bed tonight. GOOD LUCK!! I HOPE EVERYTHING GOES WELL!

December 31, 1969, 7:00 pm by

Good luck! hope it goes well & thanks for the update.

December 31, 1969, 7:00 pm by

Woot uptade!!!!!!!1 GO GO GO!!!!!!!!!1

GOOD LIKE Subeta Staff!!!!!!!!!!1 Make everything 1337!!!!!1 (for anyone who does not know what that is then google it noob).

December 31, 1969, 7:00 pm by

Aww

December 31, 1969, 7:00 pm by

yay ^^ good luxk, I love how you guys keep us in the loop

December 31, 1969, 7:00 pm by

Good luck! And thank you for all you do to keep Subeta awesome!

December 31, 1969, 7:00 pm by

Wishing you luck, and thank for the update, now I have to find something else to do

December 31, 1969, 7:00 pm by

Good luck guys~ C:

December 31, 1969, 7:00 pm by

Oh sweet geez. Two hours is a long time. But good luck anyhoo. :c

December 31, 1969, 7:00 pm by

Thanks for the update and for everything.

Good luck!

December 31, 1969, 7:00 pm by

GOOD LUCK! :HEART:

December 31, 1969, 7:00 pm by

LOL. Not sure I like it when something ends with, "wish us luck." I'll just say, Have a good time! heehee

December 31, 1969, 7:00 pm by

crosses fingers Here's to luck!

December 31, 1969, 7:00 pm by

Hope everything goes well. Thanks for all that you guys do!

December 31, 1969, 7:00 pm by

oh no, no subeta......how long we talking?

December 31, 1969, 7:00 pm by

good luck hun!

December 31, 1969, 7:00 pm by

Good luckkkkk~

December 31, 1969, 7:00 pm by

I hope everything goes well! Good luck!

December 31, 1969, 7:00 pm by

Good luck hun!

December 31, 1969, 7:00 pm by

GOOD LUCK and thanx for making improvements for our benfit thats the reason we love this site so much!

December 31, 1969, 7:00 pm by

Thanks for the update. Hope all goes well.

December 31, 1969, 7:00 pm by

good luck sweetie

December 31, 1969, 7:00 pm by

Good luck Alex

December 31, 1969, 7:00 pm by

Good luck! I hope it goes smoothly.

December 31, 1969, 7:00 pm by

D :

December 31, 1969, 7:00 pm by

luck! X3

December 31, 1969, 7:00 pm by

good luck!

December 31, 1969, 7:00 pm by

Thank you for the update and best of luck

December 31, 1969, 7:00 pm by

Good Luck ... keep up the great work!

December 31, 1969, 7:00 pm by

I am wishing you luck!

December 31, 1969, 7:00 pm by

Oh I hope nothing goes wrong. That would be awful.

December 31, 1969, 7:00 pm by

GOOD LUCK!!!!!!!!!!!!!!!!!

Use @username to mention someone. Supports markdown formatting.

Logged Out

Leave a Comment