Table locks can be a real pain. You know you need to do the change, but the system is constantly running queries towards it. Now days it’s a bit easier with algorithm=inplace and lock=none, but in the good old days you were on your own. Your only friend was luck. Large migrations like that still gives me shivers
Table locks can be a real pain. You know you need to do the change, but the system is constantly running queries towards it. Now days it’s a bit easier with
algorithm=inplace
andlock=none
, but in the good old days you were on your own. Your only friend was luck. Large migrations like that still gives me shivers