Changes between Initial Version and Version 1 of Ticket #30773, comment 1


Ignore:
Timestamp:
Sep 13, 2019, 5:21:09 PM (5 years ago)
Author:
Simon Charette

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #30773, comment 1

    initial v1  
    1 MySQL will use the best algorithm available by default if possible (`INPLACE` or `INSTANT`) so this option will only make the operation crash if the specified algorithm is not available. Given MySQL doesn't support transactional DDL this has the potential to cause more harm than good IMO.
     1MySQL will use the best algorithm available by default if possible (`INPLACE` or `INSTANT`) so this option will only make the operation crash if the specified algorithm is not available. Given MySQL doesn't support transactional DDL this has the potential to cause more harm than good if a migration has multiple operations IMO.
    22
    33I guess we could add support for `algorithm` to MySQL schema editor but as I mentioned above MySQL already picks the ''best'' algorithm it can and I can't see a reason for using `COPY` or `INPLACE` when `INSTANT` is supported.
Back to Top