← Back to team overview

maria-discuss team mailing list archive

Re: ALTER TABLE ENIGNE=InnoDB performance



Have you considered using Xtrabackup to create a replication slave?  This
is essentially a binary copy kept in sync with the innodb transaction log,
and it works great.

On Wed, Jan 17, 2018 at 12:55 PM, Conor Murphy <
conor_mark_murphy@xxxxxxxxxxx> wrote:

> Hi Marko,
> I don't think that's an option
> - It would interfere with the normal operations on the master, currently
> we use a "FLUSH TABLES WITH READ LOCK" with an LVM snapshot to get a
> consistent copy of the database while the system is up and running.
> Changing the PARTITIONs to TABLEs would mean having to stop the running
> system.
> - I haven't checked this in a while (> a year), but the last time we
> looked at swapping a TABLE back to a PARTITION, it took hours, I think it's
> because it validates that the rows in the TABLE belong in the PARTITION
> according to the partitioning scheme. MySQL has the "WITHOUT VALIDATION"
> option to overcome this
> Regards,
> Conor
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp

Follow ups