<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 Deleted User

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

December 31, 1969, 7:00 pm by DaBluMeanie
User Avatar

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

December 31, 1969, 7:00 pm by Deleted User

I made my HA look like alx

December 31, 1969, 7:00 pm by alx
User Avatar

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 NK
User Avatar

Toot!

December 31, 1969, 7:00 pm by PopieTart
User Avatar

Good luck!!!!

December 31, 1969, 7:00 pm by StrawberryRamen
User Avatar

best of luck!

December 31, 1969, 7:00 pm by DaBluMeanie
User Avatar

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

December 31, 1969, 7:00 pm by znogirl
User Avatar

Have at it Alex. You can do it!

December 31, 1969, 7:00 pm by simba
User Avatar

Knock on wood and good luck!

December 31, 1969, 7:00 pm by alx
User Avatar

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

December 31, 1969, 7:00 pm by happydorkgirl
User Avatar

Thanks for the update. Good luck to all!

December 31, 1969, 7:00 pm by Kadiaa
Avatar Border
User Avatar

best of luck

December 31, 1969, 7:00 pm by Chook_865
User Avatar

Good luck and thanks for letting us know.

December 31, 1969, 7:00 pm by Flarien
User Avatar

Good luck =)

December 31, 1969, 7:00 pm by Beowulf
Avatar Border
User Avatar

good luck! Hopefully everything will go smoothly

December 31, 1969, 7:00 pm by Divine
Avatar Border
User Avatar

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 Maple
Avatar Border
User Avatar

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 Sorcerer
Avatar Border
User Avatar

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 VOGUE
User Avatar

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

December 31, 1969, 7:00 pm by RyoSakumi
User Avatar

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 johnB
User Avatar

Aww

December 31, 1969, 7:00 pm by Smaug
User Avatar

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

December 31, 1969, 7:00 pm by Alkuna
Avatar Border
User Avatar

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

December 31, 1969, 7:00 pm by Deleted User

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

December 31, 1969, 7:00 pm by Note_920
User Avatar

Good luck guys~ C:

December 31, 1969, 7:00 pm by Sarah
User Avatar

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

December 31, 1969, 7:00 pm by Catwoman
User Avatar

Thanks for the update and for everything.

Good luck!

December 31, 1969, 7:00 pm by Neori
User Avatar

GOOD LUCK! :HEART:

December 31, 1969, 7:00 pm by Cintras
User Avatar

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 Silver
Avatar Border
User Avatar

crosses fingers Here's to luck!

December 31, 1969, 7:00 pm by fenikkusu64
User Avatar

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

December 31, 1969, 7:00 pm by Draken
User Avatar

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

December 31, 1969, 7:00 pm by Deleted User

good luck hun!

December 31, 1969, 7:00 pm by Dreamer
User Avatar

Good luckkkkk~

December 31, 1969, 7:00 pm by Skull
Avatar Border
User Avatar

I hope everything goes well! Good luck!

December 31, 1969, 7:00 pm by Life
Avatar Border
User Avatar

Good luck hun!

December 31, 1969, 7:00 pm by sam4slb
Avatar Border
User Avatar

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 Bubbledog
User Avatar

Thanks for the update. Hope all goes well.

December 31, 1969, 7:00 pm by CrazyKathy
User Avatar

good luck sweetie

December 31, 1969, 7:00 pm by SEA
Avatar Border
User Avatar

Good luck Alex

December 31, 1969, 7:00 pm by Deleted User

Good luck! I hope it goes smoothly.

December 31, 1969, 7:00 pm by Sensuous
Avatar Border
User Avatar

D :

December 31, 1969, 7:00 pm by Deleted User

luck! X3

December 31, 1969, 7:00 pm by Patty_303
User Avatar

good luck!

December 31, 1969, 7:00 pm by Kris
Avatar Border
User Avatar

Thank you for the update and best of luck

December 31, 1969, 7:00 pm by gatorgirl
Avatar Border
User Avatar

Good Luck ... keep up the great work!

December 31, 1969, 7:00 pm by mister_ed
Avatar Border
User Avatar

I am wishing you luck!

December 31, 1969, 7:00 pm by RedSekhmet
User Avatar

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

December 31, 1969, 7:00 pm by Radi0rulz
Avatar Border
User Avatar

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

Leave a Comment

Use @username to mention someone. Supports markdown formatting.