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
Posted by alx
User not found:
Good Luck !!!!!!!!!!!!!!
<img src="http://images.subeta.net/smilies/6398_emoticon_smile.gif" border="0" />
<img src="http://images.subeta.net/smilies/6398_emoticon_smile.gif" border="0" />
0
User not found:
I made my HA look like alx
0
alx
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?
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?
0
DaBluMeanie
there are forum posts that are over 2 years old --- won't deleting them free up space?
0
znogirl
Have at it Alex. You can do it! <img src="http://images.subeta.net/smilies/6398_emoticon_happy.gif" border="0" />
0
Kadiaa
best of luck <img src="http://images.subeta.net/smilies/6398_emoticon_wink.gif" border="0" />
0
Beowulf
good luck! Hopefully everything will go smoothly <img src="http://images.subeta.net/smilies/6398_emoticon_smile.gif" border="0" />
0
Divine
Thanks for the update, I wish you the best of luck! <img src="http://images.subeta.net/smilies/6398_emoticon_grin.gif" border="0" /> Not sure if I can survive TWO WHOLE HOURS without Subeta, but I'll try xD
0
Maple
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. <img src="http://images.subeta.net/smilies/6398_emoticon_shocked.gif" border="0" />
Oh well, good luck! Hopefully it ends on time (or earlier) and there's no problems. <img src="http://images.subeta.net/smilies/6398_emoticon_shocked.gif" border="0" />
0
Sorcerer
Darn, with no subeta it looks like I will need to go to bed tonight. <img src="http://images.subeta.net/smilies/6398_emoticon_raspberry.gif" border="0" />
GOOD LUCK!! I HOPE EVERYTHING GOES WELL!
GOOD LUCK!! I HOPE EVERYTHING GOES WELL!
0
VOGUE
Good luck! hope it goes well & thanks for the update. <img src="http://images.subeta.net/smilies/6398_emoticon_wink.gif" border="0" />
0
RyoSakumi
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). <img src="http://images.subeta.net/smilies/6398_emoticon_happy.gif" border="0" />
GOOD LIKE Subeta Staff!!!!!!!!!!1
Make everything 1337!!!!!1 (for anyone who does not know what that is then google it noob). <img src="http://images.subeta.net/smilies/6398_emoticon_happy.gif" border="0" />
0
Smaug
yay ^^ good luxk, I love how you guys keep us in the loop <img src="http://images.subeta.net/smilies/6398_emoticon_grin.gif" border="0" />
0
User not found:
Wishing you luck, and thank for the update, now I have to find something else to do <img src="http://images.subeta.net/smilies/6398_emoticon_sweatdrop.gif" border="0" />
0
RubberSoul
Oh sweet geez.
Two hours is a long time. <img src="http://images.subeta.net/smilies/smiley_sadface.gif" border="0" />
But good luck anyhoo. :c
Two hours is a long time. <img src="http://images.subeta.net/smilies/smiley_sadface.gif" border="0" />
But good luck anyhoo. :c
0
Catwoman
Thanks for the update and for everything.
Good luck! <img src="http://images.subeta.net/smilies/6398_emoticon_smile.gif" border="0" />
Good luck! <img src="http://images.subeta.net/smilies/6398_emoticon_smile.gif" border="0" />
0
Cintras
LOL. Not sure I like it when something ends with, "wish us luck." I'll just say, Have a good time! heehee
0
Silver
*crosses fingers* Here's to luck! <img src="http://images.subeta.net/smilies/6398_emoticon_happy.gif" border="0" />
0
User not found:
good luck hun! <img src="http://images.subeta.net/smilies/6398_emoticon_happy_sweatdrop.gif" border="0" />
0
sam4slb
GOOD LUCK and thanx for making improvements for our benfit thats the reason we love this site so much!
0
CrazyKathy
good luck sweetie <img src="http://images.subeta.net/smilies/6398_emoticon_smile.gif" border="0" />
0
SEA
Good luck Alex <img src="http://images.subeta.net/smilies/6398_emoticon_grin.gif" border="0" />
0
User not found:
Good luck! I hope it goes smoothly.
0
User not found:
luck! X3
0
Patty
good luck! <img src="http://images.subeta.net/smilies/6398_emoticon_smile.gif" border="0" />
0
Kris
Thank you for the update and best of luck <img src="http://images.subeta.net/smilies/6398_emoticon_grin.gif" border="0" />
0
mister_ed
I am wishing you luck! <img src="http://images.subeta.net/smilies/6398_emoticon_happy.gif" border="0" />
0
RedSekhmet
Oh I hope nothing goes wrong. <img src="http://images.subeta.net/smilies/6398_emoticon_sad.gif" border="0" /> That would be awful.
0
Radi0rulz
GOOD LUCK!!!!!!!!!!!!!!!!! <img src="http://images.subeta.net/smilies/6398_emoticon_smile.gif" border="0" />
0