diff options
| author | Dennis Collinson <dennis.collective@gmail.com> | 2012-02-02 23:50:00 +0400 |
|---|---|---|
| committer | Dennis Collinson <dennis.collective@gmail.com> | 2012-02-02 23:50:00 +0400 |
| commit | d1a82d288dabcc0e1576538f85227173ba6a99fb (patch) | |
| tree | 4e66142c7a10006f33e6a64e90a52a59c95b7eed /db | |
| parent | 7bd6a450a0893ef2d3d48c67f56cd0c1672fb6ae (diff) | |
moar verbose comment [ci skip]
Diffstat (limited to 'db')
| -rw-r--r-- | db/migrate/20120202190701_remove_public_share_visibilities.rb | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/db/migrate/20120202190701_remove_public_share_visibilities.rb b/db/migrate/20120202190701_remove_public_share_visibilities.rb index aa30a696c..8cec71311 100644 --- a/db/migrate/20120202190701_remove_public_share_visibilities.rb +++ b/db/migrate/20120202190701_remove_public_share_visibilities.rb @@ -1,5 +1,10 @@ # NOTE: this migration will remove a lot of unused rows. It is highly suggested # that you run `OPTIMIZE TABLE share_visibilities` after this +# `OPTIMIZE NO_WRITE_TO_BINLOG TABLE share_visibilities;` will run faster but has a greater chance of corrupting data +# and will only work on an unsharded database (which should be the case for everyone right now) +# you probably want to backup your db before you do any of this. + + # migration is complete. # # caution: you may want to take your pod offline during the OPTIMIZE command. |