i have to modify primary for partitioning. pt-online-schema-change complaints about dropping primary.Still i can ignore the warning and proceed. Thanks From: Guillaume Lefranc <guillaume@adishatz.net> To: Suresh Rajagopal <sureshr7@gmail.com>; Maria Discuss <maria-discuss@lists.launchpad.net> Sent: Monday, March 13, 2017 6:08 PM Subject: Re: [Maria-discuss] Partition a Huge table Use pt-online-schema-change. Best regardsGL Le mar. 14 mars 2017 à 08:35, Suresh Rajagopal <sureshr7@gmail.com> 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.18OS : Centos 6 ThanksSuresh_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp