Rajagopal
Cc: Guillaume Lefranc ; Maria Discuss
Sent: Tuesday, March 14, 2017 8:45 AM
Subject: Re: [Maria-discuss] Partition a Huge table
Hi Suresh,
- If the DML activities are not on the historical data (hot dataset and cold
dataset), then shall we create a empty partitioned table
can ignore the warning and
> proceed.
>
> Thanks
>
>
> --
> *From:* Guillaume Lefranc
> *To:* Suresh Rajagopal ; Maria Discuss <
> maria-discuss@lists.launchpad.net>
> *Sent:* Monday, March 13, 2017 6:08 PM
> *Subject:* Re: [Maria-discuss] Partition a Huge table
>
&g
] Partition a Huge table
Use pt-online-schema-change.
Best regardsGL
Le mar. 14 mars 2017 à 08:35, Suresh Rajagopal 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
, March 13, 2017 6:07 PM
Subject: Re: [Maria-discuss] Partition a Huge table
Hi SuershI would add a second slave as insurance before doing this to provide
some risk mitigation. Make sure you have adequate spare space on your slave as
you will want as much again as the table to make changes. make
Hi Suersh
I would add a second slave as insurance before doing this to provide some
risk mitigation. Make sure you have adequate spare space on your slave as
you will want as much again as the table to make changes. make sure you
have chosen the right approach to your partitioning before doing anyt
Use pt-online-schema-change.
Best regards
GL
Le mar. 14 mars 2017 à 08:35, Suresh Rajagopal 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
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__
7 matches
Mail list logo
