[Toolserver-l] sql (user databases) unplanned maintenance

[River Tarnell]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

hi,

the user database server (zedler) has run out of space on the MySQL
filesystem; however, there is still 250GB free in the InnoDB table
space.  to reclaim this free space, we need to dump the reload the
database.  the database will be inaccessible while this is in progress.

based on the time taken to run nightly backups, the dump should take
about 5 hours.  however, i will run it in parallel to improve
performance.  it will take a bit longer to reload it afterwards.

after the reload, i will not restore the commonswiki replica that was
previously on the sql server.  the correct way to join user databases to
commons is to create them on the sql-s4 server.

	- river.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (HP-UX)

iEYEARECAAYFAkqmQNIACgkQIXd7fCuc5vKa/QCfUvvQrs8XaNiztiUTxrS8xA26
0lkAoIpHExWtaamKeKAkXv3YplMnx+zL
=Ivmb
-----END PGP SIGNATURE-----