maria-discuss team mailing list archive
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 <
> 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
> - 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
> 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