• Thirunarayanan Balathandayuthapani's avatar
    MDEV-13134 Introduce ALTER TABLE attributes ALGORITHM=NOCOPY and ALGORITHM=INSTANT · 85cc6b70
    Thirunarayanan Balathandayuthapani authored
    Introduced new alter algorithm type called NOCOPY & INSTANT for
    inplace alter operation.
    
    NOCOPY - Algorithm refuses any alter operation that would
    rebuild the clustered index. It is a subset of INPLACE algorithm.
    
    INSTANT - Algorithm allow any alter operation that would
    modify only meta data. It is a subset of NOCOPY algorithm.
    
    Introduce new variable called alter_algorithm. The values are
    DEFAULT(0), COPY(1), INPLACE(2), NOCOPY(3), INSTANT(4)
    
    Message to deprecate old_alter_table variable and make it alias
    for alter_algorithm variable.
    
    alter_algorithm variable for slave is always set to default.
    85cc6b70
alter_instant.inc 903 Bytes