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 <[email protected]>
To: Suresh Rajagopal <[email protected]>; Maria Discuss
<[email protected]>
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 <[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.18OS : Centos 6
ThanksSuresh_______________________________________________
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
