mark: A photo of Mark kneeling on top of the Taal Volcano in the Philippines. It was a long hike. (Default)
Mark Smith ([staff profile] mark) wrote in [site community profile] dw_maintenance2012-04-24 12:28 pm

database maintenance

Hi all,

Over last night and this morning I've done some database maintenance on our global slave. This should be transparent and cause no problems, but please let me know if you see anything amiss.

For the technically curious, I had to do a dump-and-reload on our MySQL instance so that I could free up space in the InnoDB data file. It had grown to ~240GB back when the machine was also home to the user data, but now that it is just used for global data, it is only about 8GB.

After things are settled for a few days, I will have to perform the same operation on the global master. That will be slightly more exciting, but should cause no downtime either.
greyduck: Star Trek - Cetacean Needed (Star Trek - Cetacean Needed)

[personal profile] greyduck 2012-04-24 07:45 pm (UTC)(link)
I like that "slightly more exciting." *grin*
sgsabbage: (Default)

[personal profile] sgsabbage 2012-04-24 07:55 pm (UTC)(link)
I had to do the exact same thing on one of our servers this week, it's rather irritating that the data file can't be shrunk without dropping the databases. Turning on the file-per-table option seems to make it a little more maintainable, though.
ccommack: (Default)

[personal profile] ccommack 2012-04-25 01:39 am (UTC)(link)
Probably a dumb question, but: is there a particular reason why 11.04 and 11.10 are worse than 10.04? Not been around long enough to have the rock-solid stability DW wants and needs?
sharpiefan: Coffee beans, coffee grinder and coffee pot, text 'Coffee' (Coffee)

[personal profile] sharpiefan 2012-04-24 08:11 pm (UTC)(link)
Don't know if it's due to this, but I'm having notification delays...
sharpiefan: Napoleonic soldier with a cup of tea, text 'tea break, dammit' (Tea break)

[personal profile] sharpiefan 2012-04-24 08:24 pm (UTC)(link)
OK. Hope so! Thanks for looking at it!
dmsj: (working)

[personal profile] dmsj 2012-04-24 09:14 pm (UTC)(link)
It would appear that things are not crossposting to LJ properly. I'll keep poking around at my entry, but I can't *see* anything wrong. When I go in to change it, the box is unchecked. I check it, click Save, and it says it's crossposting.... but it doesn't, and my Inbox tells me, "Crosspost of Blogged to dawnstar@LiveJournal action failed.
Crosspost to dawnstar@LiveJournal failed.

Failed to crosspost entry to dawnstar@LiveJournal: Failed to connect to"

Is that on our end or theirs?
discodiva76: (Danny Tweet)

[personal profile] discodiva76 2012-04-24 09:18 pm (UTC)(link)
Live Journal is down atm....
wytchcroft: heavent sent (oh f-op!)

[personal profile] wytchcroft 2012-04-24 10:15 pm (UTC)(link)
why be sorry - did you break it? nah, but go on - just for once, let's have an EVIL LAUGH! i don't know, you guys always making with the nice... LOL.
0jack: Closeup of Boba Fett's helmet, angular orange stripe surrounding a narrow window on a greenish metallic field. (Default)

[personal profile] 0jack 2012-04-24 11:29 pm (UTC)(link)
LJ is just jealous of our server troubles and has gone offline so it can be better than us at something—namely BEING BROKEN. Don't worry, LJ. You were always better at that, even though I love you.
swordznsorcery: (queen)

[personal profile] swordznsorcery 2012-04-24 09:45 pm (UTC)(link)
Having a global slave sounds fabulously decadent; and a global master rather brings to mind Ming the Merciless.

This is creating some very interesting mental pictures of DreamWidth HQ. ;)
apis_mellifera: (firefly - i aim to misbehave)

[personal profile] apis_mellifera 2012-04-24 11:45 pm (UTC)(link)
So glad I am not the only one thinking that.
ariandar: (candles)

[personal profile] ariandar 2012-04-25 01:24 am (UTC)(link)
tameiki: (Loveless - Shirtless)

[personal profile] tameiki 2012-04-25 02:13 am (UTC)(link)
This is creating some very interesting mental pictures of DreamWidth HQ

*doubles over laughing* OMG. *gasps for breath*

Yeah, I had a thought along similar BDSM lines when I read that! =D
tameiki: (WK - Who  loves ya Baby)

[personal profile] tameiki 2012-04-25 04:00 am (UTC)(link)
We are a friendly, happy, open, awesome company with an awesome web site...

That, you are, Mark! And I don't blame you for not going there. *snickers*
dragondancer5150: (Default)

[personal profile] dragondancer5150 2012-04-25 04:43 am (UTC)(link)
No idea if this is related or not, but I'm trying to get to and copy the link/web address for one thread on a post. I get email notifications, and I used the "Go to the top of the thread this comment is part of" link in the email. That takes me to the thread, but in the navigation field of my browser, I'm only getting "about:blank" instead of the web address. Going to the original post, and then clicking on "link" of the top comment of the thread also successfully gets me just the thread, but now it doesn't change the web address from the "base" to the one with the..."extension"? - not sure that's the right word - for just the thread.

If it helps, the post I'm talking about is - - and I'm trying to get the address for /just/ the thread that starts with "derpjack_ftw".

No idea if this has to do with the maintenance or not, but since you said "if you see anything amiss", and I've never had this problem before.

denise: Image: Me, facing away from camera, on top of the Castel Sant'Angelo in Rome (Default)

[staff profile] denise 2012-04-25 05:06 am (UTC)(link)
That definitely sounds like something with your browser! Here's your thread:
dragondancer5150: (Default)

[personal profile] dragondancer5150 2012-04-25 05:21 am (UTC)(link)
Huh. I'll have to see if I can figure it out then.

jae: (internetgecko)

[personal profile] jae 2012-04-25 07:08 am (UTC)(link)
I have no idea what that first sentence means, but I find it hilarious. Thank you for the amusement! :)

Edited (wrong icon!) 2012-04-25 07:08 (UTC)
kuzimama: (Default)

[personal profile] kuzimama 2012-04-25 01:44 pm (UTC)(link)
good job, keep it simple :))))))))))))))))))
ext_97868: (Default)

[identity profile] 2012-04-26 02:22 am (UTC)(link)
I don't know if this is related, but I had some trouble using my OpenID login. LJ is my main OID identity, but I tried using my Google URL also and it still gave me an error along the lines of "website is not authenticating." Obviously, it eventually let me it, but if other people are having the same problem they may not be able to report it as no login = anon = can't reply here.
(deleted comment)