Quote:
Originally Posted by GrouchyAdmin
Hey Kittypants!
As slow and often as this system seems to just 'go away', do you have any idea how long it'd take to rebuild an InnoDB setup?
Plus, then they'd have to migrate away from 3.23.  |
3.23 - ahh the good old days
True that ALTER TABLE would be a bitch...but there are other ways it can be achieved. For example, take a backup and import it on a different server, run the ALTER and whenever it's done, switch that to be your new MASTER and run a script to copy the missing rows over (update auto_increment values if you have to, to avoid duplicate row issues).
Some threads/posts might be gone very temporarily but your downtime would be way less. I'm sure there are plenty of other alternatives as well, but I don't feel like thinking it's Friday and time to go down a few
