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.
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*