maria-discuss team mailing list archive
Mailing list archive
Re: ALTER TABLE ENIGNE=InnoDB performance
Did you try the following?
ALTER TABLE t1 EXCHANGE PARTITION p1 WITH TABLE t2;
It might allow you to work around the problem. You'd first need to
convert the partitions to tables, then export and import the .ibd
files, and finally exchange with partitions again.
Disclaimer: I only know InnoDB, not partitioning. I hope that this
will actually only rename the tables inside InnoDB. (In InnoDB, each
partition is treated as a separate table.)
Marko Mäkelä, Lead Developer InnoDB
MariaDB User Conference
February 26 - 27, 2018
New York City