Use pt-online-schema-change. Best regards GL
Le mar. 14 mars 2017 à 08:35, Suresh Rajagopal <[email protected]> a écrit : > Hi, > > What is the fastest approach to partition a huge table with 2 additional > columns? How safe its to alter table on slave and promote slave as master? > It takes 25 hours to alter the table for now on slave. > > MariaDB Version : 10.1.18 > OS : Centos 6 > > Thanks > Suresh > _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
